diff options
| author | Tom Lane | 2005-12-05 04:14:27 +0000 |
|---|---|---|
| committer | Tom Lane | 2005-12-05 04:14:27 +0000 |
| commit | 8b20f8a51deef702047cf2d6c1872de37644205a (patch) | |
| tree | 3a81e4bbc5bef6f681facb5c0c477fdf611f9263 /src/test | |
| parent | 22868b9e39668d7cd067eb2406ae6c95c8d31b5b (diff) | |
Add regression test to see if the min/max values of int8 convert correctly.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/int8-exp-three-digits.out | 17 | ||||
| -rw-r--r-- | src/test/regress/expected/int8.out | 17 | ||||
| -rw-r--r-- | src/test/regress/sql/int8.sql | 6 |
3 files changed, 40 insertions, 0 deletions
diff --git a/src/test/regress/expected/int8-exp-three-digits.out b/src/test/regress/expected/int8-exp-three-digits.out index e1eb64792c6..5e7b4b468c4 100644 --- a/src/test/regress/expected/int8-exp-three-digits.out +++ b/src/test/regress/expected/int8-exp-three-digits.out @@ -283,3 +283,20 @@ SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM INT8_TBL; | 456789-0123456789 (5 rows) +-- check min/max values +select '-9223372036854775808'::int8; + int8 +---------------------- + -9223372036854775808 +(1 row) + +select '-9223372036854775809'::int8; +ERROR: integer out of range +select '9223372036854775807'::int8; + int8 +--------------------- + 9223372036854775807 +(1 row) + +select '9223372036854775808'::int8; +ERROR: integer out of range diff --git a/src/test/regress/expected/int8.out b/src/test/regress/expected/int8.out index 931889c4ad9..ef51a1f163f 100644 --- a/src/test/regress/expected/int8.out +++ b/src/test/regress/expected/int8.out @@ -283,3 +283,20 @@ SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM INT8_TBL; | 456789-0123456789 (5 rows) +-- check min/max values +select '-9223372036854775808'::int8; + int8 +---------------------- + -9223372036854775808 +(1 row) + +select '-9223372036854775809'::int8; +ERROR: integer out of range +select '9223372036854775807'::int8; + int8 +--------------------- + 9223372036854775807 +(1 row) + +select '9223372036854775808'::int8; +ERROR: integer out of range diff --git a/src/test/regress/sql/int8.sql b/src/test/regress/sql/int8.sql index b5cb13480be..08fd665b11c 100644 --- a/src/test/regress/sql/int8.sql +++ b/src/test/regress/sql/int8.sql @@ -53,3 +53,9 @@ SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL; SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL; SELECT '' AS to_char_16, to_char(q2, '99999 "text" 9999 "9999" 999 "\\"text between quote marks\\"" 9999') FROM INT8_TBL; SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM INT8_TBL; + +-- check min/max values +select '-9223372036854775808'::int8; +select '-9223372036854775809'::int8; +select '9223372036854775807'::int8; +select '9223372036854775808'::int8; |