diff options
Diffstat (limited to 'src/test/regress/expected/char.out')
-rw-r--r-- | src/test/regress/expected/char.out | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/src/test/regress/expected/char.out b/src/test/regress/expected/char.out index d515b3ce34e..2d78f90f3b9 100644 --- a/src/test/regress/expected/char.out +++ b/src/test/regress/expected/char.out @@ -11,8 +11,9 @@ SELECT char 'c' = char 'c' AS true; -- -- Build a table for testing +-- (This temporarily hides the table created in test_setup.sql) -- -CREATE TABLE CHAR_TBL(f1 char); +CREATE TEMP TABLE CHAR_TBL(f1 char); INSERT INTO CHAR_TBL (f1) VALUES ('a'); INSERT INTO CHAR_TBL (f1) VALUES ('A'); -- any of the following three input formats are acceptable @@ -104,13 +105,11 @@ DROP TABLE CHAR_TBL; -- -- Now test longer arrays of char -- -CREATE TABLE CHAR_TBL(f1 char(4)); -INSERT INTO CHAR_TBL (f1) VALUES ('a'); -INSERT INTO CHAR_TBL (f1) VALUES ('ab'); -INSERT INTO CHAR_TBL (f1) VALUES ('abcd'); +-- This char_tbl was already created and filled in test_setup.sql. +-- Here we just try to insert bad values. +-- INSERT INTO CHAR_TBL (f1) VALUES ('abcde'); ERROR: value too long for type character(4) -INSERT INTO CHAR_TBL (f1) VALUES ('abcd '); SELECT * FROM CHAR_TBL; f1 ------ |