From 79f39c4d3417e89effedad4b13c840765c869d25 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 20 Nov 1999 21:41:31 +0000 Subject: [PATCH] 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. --- src/test/regress/input/constraints.source | 4 ++-- src/test/regress/output/constraints.source | 6 +++--- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/src/test/regress/input/constraints.source b/src/test/regress/input/constraints.source index a4f02d59d7..af10193c33 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 6b905e7f42..d7bb59cbf8 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)); -- 2.40.0