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

Commit2a3c589

Browse files
committed
Clean up regression tests for SunOS (based on Solaris v2.6)
Clean up strings.out , removed func_get_detail from error message
1 parent2c482cd commit2a3c589

File tree

5 files changed

+642
-2
lines changed

5 files changed

+642
-2
lines changed
Lines changed: 206 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,206 @@
1+
QUERY: CREATE TABLE INT2_TBL(f1 int2);
2+
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('0');
3+
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('1234');
4+
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-1234');
5+
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('34.5');
6+
ERROR: pg_atoi: error in "34.5": can't parse ".5"
7+
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('32767');
8+
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-32767');
9+
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('100000');
10+
ERROR: pg_atoi: error reading "100000": Result too large
11+
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('asdf');
12+
ERROR: pg_atoi: error in "asdf": can't parse "asdf"
13+
QUERY: SELECT '' AS five, INT2_TBL.*;
14+
five| f1
15+
----+------
16+
| 0
17+
| 1234
18+
| -1234
19+
| 32767
20+
|-32767
21+
(5 rows)
22+
23+
QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int2;
24+
four| f1
25+
----+------
26+
| 1234
27+
| -1234
28+
| 32767
29+
|-32767
30+
(4 rows)
31+
32+
QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int4;
33+
four| f1
34+
----+------
35+
| 1234
36+
| -1234
37+
| 32767
38+
|-32767
39+
(4 rows)
40+
41+
QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int2;
42+
one|f1
43+
---+--
44+
| 0
45+
(1 row)
46+
47+
QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int4;
48+
one|f1
49+
---+--
50+
| 0
51+
(1 row)
52+
53+
QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int2;
54+
two| f1
55+
---+------
56+
| -1234
57+
|-32767
58+
(2 rows)
59+
60+
QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int4;
61+
two| f1
62+
---+------
63+
| -1234
64+
|-32767
65+
(2 rows)
66+
67+
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int2;
68+
three| f1
69+
-----+------
70+
| 0
71+
| -1234
72+
|-32767
73+
(3 rows)
74+
75+
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int4;
76+
three| f1
77+
-----+------
78+
| 0
79+
| -1234
80+
|-32767
81+
(3 rows)
82+
83+
QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int2;
84+
two| f1
85+
---+-----
86+
| 1234
87+
|32767
88+
(2 rows)
89+
90+
QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int4;
91+
two| f1
92+
---+-----
93+
| 1234
94+
|32767
95+
(2 rows)
96+
97+
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int2;
98+
three| f1
99+
-----+-----
100+
| 0
101+
| 1234
102+
|32767
103+
(3 rows)
104+
105+
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int4;
106+
three| f1
107+
-----+-----
108+
| 0
109+
| 1234
110+
|32767
111+
(3 rows)
112+
113+
QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2;
114+
one| f1
115+
---+-----
116+
|32767
117+
(1 row)
118+
119+
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2;
120+
three| f1
121+
-----+-----
122+
| 0
123+
| 1234
124+
|-1234
125+
(3 rows)
126+
127+
QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT2_TBL i;
128+
five| f1| x
129+
----+------+-----
130+
| 0| 0
131+
| 1234| 2468
132+
| -1234|-2468
133+
| 32767| -2
134+
|-32767| 2
135+
(5 rows)
136+
137+
QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT2_TBL i;
138+
five| f1| x
139+
----+------+------
140+
| 0| 0
141+
| 1234| 2468
142+
| -1234| -2468
143+
| 32767| 65534
144+
|-32767|-65534
145+
(5 rows)
146+
147+
QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT2_TBL i;
148+
five| f1| x
149+
----+------+------
150+
| 0| 2
151+
| 1234| 1236
152+
| -1234| -1232
153+
| 32767|-32767
154+
|-32767|-32765
155+
(5 rows)
156+
157+
QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT2_TBL i;
158+
five| f1| x
159+
----+------+------
160+
| 0| 2
161+
| 1234| 1236
162+
| -1234| -1232
163+
| 32767| 32769
164+
|-32767|-32765
165+
(5 rows)
166+
167+
QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT2_TBL i;
168+
five| f1| x
169+
----+------+-----
170+
| 0| -2
171+
| 1234| 1232
172+
| -1234|-1236
173+
| 32767|32765
174+
|-32767|32767
175+
(5 rows)
176+
177+
QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT2_TBL i;
178+
five| f1| x
179+
----+------+------
180+
| 0| -2
181+
| 1234| 1232
182+
| -1234| -1236
183+
| 32767| 32765
184+
|-32767|-32769
185+
(5 rows)
186+
187+
QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT2_TBL i;
188+
five| f1| x
189+
----+------+------
190+
| 0| 0
191+
| 1234| 617
192+
| -1234| -617
193+
| 32767| 16383
194+
|-32767|-16383
195+
(5 rows)
196+
197+
QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT2_TBL i;
198+
five| f1| x
199+
----+------+------
200+
| 0| 0
201+
| 1234| 617
202+
| -1234| -617
203+
| 32767| 16383
204+
|-32767|-16383
205+
(5 rows)
206+

0 commit comments

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