diff options
Diffstat (limited to 'src/test/regress/expected/int4.out')
| -rw-r--r-- | src/test/regress/expected/int4.out | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/src/test/regress/expected/int4.out b/src/test/regress/expected/int4.out index 3e0eff13a31..a21bbda2c9f 100644 --- a/src/test/regress/expected/int4.out +++ b/src/test/regress/expected/int4.out @@ -9,24 +9,40 @@ INSERT INTO INT4_TBL(f1) VALUES ('123456 '); INSERT INTO INT4_TBL(f1) VALUES (' -123456'); INSERT INTO INT4_TBL(f1) VALUES ('34.5'); ERROR: invalid input syntax for integer: "34.5" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('34.5'); + ^ -- largest and smallest values INSERT INTO INT4_TBL(f1) VALUES ('2147483647'); INSERT INTO INT4_TBL(f1) VALUES ('-2147483647'); -- bad input values -- should give errors INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); ERROR: value "1000000000000" is out of range for type integer +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); + ^ INSERT INTO INT4_TBL(f1) VALUES ('asdf'); ERROR: invalid input syntax for integer: "asdf" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('asdf'); + ^ INSERT INTO INT4_TBL(f1) VALUES (' '); ERROR: invalid input syntax for integer: " " +LINE 1: INSERT INTO INT4_TBL(f1) VALUES (' '); + ^ INSERT INTO INT4_TBL(f1) VALUES (' asdf '); ERROR: invalid input syntax for integer: " asdf " +LINE 1: INSERT INTO INT4_TBL(f1) VALUES (' asdf '); + ^ INSERT INTO INT4_TBL(f1) VALUES ('- 1234'); ERROR: invalid input syntax for integer: "- 1234" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('- 1234'); + ^ INSERT INTO INT4_TBL(f1) VALUES ('123 5'); ERROR: invalid input syntax for integer: "123 5" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('123 5'); + ^ INSERT INTO INT4_TBL(f1) VALUES (''); ERROR: invalid input syntax for integer: "" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES (''); + ^ SELECT '' AS five, * FROM INT4_TBL; five | f1 ------+------------- |