[#IDEADEV-26732] SQL support: SQL-92: column constraint definition with the only name is not reported as error

IDEA: Development

SQL support: SQL-92: column constraint definition with the only name is not reported as error

Created: 20 May 08 21:37 Updated: 20 May 08 21:38

Component/s:

SQL

Fix Version/s:

None

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Build:

8,387

Description

« Hide

The following statement:

 create table rubbish.u1 ( id integer primary key, c1 integer constraint c1c1 );

is green in SQL-92. Actually column constraint definition should have constraint itself, not only name.

         <column constraint definition> ::=
              [ <constraint name definition> ]
              <column constraint>
                [ <constraint attributes> ]

         <column constraint> ::=
                NOT NULL
              | <unique specification>
              | <references specification>
              | <check constraint definition>

All

Comments

Work Log

Change History

Sort Order:

There are no comments yet on this issue.