History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: IDEADEV-26732
Type: Bug Bug
Status: Open Open
Priority: Normal Normal
Assignee: Gregory Shrago
Reporter: Alexander Chernikov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
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.