Changeset: c096265d9f8b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c096265d9f8b
Modified Files:
sql/server/sql_parser.y
Branch: literal_features
Log Message:
Also introduce explicit UNIQUE NULLS DISTINCT syntax
diffs (20 lines):
diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y
--- a/sql/server/sql_parser.y
+++ b/sql/server/sql_parser.y
@@ -2144,6 +2144,7 @@ column_constraint_type:
NOT sqlNULL { $$ = _symbol_create( SQL_NOT_NULL, NULL); }
| sqlNULL { $$ = _symbol_create( SQL_NULL, NULL); }
| UNIQUE { $$ = _symbol_create( SQL_UNIQUE, NULL ); }
+ | UNIQUE NULLS DISTINCT { $$ = _symbol_create( SQL_UNIQUE, NULL ); }
| UNIQUE NULLS NOT DISTINCT { $$ = _symbol_create(
SQL_UNIQUE_NULLS_NOT_DISTINCT, NULL ); }
| PRIMARY KEY { $$ = _symbol_create( SQL_PRIMARY_KEY, NULL ); }
| REFERENCES qname opt_column_list opt_match opt_ref_action
@@ -2161,6 +2162,8 @@ column_constraint_type:
table_constraint_type:
UNIQUE column_commalist_parens
{ $$ = _symbol_create_list( SQL_UNIQUE, $2); }
+ | UNIQUE NULLS DISTINCT column_commalist_parens
+ { $$ = _symbol_create_list( SQL_UNIQUE, $4); }
| UNIQUE NULLS NOT DISTINCT column_commalist_parens
{ $$ = _symbol_create_list(
SQL_UNIQUE_NULLS_NOT_DISTINCT, $5); }
| PRIMARY KEY column_commalist_parens
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
