08.03.2016 17:59, Dmitry Yemanov wrote: > Do you want to throw a syntax error from the parser or something more > intelligent like "duplicate constraint definitions are not allowed" from > DdlNodes?
Standard syntax error from parser is the simplest solution: > SQL> create table t (a integer not null not null); > Statement failed, SQLSTATE = 42000 > SQL error code = -637 > -duplicate specification of NOT NULL - not supported > What about (a int primary key primary key)? Is it also allowed or NOT > NULL is the only problem? It already works this way: > SQL> create table t (a integer primary key primary key); > Statement failed, SQLSTATE = 27000 > unsuccessful metadata update > -CREATE TABLE T failed > -action cancelled by trigger (3) to preserve data integrity > -Attempt to define a second PRIMARY KEY for the same table > SQL> create table t (a integer unique unique); > Statement failed, SQLSTATE = 42000 > unsuccessful metadata update > -CREATE TABLE T failed > -Same set of columns cannot be used in more than one PRIMARY KEY and/or > UNIQUE constraint definition -- WBR, SD. ------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://makebettercode.com/inteldaal-eval Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
