Skip to content

Commit 9607e69

Browse files
scrappyscrappy
committed
These are the broken down 'expected.output' files created so far
1 parent 0762dea commit 9607e69

File tree

8 files changed

+1066
-0
lines changed

8 files changed

+1066
-0
lines changed

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

Lines changed: 189 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,189 @@
1+
QUERY: CREATE TABLE ABSTIME_TBL (f1 abstime);
2+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Jan 14, 1973 03:14:21');
3+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Mon May 1 00:30:30 1995'::abstime);
4+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('epoch'::abstime);
5+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('current'::abstime);
6+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('infinity'::abstime);
7+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('-infinity'::abstime);
8+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('May 10, 1943 23:59:12');
9+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 35, 1946 10:00:00');
10+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 28, 1984 25:08:10');
11+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('bad date format');
12+
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Jun 10, 1843');
13+
14+
QUERY: SELECT '' AS eleven, ABSTIME_TBL.*;
15+
eleven|f1
16+
------+----------------------------
17+
|Sun Jan 14 03:14:21 1973 PST
18+
|Mon May 01 00:30:30 1995 PDT
19+
|epoch
20+
|current
21+
|infinity
22+
|-infinity
23+
|Mon May 10 23:59:12 1943 PWT
24+
|Thu Mar 07 10:00:00 1946 PST
25+
|Wed Dec 31 15:59:59 1969 PST
26+
|Invalid Abstime
27+
|Invalid Abstime
28+
(11 rows)
29+
30+
QUERY: SELECT '' AS eight, ABSTIME_TBL.*
31+
WHERE ABSTIME_TBL.f1 < 'Jun 30, 2001'::abstime;
32+
eight|f1
33+
-----+----------------------------
34+
|Sun Jan 14 03:14:21 1973 PST
35+
|Mon May 01 00:30:30 1995 PDT
36+
|epoch
37+
|current
38+
|-infinity
39+
|Mon May 10 23:59:12 1943 PWT
40+
|Thu Mar 07 10:00:00 1946 PST
41+
|Wed Dec 31 15:59:59 1969 PST
42+
(8 rows)
43+
44+
QUERY: SELECT '' AS eight, ABSTIME_TBL.*
45+
WHERE ABSTIME_TBL.f1 > '-infinity'::abstime;
46+
eight|f1
47+
-----+----------------------------
48+
|Sun Jan 14 03:14:21 1973 PST
49+
|Mon May 01 00:30:30 1995 PDT
50+
|epoch
51+
|current
52+
|infinity
53+
|Mon May 10 23:59:12 1943 PWT
54+
|Thu Mar 07 10:00:00 1946 PST
55+
|Wed Dec 31 15:59:59 1969 PST
56+
(8 rows)
57+
58+
QUERY: SELECT '' AS eight, ABSTIME_TBL.*
59+
WHERE 'May 10, 1943 23:59:12'::abstime <> ABSTIME_TBL.f1;
60+
eight|f1
61+
-----+----------------------------
62+
|Sun Jan 14 03:14:21 1973 PST
63+
|Mon May 01 00:30:30 1995 PDT
64+
|epoch
65+
|current
66+
|infinity
67+
|-infinity
68+
|Thu Mar 07 10:00:00 1946 PST
69+
|Wed Dec 31 15:59:59 1969 PST
70+
(8 rows)
71+
72+
QUERY: SELECT '' AS one, ABSTIME_TBL.*
73+
WHERE 'current'::abstime = ABSTIME_TBL.f1;
74+
one|f1
75+
---+-------
76+
|current
77+
(1 row)
78+
79+
QUERY: SELECT '' AS five, ABSTIME_TBL.*
80+
WHERE 'epoch'::abstime >= ABSTIME_TBL.f1;
81+
five|f1
82+
----+----------------------------
83+
|epoch
84+
|-infinity
85+
|Mon May 10 23:59:12 1943 PWT
86+
|Thu Mar 07 10:00:00 1946 PST
87+
|Wed Dec 31 15:59:59 1969 PST
88+
(5 rows)
89+
90+
QUERY: SELECT '' AS six, ABSTIME_TBL.*
91+
WHERE ABSTIME_TBL.f1 <= 'Jan 14, 1973 03:14:21'::abstime;
92+
six|f1
93+
---+----------------------------
94+
|Sun Jan 14 03:14:21 1973 PST
95+
|epoch
96+
|-infinity
97+
|Mon May 10 23:59:12 1943 PWT
98+
|Thu Mar 07 10:00:00 1946 PST
99+
|Wed Dec 31 15:59:59 1969 PST
100+
(6 rows)
101+
102+
QUERY: SELECT '' AS six, ABSTIME_TBL.*
103+
WHERE ABSTIME_TBL.f1 <?>
104+
'["Apr 1 1945 00:00:00" "Dec 30 1999 23:00:00"]'::tinterval;
105+
six|f1
106+
---+----------------------------
107+
|Sun Jan 14 03:14:21 1973 PST
108+
|Mon May 01 00:30:30 1995 PDT
109+
|epoch
110+
|current
111+
|Thu Mar 07 10:00:00 1946 PST
112+
|Wed Dec 31 15:59:59 1969 PST
113+
(6 rows)
114+
115+
QUERY: SELECT '' AS five, ABSTIME_TBL.*
116+
WHERE (ABSTIME_TBL.f1 + '@ 3 year'::reltime)
117+
< 'Jan 14 14:00:00 1977'::abstime;
118+
five|f1
119+
----+----------------------------
120+
|Sun Jan 14 03:14:21 1973 PST
121+
|epoch
122+
|Mon May 10 23:59:12 1943 PWT
123+
|Thu Mar 07 10:00:00 1946 PST
124+
|Wed Dec 31 15:59:59 1969 PST
125+
(5 rows)
126+
127+
QUERY: SELECT '' AS five, ABSTIME_TBL.*
128+
WHERE (ABSTIME_TBL.f1 + '@ 3 year ago'::reltime)
129+
< 'Jan 14 14:00:00 1971'::abstime;
130+
five|f1
131+
----+----------------------------
132+
|Sun Jan 14 03:14:21 1973 PST
133+
|epoch
134+
|Mon May 10 23:59:12 1943 PWT
135+
|Thu Mar 07 10:00:00 1946 PST
136+
|Wed Dec 31 15:59:59 1969 PST
137+
(5 rows)
138+
139+
QUERY: SELECT '' AS five, ABSTIME_TBL.*
140+
WHERE (ABSTIME_TBL.f1 - '@ 3 year'::reltime)
141+
< 'Jan 14 14:00:00 1971'::abstime;
142+
five|f1
143+
----+----------------------------
144+
|Sun Jan 14 03:14:21 1973 PST
145+
|epoch
146+
|Mon May 10 23:59:12 1943 PWT
147+
|Thu Mar 07 10:00:00 1946 PST
148+
|Wed Dec 31 15:59:59 1969 PST
149+
(5 rows)
150+
151+
QUERY: SELECT '' AS five, ABSTIME_TBL.*
152+
WHERE (ABSTIME_TBL.f1 - '@ 3 year ago'::reltime)
153+
< 'Jan 14 14:00:00 1977'::abstime;
154+
five|f1
155+
----+----------------------------
156+
|Sun Jan 14 03:14:21 1973 PST
157+
|epoch
158+
|Mon May 10 23:59:12 1943 PWT
159+
|Thu Mar 07 10:00:00 1946 PST
160+
|Wed Dec 31 15:59:59 1969 PST
161+
(5 rows)
162+
163+
QUERY: SELECT '' AS twenty, ABSTIME_TBL.*, RELTIME_TBL.*
164+
WHERE (ABSTIME_TBL.f1 + RELTIME_TBL.f1)
165+
< 'Jan 14 14:00:00 1971'::abstime;
166+
twenty|f1 |f1
167+
------+----------------------------+----------------
168+
|epoch |@ 1 minute
169+
|Mon May 10 23:59:12 1943 PWT|@ 1 minute
170+
|Thu Mar 07 10:00:00 1946 PST|@ 1 minute
171+
|Wed Dec 31 15:59:59 1969 PST|@ 1 minute
172+
|epoch |@ 5 hours
173+
|Mon May 10 23:59:12 1943 PWT|@ 5 hours
174+
|Thu Mar 07 10:00:00 1946 PST|@ 5 hours
175+
|Wed Dec 31 15:59:59 1969 PST|@ 5 hours
176+
|epoch |@ 10 days
177+
|Mon May 10 23:59:12 1943 PWT|@ 10 days
178+
|Thu Mar 07 10:00:00 1946 PST|@ 10 days
179+
|Wed Dec 31 15:59:59 1969 PST|@ 10 days
180+
|epoch |@ 3 months
181+
|Mon May 10 23:59:12 1943 PWT|@ 3 months
182+
|Thu Mar 07 10:00:00 1946 PST|@ 3 months
183+
|Wed Dec 31 15:59:59 1969 PST|@ 3 months
184+
|epoch |@ 14 seconds ago
185+
|Mon May 10 23:59:12 1943 PWT|@ 14 seconds ago
186+
|Thu Mar 07 10:00:00 1946 PST|@ 14 seconds ago
187+
|Wed Dec 31 15:59:59 1969 PST|@ 14 seconds ago
188+
(20 rows)
189+

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

