diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/int8-exp-three-digits.out | 10 | ||||
| -rw-r--r-- | src/test/regress/expected/int8.out | 10 | ||||
| -rw-r--r-- | src/test/regress/sql/int8.sql | 5 |
3 files changed, 0 insertions, 25 deletions
diff --git a/src/test/regress/expected/int8-exp-three-digits.out b/src/test/regress/expected/int8-exp-three-digits.out index 6c4f776777d..f433217c5a3 100644 --- a/src/test/regress/expected/int8-exp-three-digits.out +++ b/src/test/regress/expected/int8-exp-three-digits.out @@ -669,8 +669,6 @@ select '-9223372036854775800'::int8 - '9223372036854775800'::int8; ERROR: bigint out of range select '9223372036854775800'::int8 * '9223372036854775800'::int8; ERROR: bigint out of range -select '-9223372036854775808'::int8 / '-1'::int8; -ERROR: bigint out of range select '9223372036854775800'::int8 / '0'::int8; ERROR: division by zero select '9223372036854775800'::int8 % '0'::int8; @@ -683,8 +681,6 @@ select '-9223372036854775800'::int8 - '100'::int4; ERROR: bigint out of range select '9223372036854775800'::int8 * '100'::int4; ERROR: bigint out of range -select '-9223372036854775808'::int8 / '-1'::int4; -ERROR: bigint out of range select '100'::int4 + '9223372036854775800'::int8; ERROR: bigint out of range select '-100'::int4 - '9223372036854775800'::int8; @@ -697,8 +693,6 @@ select '-9223372036854775800'::int8 - '100'::int2; ERROR: bigint out of range select '9223372036854775800'::int8 * '100'::int2; ERROR: bigint out of range -select '-9223372036854775808'::int8 / '-1'::int2; -ERROR: bigint out of range select '-9223372036854775808'::int8 / '0'::int2; ERROR: division by zero select '100'::int2 + '9223372036854775800'::int8; @@ -747,10 +741,6 @@ SELECT CAST('36854775807.0'::float4 AS int8); 36854775808 (1 row) -SELECT CAST('9223372036854775807.0'::float4 AS int8); -ERROR: bigint out of range -SELECT CAST('9223372036854775807.0'::float8 AS int8); -ERROR: bigint out of range SELECT CAST('922337203685477580700.0'::float8 AS int8); ERROR: bigint out of range SELECT CAST(q1 AS oid) FROM INT8_TBL; diff --git a/src/test/regress/expected/int8.out b/src/test/regress/expected/int8.out index 9821f2e68ec..c8e2dad6833 100644 --- a/src/test/regress/expected/int8.out +++ b/src/test/regress/expected/int8.out @@ -669,8 +669,6 @@ select '-9223372036854775800'::int8 - '9223372036854775800'::int8; ERROR: bigint out of range select '9223372036854775800'::int8 * '9223372036854775800'::int8; ERROR: bigint out of range -select '-9223372036854775808'::int8 / '-1'::int8; -ERROR: bigint out of range select '9223372036854775800'::int8 / '0'::int8; ERROR: division by zero select '9223372036854775800'::int8 % '0'::int8; @@ -683,8 +681,6 @@ select '-9223372036854775800'::int8 - '100'::int4; ERROR: bigint out of range select '9223372036854775800'::int8 * '100'::int4; ERROR: bigint out of range -select '-9223372036854775808'::int8 / '-1'::int4; -ERROR: bigint out of range select '100'::int4 + '9223372036854775800'::int8; ERROR: bigint out of range select '-100'::int4 - '9223372036854775800'::int8; @@ -697,8 +693,6 @@ select '-9223372036854775800'::int8 - '100'::int2; ERROR: bigint out of range select '9223372036854775800'::int8 * '100'::int2; ERROR: bigint out of range -select '-9223372036854775808'::int8 / '-1'::int2; -ERROR: bigint out of range select '-9223372036854775808'::int8 / '0'::int2; ERROR: division by zero select '100'::int2 + '9223372036854775800'::int8; @@ -747,10 +741,6 @@ SELECT CAST('36854775807.0'::float4 AS int8); 36854775808 (1 row) -SELECT CAST('9223372036854775807.0'::float4 AS int8); -ERROR: bigint out of range -SELECT CAST('9223372036854775807.0'::float8 AS int8); -ERROR: bigint out of range SELECT CAST('922337203685477580700.0'::float8 AS int8); ERROR: bigint out of range SELECT CAST(q1 AS oid) FROM INT8_TBL; diff --git a/src/test/regress/sql/int8.sql b/src/test/regress/sql/int8.sql index 902149608ed..648563c3744 100644 --- a/src/test/regress/sql/int8.sql +++ b/src/test/regress/sql/int8.sql @@ -139,7 +139,6 @@ select '9223372036854775800'::int8 - '-9223372036854775800'::int8; select '-9223372036854775800'::int8 - '9223372036854775800'::int8; select '9223372036854775800'::int8 * '9223372036854775800'::int8; -select '-9223372036854775808'::int8 / '-1'::int8; select '9223372036854775800'::int8 / '0'::int8; select '9223372036854775800'::int8 % '0'::int8; @@ -149,7 +148,6 @@ select abs('-9223372036854775808'::int8); select '9223372036854775800'::int8 + '100'::int4; select '-9223372036854775800'::int8 - '100'::int4; select '9223372036854775800'::int8 * '100'::int4; -select '-9223372036854775808'::int8 / '-1'::int4; select '100'::int4 + '9223372036854775800'::int8; select '-100'::int4 - '9223372036854775800'::int8; @@ -158,7 +156,6 @@ select '100'::int4 * '9223372036854775800'::int8; select '9223372036854775800'::int8 + '100'::int2; select '-9223372036854775800'::int8 - '100'::int2; select '9223372036854775800'::int8 * '100'::int2; -select '-9223372036854775808'::int8 / '-1'::int2; select '-9223372036854775808'::int8 / '0'::int2; select '100'::int2 + '9223372036854775800'::int8; @@ -176,8 +173,6 @@ SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8); SELECT CAST(q1 AS float4), CAST(q2 AS float8) FROM INT8_TBL; SELECT CAST('36854775807.0'::float4 AS int8); -SELECT CAST('9223372036854775807.0'::float4 AS int8); -SELECT CAST('9223372036854775807.0'::float8 AS int8); SELECT CAST('922337203685477580700.0'::float8 AS int8); SELECT CAST(q1 AS oid) FROM INT8_TBL; |