Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6151e89

Browse files
committed
Remove some unportable tests
1 parent2cf8afe commit6151e89

File tree

3 files changed

+0
-25
lines changed

3 files changed

+0
-25
lines changed

‎src/test/regress/expected/int8-exp-three-digits.out

Lines changed: 0 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -669,8 +669,6 @@ select '-9223372036854775800'::int8 - '9223372036854775800'::int8;
669669
ERROR: bigint out of range
670670
select '9223372036854775800'::int8 * '9223372036854775800'::int8;
671671
ERROR: bigint out of range
672-
select '-9223372036854775808'::int8 / '-1'::int8;
673-
ERROR: bigint out of range
674672
select '9223372036854775800'::int8 / '0'::int8;
675673
ERROR: division by zero
676674
select '9223372036854775800'::int8 % '0'::int8;
@@ -683,8 +681,6 @@ select '-9223372036854775800'::int8 - '100'::int4;
683681
ERROR: bigint out of range
684682
select '9223372036854775800'::int8 * '100'::int4;
685683
ERROR: bigint out of range
686-
select '-9223372036854775808'::int8 / '-1'::int4;
687-
ERROR: bigint out of range
688684
select '100'::int4 + '9223372036854775800'::int8;
689685
ERROR: bigint out of range
690686
select '-100'::int4 - '9223372036854775800'::int8;
@@ -697,8 +693,6 @@ select '-9223372036854775800'::int8 - '100'::int2;
697693
ERROR: bigint out of range
698694
select '9223372036854775800'::int8 * '100'::int2;
699695
ERROR: bigint out of range
700-
select '-9223372036854775808'::int8 / '-1'::int2;
701-
ERROR: bigint out of range
702696
select '-9223372036854775808'::int8 / '0'::int2;
703697
ERROR: division by zero
704698
select '100'::int2 + '9223372036854775800'::int8;
@@ -747,10 +741,6 @@ SELECT CAST('36854775807.0'::float4 AS int8);
747741
36854775808
748742
(1 row)
749743

750-
SELECT CAST('9223372036854775807.0'::float4 AS int8);
751-
ERROR: bigint out of range
752-
SELECT CAST('9223372036854775807.0'::float8 AS int8);
753-
ERROR: bigint out of range
754744
SELECT CAST('922337203685477580700.0'::float8 AS int8);
755745
ERROR: bigint out of range
756746
SELECT CAST(q1 AS oid) FROM INT8_TBL;

‎src/test/regress/expected/int8.out

Lines changed: 0 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -669,8 +669,6 @@ select '-9223372036854775800'::int8 - '9223372036854775800'::int8;
669669
ERROR: bigint out of range
670670
select '9223372036854775800'::int8 * '9223372036854775800'::int8;
671671
ERROR: bigint out of range
672-
select '-9223372036854775808'::int8 / '-1'::int8;
673-
ERROR: bigint out of range
674672
select '9223372036854775800'::int8 / '0'::int8;
675673
ERROR: division by zero
676674
select '9223372036854775800'::int8 % '0'::int8;
@@ -683,8 +681,6 @@ select '-9223372036854775800'::int8 - '100'::int4;
683681
ERROR: bigint out of range
684682
select '9223372036854775800'::int8 * '100'::int4;
685683
ERROR: bigint out of range
686-
select '-9223372036854775808'::int8 / '-1'::int4;
687-
ERROR: bigint out of range
688684
select '100'::int4 + '9223372036854775800'::int8;
689685
ERROR: bigint out of range
690686
select '-100'::int4 - '9223372036854775800'::int8;
@@ -697,8 +693,6 @@ select '-9223372036854775800'::int8 - '100'::int2;
697693
ERROR: bigint out of range
698694
select '9223372036854775800'::int8 * '100'::int2;
699695
ERROR: bigint out of range
700-
select '-9223372036854775808'::int8 / '-1'::int2;
701-
ERROR: bigint out of range
702696
select '-9223372036854775808'::int8 / '0'::int2;
703697
ERROR: division by zero
704698
select '100'::int2 + '9223372036854775800'::int8;
@@ -747,10 +741,6 @@ SELECT CAST('36854775807.0'::float4 AS int8);
747741
36854775808
748742
(1 row)
749743

750-
SELECT CAST('9223372036854775807.0'::float4 AS int8);
751-
ERROR: bigint out of range
752-
SELECT CAST('9223372036854775807.0'::float8 AS int8);
753-
ERROR: bigint out of range
754744
SELECT CAST('922337203685477580700.0'::float8 AS int8);
755745
ERROR: bigint out of range
756746
SELECT CAST(q1 AS oid) FROM INT8_TBL;

‎src/test/regress/sql/int8.sql

Lines changed: 0 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -139,7 +139,6 @@ select '9223372036854775800'::int8 - '-9223372036854775800'::int8;
139139
select'-9223372036854775800'::int8-'9223372036854775800'::int8;
140140

141141
select'9223372036854775800'::int8*'9223372036854775800'::int8;
142-
select'-9223372036854775808'::int8/'-1'::int8;
143142

144143
select'9223372036854775800'::int8/'0'::int8;
145144
select'9223372036854775800'::int8 %'0'::int8;
@@ -149,7 +148,6 @@ select abs('-9223372036854775808'::int8);
149148
select'9223372036854775800'::int8+'100'::int4;
150149
select'-9223372036854775800'::int8-'100'::int4;
151150
select'9223372036854775800'::int8*'100'::int4;
152-
select'-9223372036854775808'::int8/'-1'::int4;
153151

154152
select'100'::int4+'9223372036854775800'::int8;
155153
select'-100'::int4-'9223372036854775800'::int8;
@@ -158,7 +156,6 @@ select '100'::int4 * '9223372036854775800'::int8;
158156
select'9223372036854775800'::int8+'100'::int2;
159157
select'-9223372036854775800'::int8-'100'::int2;
160158
select'9223372036854775800'::int8*'100'::int2;
161-
select'-9223372036854775808'::int8/'-1'::int2;
162159
select'-9223372036854775808'::int8/'0'::int2;
163160

164161
select'100'::int2+'9223372036854775800'::int8;
@@ -176,8 +173,6 @@ SELECT CAST('42'::int2 AS int8), CAST('-37'::int2 AS int8);
176173

177174
SELECT CAST(q1AS float4), CAST(q2AS float8)FROM INT8_TBL;
178175
SELECT CAST('36854775807.0'::float4AS int8);
179-
SELECT CAST('9223372036854775807.0'::float4AS int8);
180-
SELECT CAST('9223372036854775807.0'::float8AS int8);
181176
SELECT CAST('922337203685477580700.0'::float8AS int8);
182177

183178
SELECT CAST(q1ASoid)FROM INT8_TBL;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp