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

Commit73f3ab6

Browse files
committed
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 whenI get a chance.Claudio Natoli
1 parente3d6ee6 commit73f3ab6

File tree

1 file changed

+15
-0
lines changed

1 file changed

+15
-0
lines changed

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

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -8,6 +8,21 @@ INSERT INTO INT8_TBL VALUES('123','4567890123456789');
88
INSERT INTO INT8_TBL VALUES('4567890123456789','123');
99
INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789');
1010
INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
11+
-- bad inputs
12+
INSERT INTO INT8_TBL(q1) VALUES (' ');
13+
ERROR: invalid input syntax for type bigint: " "
14+
INSERT INTO INT8_TBL(q1) VALUES ('xxx');
15+
ERROR: invalid input syntax for type bigint: "xxx"
16+
INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485');
17+
ERROR: integer out of range
18+
INSERT INTO INT8_TBL(q1) VALUES ('-1204982019841029840928340329840934');
19+
ERROR: integer out of range
20+
INSERT INTO INT8_TBL(q1) VALUES ('- 123');
21+
ERROR: invalid input syntax for type bigint: "- 123"
22+
INSERT INTO INT8_TBL(q1) VALUES (' 345 5');
23+
ERROR: invalid input syntax for type bigint: " 345 5"
24+
INSERT INTO INT8_TBL(q1) VALUES ('');
25+
ERROR: invalid input syntax for type bigint: ""
1126
SELECT * FROM INT8_TBL;
1227
q1 | q2
1328
------------------+-------------------

0 commit comments

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