aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>1999-11-20 21:41:31 +0000
committerTom Lane <tgl@sss.pgh.pa.us>1999-11-20 21:41:31 +0000
commit79f39c4d3417e89effedad4b13c840765c869d25 (patch)
treecab344226a9f31bbf8fe1b98536d748f150f3153
parentea4ae108493a6e2e4f975248907686277e68e9d9 (diff)
downloadpostgresql-79f39c4d3417e89effedad4b13c840765c869d25.tar.gz
postgresql-79f39c4d3417e89effedad4b13c840765c869d25.zip
My latest fixes to gram.y cause CREATE TABLE t (f1 bool default 1 < 2)
to be accepted, but constraints regress test was expecting it to fail.
-rw-r--r--src/test/regress/input/constraints.source4
-rw-r--r--src/test/regress/output/constraints.source6
2 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/input/constraints.source b/src/test/regress/input/constraints.source
index a4f02d59d7d..af10193c333 100644
--- a/src/test/regress/input/constraints.source
+++ b/src/test/regress/input/constraints.source
@@ -40,9 +40,9 @@ 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);
+CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
-- this should work, however:
-CREATE TABLE error_tbl (b1 bool DEFAULT (1 < 2));
+CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));
DROP TABLE error_tbl;
diff --git a/src/test/regress/output/constraints.source b/src/test/regress/output/constraints.source
index 6b905e7f42c..d7bb59cbf81 100644
--- a/src/test/regress/output/constraints.source
+++ b/src/test/regress/output/constraints.source
@@ -33,9 +33,9 @@ four| i1|i2
QUERY: CREATE TABLE error_tbl (i int DEFAULT (100, ));
ERROR: parser: parse error at or near ","
-QUERY: CREATE TABLE error_tbl (b1 bool DEFAULT 1 < 2);
-ERROR: parser: parse error at or near "<"
-QUERY: CREATE TABLE error_tbl (b1 bool DEFAULT (1 < 2));
+QUERY: CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
+ERROR: parser: parse error at or near "in"
+QUERY: CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));
QUERY: DROP TABLE error_tbl;
QUERY: CREATE TABLE CHECK_TBL (x int,
CONSTRAINT CHECK_CON CHECK (x > 3));