diff options
author | Bruce Momjian <bruce@momjian.us> | 2004-03-12 14:08:05 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2004-03-12 14:08:05 +0000 |
commit | 73f3ab692dbe6118b0286f0561807f343bb5e7fe (patch) | |
tree | 14e74405d62c24c0b13ed85ea678f046c66b9c76 | |
parent | e3d6ee6c28b44ff241bb5de3ec9d97c1f8b93f16 (diff) | |
download | postgresql-73f3ab692dbe6118b0286f0561807f343bb5e7fe.tar.gz postgresql-73f3ab692dbe6118b0286f0561807f343bb5e7fe.zip |
Fixes recent changes to test. For immediate application.
[ Note: int8-exp-three-digits.out needs the same treatment]
Will review recent changes for float4/8 and implications for win32 when
I get a chance.
Claudio Natoli
-rw-r--r-- | src/test/regress/expected/int8-exp-three-digits-win32.out | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/src/test/regress/expected/int8-exp-three-digits-win32.out b/src/test/regress/expected/int8-exp-three-digits-win32.out index 27d274fe8c7..c766ee52987 100644 --- a/src/test/regress/expected/int8-exp-three-digits-win32.out +++ b/src/test/regress/expected/int8-exp-three-digits-win32.out @@ -8,6 +8,21 @@ INSERT INTO INT8_TBL VALUES('123','4567890123456789'); INSERT INTO INT8_TBL VALUES('4567890123456789','123'); INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789'); INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789'); +-- bad inputs +INSERT INTO INT8_TBL(q1) VALUES (' '); +ERROR: invalid input syntax for type bigint: " " +INSERT INTO INT8_TBL(q1) VALUES ('xxx'); +ERROR: invalid input syntax for type bigint: "xxx" +INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485'); +ERROR: integer out of range +INSERT INTO INT8_TBL(q1) VALUES ('-1204982019841029840928340329840934'); +ERROR: integer out of range +INSERT INTO INT8_TBL(q1) VALUES ('- 123'); +ERROR: invalid input syntax for type bigint: "- 123" +INSERT INTO INT8_TBL(q1) VALUES (' 345 5'); +ERROR: invalid input syntax for type bigint: " 345 5" +INSERT INTO INT8_TBL(q1) VALUES (''); +ERROR: invalid input syntax for type bigint: "" SELECT * FROM INT8_TBL; q1 | q2 ------------------+------------------- |