Lines changed: 179 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,179 @@
1+
QUERY: SELECT 1 AS one;
2+
one
3+
---
4+
1
5+
(1 row)
6+
7+
QUERY: SELECT 't'::bool AS true;
8+
true
9+
----
10+
t
11+
(1 row)
12+
13+
QUERY: SELECT 'f'::bool AS false;
14+
false
15+
-----
16+
f
17+
(1 row)
18+
19+
QUERY: SELECT 't'::bool or 'f'::bool AS true;
20+
true
21+
----
22+
t
23+
(1 row)
24+
25+
QUERY: SELECT 't'::bool and 'f'::bool AS false;
26+
false
27+
-----
28+
f
29+
(1 row)
30+
31+
QUERY: SELECT not 'f'::bool AS true;
32+
true
33+
----
34+
t
35+
(1 row)
36+
37+
QUERY: SELECT 't'::bool = 'f'::bool AS false;
38+
false
39+
-----
40+
f
41+
(1 row)
42+
43+
QUERY: SELECT 't'::bool <> 'f'::bool AS true;
44+
true
45+
----
46+
t
47+
(1 row)
48+
49+
QUERY: CREATE TABLE BOOLTBL1 (f1 bool);
50+
QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('t'::bool);
51+
QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('True'::bool);
52+
QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('true'::bool);
53+
QUERY: SELECT '' AS t_3, BOOLTBL1.*;
54+
t_3|f1
55+
---+--
56+
|t
57+
|t
58+
|t
59+
(3 rows)
60+
61+
QUERY: SELECT '' AS t_3, BOOLTBL1.*
62+
FROM BOOLTBL1
63+
WHERE f1 = 'true'::bool;
64+
t_3|f1
65+
---+--
66+
|t
67+
|t
68+
|t
69+
(3 rows)
70+
71+
QUERY: SELECT '' AS t_3, BOOLTBL1.*
72+
FROM BOOLTBL1
73+
WHERE f1 <> 'false'::bool;
74+
t_3|f1
75+
---+--
76+
|t
77+
|t
78+
|t
79+
(3 rows)
80+
81+
QUERY: SELECT '' AS zero, BOOLTBL1.*
82+
FROM BOOLTBL1
83+
WHERE booleq('false'::bool, f1);
84+
zero|f1
85+
----+--
86+
(0 rows)
87+
88+
QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('f'::bool);
89+
QUERY: SELECT '' AS f_1, BOOLTBL1.*
90+
FROM BOOLTBL1
91+
WHERE f1 = 'false'::bool;
92+
f_1|f1
93+
---+--
94+
|f
95+
(1 row)
96+
97+
QUERY: CREATE TABLE BOOLTBL2 (f1 bool);
98+
QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('f'::bool);
99+
QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('false'::bool);
100+
QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('False'::bool);
101+
QUERY: INSERT INTO BOOLTBL2 (f1)
102+
VALUES ('XXX'::bool);
103+
QUERY: SELECT '' AS f_4, BOOLTBL2.*;
104+
f_4|f1
105+
---+--
106+
|f
107+
|f
108+
|f
109+
|f
110+
(4 rows)
111+
112+
QUERY: SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.*
113+
WHERE BOOLTBL2.f1 <> BOOLTBL1.f1;
114+
tf_12|f1|f1
115+
-----+--+--
116+
|t |f
117+
|t |f
118+
|t |f
119+
|t |f
120+
|t |f
121+
|t |f
122+
|t |f
123+
|t |f
124+
|t |f
125+
|t |f
126+
|t |f
127+
|t |f
128+
(12 rows)
129+
130+
QUERY: SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.*
131+
WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1);
132+
tf_12|f1|f1
133+
-----+--+--
134+
|t |f
135+
|t |f
136+
|t |f
137+
|t |f
138+
|t |f
139+
|t |f
140+
|t |f
141+
|t |f
142+
|t |f
143+
|t |f
144+
|t |f
145+
|t |f
146+
(12 rows)
147+
148+
QUERY: SELECT '' AS ff_4, BOOLTBL1.*, BOOLTBL2.*
149+
WHERE BOOLTBL2.f1 = BOOLTBL1.f1 and BOOLTBL1.f1 = 'false'::bool;
150+
ff_4|f1|f1
151+
----+--+--
152+
|f |f
153+
|f |f
154+
|f |f
155+
|f |f
156+
(4 rows)
157+
158+
QUERY: SELECT '' AS tf_12_ff_4, BOOLTBL1.*, BOOLTBL2.*
159+
WHERE BOOLTBL2.f1 = BOOLTBL1.f1 or BOOLTBL1.f1 = 'true'::bool;
160+
tf_12_ff_4|f1|f1
161+
----------+--+--
162+
|t |f
163+
|t |f
164+
|t |f
165+
|t |f
166+
|t |f
167+
|t |f
168+
|t |f
169+
|t |f
170+
|t |f
171+
|t |f
172+
|t |f
173+
|t |f
174+
|f |f
175+
|f |f
176+
|f |f
177+
|f |f
178+
(16 rows)
179+

0 commit comments

Comments
 (0)