summaryrefslogtreecommitdiff
path: root/src/test/regress/input
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/input')
-rw-r--r--src/test/regress/input/constraints.source13
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