aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2004-03-12 14:08:05 +0000
committerBruce Momjian <bruce@momjian.us>2004-03-12 14:08:05 +0000
commit73f3ab692dbe6118b0286f0561807f343bb5e7fe (patch)
tree14e74405d62c24c0b13ed85ea678f046c66b9c76 /src
parente3d6ee6c28b44ff241bb5de3ec9d97c1f8b93f16 (diff)
downloadpostgresql-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
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/int8-exp-three-digits-win32.out15
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
------------------+-------------------