diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1997-10-25 06:03:08 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1997-10-25 06:03:08 +0000 |
| commit | f15eeff1bd8f0a7928042b487d9bae6180c04bf0 (patch) | |
| tree | 4e8bcc83dc9e5d1625b9432214186c2dc44468d0 /src | |
| parent | ac357fb44c28746936bd7fff128636fcc2336d8b (diff) | |
| download | postgresql-f15eeff1bd8f0a7928042b487d9bae6180c04bf0.tar.gz postgresql-f15eeff1bd8f0a7928042b487d9bae6180c04bf0.zip | |
Modify to reflect changes in boolean input behavior (rejects bad input
rather than assuming FALSE).
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/boolean.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/boolean.sql | 7 |
2 files changed, 8 insertions, 2 deletions
diff --git a/src/test/regress/expected/boolean.out b/src/test/regress/expected/boolean.out index d69ba887f7f..9f302a217c0 100644 --- a/src/test/regress/expected/boolean.out +++ b/src/test/regress/expected/boolean.out @@ -98,8 +98,11 @@ QUERY: CREATE TABLE BOOLTBL2 (f1 bool); QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('f'::bool); QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('false'::bool); QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('False'::bool); +QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('FALSE'::bool); QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('XXX'::bool); +WARN:Invalid input string 'XXX' + QUERY: SELECT '' AS f_4, BOOLTBL2.*; f_4|f1 ---+-- diff --git a/src/test/regress/sql/boolean.sql b/src/test/regress/sql/boolean.sql index a62a2e92609..9aa7f343a38 100644 --- a/src/test/regress/sql/boolean.sql +++ b/src/test/regress/sql/boolean.sql @@ -1,7 +1,7 @@ -- -- boolean.source -- --- $Header: /cvsroot/pgsql/src/test/regress/sql/boolean.sql,v 1.3 1997/05/09 03:26:43 scrappy Exp $ +-- $Header: /cvsroot/pgsql/src/test/regress/sql/boolean.sql,v 1.4 1997/10/25 06:02:33 thomas Exp $ -- -- @@ -70,7 +70,10 @@ INSERT INTO BOOLTBL2 (f1) VALUES ('false'::bool); INSERT INTO BOOLTBL2 (f1) VALUES ('False'::bool); --- this evaluates to a false value +INSERT INTO BOOLTBL2 (f1) VALUES ('FALSE'::bool); + +-- this is now an invalid expression +-- pre-v6.3 this evaluated to false - thomas 1997-10-23 INSERT INTO BOOLTBL2 (f1) VALUES ('XXX'::bool); |