diff options
Diffstat (limited to 'src/test/regress/input/constraints.source')
| -rw-r--r-- | src/test/regress/input/constraints.source | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/src/test/regress/input/constraints.source b/src/test/regress/input/constraints.source index a39cb8b0bc..a4f02d59d7 100644 --- a/src/test/regress/input/constraints.source +++ b/src/test/regress/input/constraints.source @@ -34,12 +34,17 @@ INSERT INTO DEFAULTEXPR_TBL (i2) VALUES (NULL); SELECT '' AS four, * FROM DEFAULTEXPR_TBL; --- errors --- test for: --- extraneous comma --- booleans not allowed +-- syntax errors +-- test for extraneous comma CREATE TABLE error_tbl (i int DEFAULT (100, )); +-- this will fail because gram.y uses b_expr not a_expr for defaults, +-- to avoid a shift/reduce conflict that arises from NOT NULL being +-- part of the column definition syntax: CREATE TABLE error_tbl (b1 bool DEFAULT 1 < 2); +-- this should work, however: +CREATE TABLE error_tbl (b1 bool DEFAULT (1 < 2)); + +DROP TABLE error_tbl; -- -- CHECK syntax |
