Attachment #861545 for bug #906172

View | Details | Raw Unified | Return to bug 906172
Collapse All | Expand All




SELECT BOOLTBL1.*, BOOLTBL2.*
   FROM BOOLTBL1, BOOLTBL2
   WHERE BOOLTBL2.f1 <> BOOLTBL1.f1;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
----+----
 t  | f
 t  | f
 t  | f
 t  | f
 t  | f
 t  | f
 t  | f
 t  | f
 t  | f
 t  | f
 t  | f
 t  | f
(12 rows)

SELECT BOOLTBL1.*, BOOLTBL2.*
   FROM BOOLTBL1, BOOLTBL2
   WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1);

Lines 44-65 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/bit.out (-16 / +1 lines)
44	SELECT v, b, (v \|\| b) AS concat	44	SELECT v, b, (v \|\| b) AS concat
45	FROM BIT_TABLE, VARBIT_TABLE	45	FROM BIT_TABLE, VARBIT_TABLE
46	ORDER BY 3;	46	ORDER BY 3;
47	v \| b \| concat	47	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
48	-------------+-------------+------------------------
49	\| 00000000000 \| 00000000000
50	0 \| 00000000000 \| 000000000000
51	0 \| 01010101010 \| 001010101010
52	010101 \| 00000000000 \| 01010100000000000
53	\| 01010101010 \| 01010101010
54	01010101010 \| 00000000000 \| 0101010101000000000000
55	01010101010 \| 01010101010 \| 0101010101001010101010
56	010101 \| 01010101010 \| 01010101010101010
57	01010101010 \| 11011000000 \| 0101010101011011000000
58	010101 \| 11011000000 \| 01010111011000000
59	0 \| 11011000000 \| 011011000000
60	\| 11011000000 \| 11011000000
61	(12 rows)
62
63	-- Length	48	-- Length
64	SELECT b, length(b) AS lb	49	SELECT b, length(b) AS lb
65	FROM BIT_TABLE;	50	FROM BIT_TABLE;

Lines 1697-1707 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/rangetypes.out (-5 / +1 lines)
1697	create type cashrange as range (subtype = money);	1697	create type cashrange as range (subtype = money);
1698	set enable_sort = off; -- try to make it pick a hash setop implementation	1698	set enable_sort = off; -- try to make it pick a hash setop implementation
1699	select '(2,5)'::cashrange except select '(5,6)'::cashrange;	1699	select '(2,5)'::cashrange except select '(5,6)'::cashrange;
1700	cashrange	1700	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
1701	---------------
1702	($2.00,$5.00)
1703	(1 row)
1704
1705	reset enable_sort;	1701	reset enable_sort;
1706	--	1702	--
1707	-- OUT/INOUT/TABLE functions	1703	-- OUT/INOUT/TABLE functions

Lines 153-262 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/point.out (-104 / +1 lines)
153	SELECT p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist	153	SELECT p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist
154	FROM POINT_TBL p1, POINT_TBL p2	154	FROM POINT_TBL p1, POINT_TBL p2
155	ORDER BY dist, p1.f1[0], p2.f1[0];	155	ORDER BY dist, p1.f1[0], p2.f1[0];
156	point1 \| point2 \| dist	156	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
157	-------------------+-------------------+----------------------
158	(-10,0) \| (-10,0) \| 0
159	(-5,-12) \| (-5,-12) \| 0
160	(-3,4) \| (-3,4) \| 0
161	(0,0) \| (0,0) \| 0
162	(1e-300,-1e-300) \| (1e-300,-1e-300) \| 0
163	(5.1,34.5) \| (5.1,34.5) \| 0
164	(10,10) \| (10,10) \| 0
165	(0,0) \| (1e-300,-1e-300) \| 1.4142135623731e-300
166	(1e-300,-1e-300) \| (0,0) \| 1.4142135623731e-300
167	(-3,4) \| (0,0) \| 5
168	(-3,4) \| (1e-300,-1e-300) \| 5
169	(0,0) \| (-3,4) \| 5
170	(1e-300,-1e-300) \| (-3,4) \| 5
171	(-10,0) \| (-3,4) \| 8.06225774829855
172	(-3,4) \| (-10,0) \| 8.06225774829855
173	(-10,0) \| (0,0) \| 10
174	(-10,0) \| (1e-300,-1e-300) \| 10
175	(0,0) \| (-10,0) \| 10
176	(1e-300,-1e-300) \| (-10,0) \| 10
177	(-10,0) \| (-5,-12) \| 13
178	(-5,-12) \| (-10,0) \| 13
179	(-5,-12) \| (0,0) \| 13
180	(-5,-12) \| (1e-300,-1e-300) \| 13
181	(0,0) \| (-5,-12) \| 13
182	(1e-300,-1e-300) \| (-5,-12) \| 13
183	(0,0) \| (10,10) \| 14.142135623731
184	(1e-300,-1e-300) \| (10,10) \| 14.142135623731
185	(10,10) \| (0,0) \| 14.142135623731
186	(10,10) \| (1e-300,-1e-300) \| 14.142135623731
187	(-3,4) \| (10,10) \| 14.3178210632764
188	(10,10) \| (-3,4) \| 14.3178210632764
189	(-5,-12) \| (-3,4) \| 16.1245154965971
190	(-3,4) \| (-5,-12) \| 16.1245154965971
191	(-10,0) \| (10,10) \| 22.3606797749979
192	(10,10) \| (-10,0) \| 22.3606797749979
193	(5.1,34.5) \| (10,10) \| 24.9851956166046
194	(10,10) \| (5.1,34.5) \| 24.9851956166046
195	(-5,-12) \| (10,10) \| 26.6270539113887
196	(10,10) \| (-5,-12) \| 26.6270539113887
197	(-3,4) \| (5.1,34.5) \| 31.5572495632937
198	(5.1,34.5) \| (-3,4) \| 31.5572495632937
199	(0,0) \| (5.1,34.5) \| 34.8749193547455
200	(1e-300,-1e-300) \| (5.1,34.5) \| 34.8749193547455
201	(5.1,34.5) \| (0,0) \| 34.8749193547455
202	(5.1,34.5) \| (1e-300,-1e-300) \| 34.8749193547455
203	(-10,0) \| (5.1,34.5) \| 37.6597928831267
204	(5.1,34.5) \| (-10,0) \| 37.6597928831267
205	(-5,-12) \| (5.1,34.5) \| 47.5842410888311
206	(5.1,34.5) \| (-5,-12) \| 47.5842410888311
207	(-10,0) \| (1e+300,Infinity) \| Infinity
208	(-10,0) \| (Infinity,1e+300) \| Infinity
209	(-5,-12) \| (1e+300,Infinity) \| Infinity
210	(-5,-12) \| (Infinity,1e+300) \| Infinity
211	(-3,4) \| (1e+300,Infinity) \| Infinity
212	(-3,4) \| (Infinity,1e+300) \| Infinity
213	(0,0) \| (1e+300,Infinity) \| Infinity
214	(0,0) \| (Infinity,1e+300) \| Infinity
215	(1e-300,-1e-300) \| (1e+300,Infinity) \| Infinity
216	(1e-300,-1e-300) \| (Infinity,1e+300) \| Infinity
217	(5.1,34.5) \| (1e+300,Infinity) \| Infinity
218	(5.1,34.5) \| (Infinity,1e+300) \| Infinity
219	(10,10) \| (1e+300,Infinity) \| Infinity
220	(10,10) \| (Infinity,1e+300) \| Infinity
221	(1e+300,Infinity) \| (-10,0) \| Infinity
222	(1e+300,Infinity) \| (-5,-12) \| Infinity
223	(1e+300,Infinity) \| (-3,4) \| Infinity
224	(1e+300,Infinity) \| (0,0) \| Infinity
225	(1e+300,Infinity) \| (1e-300,-1e-300) \| Infinity
226	(1e+300,Infinity) \| (5.1,34.5) \| Infinity
227	(1e+300,Infinity) \| (10,10) \| Infinity
228	(1e+300,Infinity) \| (Infinity,1e+300) \| Infinity
229	(Infinity,1e+300) \| (-10,0) \| Infinity
230	(Infinity,1e+300) \| (-5,-12) \| Infinity
231	(Infinity,1e+300) \| (-3,4) \| Infinity
232	(Infinity,1e+300) \| (0,0) \| Infinity
233	(Infinity,1e+300) \| (1e-300,-1e-300) \| Infinity
234	(Infinity,1e+300) \| (5.1,34.5) \| Infinity
235	(Infinity,1e+300) \| (10,10) \| Infinity
236	(Infinity,1e+300) \| (1e+300,Infinity) \| Infinity
237	(-10,0) \| (NaN,NaN) \| NaN
238	(-5,-12) \| (NaN,NaN) \| NaN
239	(-3,4) \| (NaN,NaN) \| NaN
240	(0,0) \| (NaN,NaN) \| NaN
241	(1e-300,-1e-300) \| (NaN,NaN) \| NaN
242	(5.1,34.5) \| (NaN,NaN) \| NaN
243	(10,10) \| (NaN,NaN) \| NaN
244	(1e+300,Infinity) \| (1e+300,Infinity) \| NaN
245	(1e+300,Infinity) \| (NaN,NaN) \| NaN
246	(Infinity,1e+300) \| (Infinity,1e+300) \| NaN
247	(Infinity,1e+300) \| (NaN,NaN) \| NaN
248	(NaN,NaN) \| (-10,0) \| NaN
249	(NaN,NaN) \| (-5,-12) \| NaN
250	(NaN,NaN) \| (-3,4) \| NaN
251	(NaN,NaN) \| (0,0) \| NaN
252	(NaN,NaN) \| (1e-300,-1e-300) \| NaN
253	(NaN,NaN) \| (5.1,34.5) \| NaN
254	(NaN,NaN) \| (10,10) \| NaN
255	(NaN,NaN) \| (1e+300,Infinity) \| NaN
256	(NaN,NaN) \| (Infinity,1e+300) \| NaN
257	(NaN,NaN) \| (NaN,NaN) \| NaN
258	(100 rows)
259
260	SELECT p1.f1 AS point1, p2.f1 AS point2	157	SELECT p1.f1 AS point1, p2.f1 AS point2
261	FROM POINT_TBL p1, POINT_TBL p2	158	FROM POINT_TBL p1, POINT_TBL p2
262	WHERE (p1.f1 <-> p2.f1) > 3;	159	WHERE (p1.f1 <-> p2.f1) > 3;

Lines 609-618 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/box.out (-4 / +1 lines)
609	ON seq.n = idx.n AND seq.id = idx.id AND	609	ON seq.n = idx.n AND seq.id = idx.id AND
610	(seq.dist = idx.dist OR seq.dist IS NULL AND idx.dist IS NULL)	610	(seq.dist = idx.dist OR seq.dist IS NULL AND idx.dist IS NULL)
611	WHERE seq.id IS NULL OR idx.id IS NULL;	611	WHERE seq.id IS NULL OR idx.id IS NULL;
612	n \| dist \| id \| n \| dist \| id	612	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
613	---+------+----+---+------+----
614	(0 rows)
615
616	EXPLAIN (COSTS OFF)	613	EXPLAIN (COSTS OFF)
617	SELECT rank() OVER (ORDER BY b <-> point '123,456') n, b <-> point '123,456' dist, id	614	SELECT rank() OVER (ORDER BY b <-> point '123,456') n, b <-> point '123,456' dist, id
618	FROM quad_box_tbl WHERE b <@ box '((200,300),(500,600))';	615	FROM quad_box_tbl WHERE b <@ box '((200,300),(500,600))';

Lines 299-308 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/polygon.out (-4 / +1 lines)
299	ON seq.n = idx.n AND seq.id = idx.id AND	299	ON seq.n = idx.n AND seq.id = idx.id AND
300	(seq.dist = idx.dist OR seq.dist IS NULL AND idx.dist IS NULL)	300	(seq.dist = idx.dist OR seq.dist IS NULL AND idx.dist IS NULL)
301	WHERE seq.id IS NULL OR idx.id IS NULL;	301	WHERE seq.id IS NULL OR idx.id IS NULL;
302	n \| dist \| id \| n \| dist \| id	302	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
303	---+------+----+---+------+----
304	(0 rows)
305
306	RESET enable_seqscan;	303	RESET enable_seqscan;
307	RESET enable_indexscan;	304	RESET enable_indexscan;
308	RESET enable_bitmapscan;	305	RESET enable_bitmapscan;

Lines 158-212 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/interval.out (-49 / +1 lines)
158	FROM INTERVAL_TBL r1, INTERVAL_TBL r2	158	FROM INTERVAL_TBL r1, INTERVAL_TBL r2
159	WHERE r1.f1 > r2.f1	159	WHERE r1.f1 > r2.f1
160	ORDER BY r1.f1, r2.f1;	160	ORDER BY r1.f1, r2.f1;
161	f1 \| f1	161	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
162	-----------------+-----------------
163	00:01:00 \| -00:00:14
164	05:00:00 \| -00:00:14
165	05:00:00 \| 00:01:00
166	1 day 02:03:04 \| -00:00:14
167	1 day 02:03:04 \| 00:01:00
168	1 day 02:03:04 \| 05:00:00
169	10 days \| -00:00:14
170	10 days \| 00:01:00
171	10 days \| 05:00:00
172	10 days \| 1 day 02:03:04
173	3 mons \| -00:00:14
174	3 mons \| 00:01:00
175	3 mons \| 05:00:00
176	3 mons \| 1 day 02:03:04
177	3 mons \| 10 days
178	5 mons \| -00:00:14
179	5 mons \| 00:01:00
180	5 mons \| 05:00:00
181	5 mons \| 1 day 02:03:04
182	5 mons \| 10 days
183	5 mons \| 3 mons
184	5 mons 12:00:00 \| -00:00:14
185	5 mons 12:00:00 \| 00:01:00
186	5 mons 12:00:00 \| 05:00:00
187	5 mons 12:00:00 \| 1 day 02:03:04
188	5 mons 12:00:00 \| 10 days
189	5 mons 12:00:00 \| 3 mons
190	5 mons 12:00:00 \| 5 mons
191	6 years \| -00:00:14
192	6 years \| 00:01:00
193	6 years \| 05:00:00
194	6 years \| 1 day 02:03:04
195	6 years \| 10 days
196	6 years \| 3 mons
197	6 years \| 5 mons
198	6 years \| 5 mons 12:00:00
199	34 years \| -00:00:14
200	34 years \| 00:01:00
201	34 years \| 05:00:00
202	34 years \| 1 day 02:03:04
203	34 years \| 10 days
204	34 years \| 3 mons
205	34 years \| 5 mons
206	34 years \| 5 mons 12:00:00
207	34 years \| 6 years
208	(45 rows)
209
210	-- Test intervals that are large enough to overflow 64 bits in comparisons	162	-- Test intervals that are large enough to overflow 64 bits in comparisons
211	CREATE TEMP TABLE INTERVAL_TBL_OF (f1 interval);	163	CREATE TEMP TABLE INTERVAL_TBL_OF (f1 interval);
212	INSERT INTO INTERVAL_TBL_OF (f1) VALUES	164	INSERT INTO INTERVAL_TBL_OF (f1) VALUES

Lines 2758-2775 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/multirangetypes.out (-12 / +1 lines)
2758	FROM reservations	2758	FROM reservations
2759	GROUP BY room_id	2759	GROUP BY room_id
2760	ORDER BY room_id;	2760	ORDER BY room_id;
2761	room_id \| range_agg	2761	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
2762	---------+---------------------------------------------------
2763	1 \| {[07-01-2018,07-14-2018),[07-20-2018,07-22-2018)}
2764	2 \| {[07-01-2018,07-03-2018)}
2765	3 \|
2766	4 \|
2767	5 \| {[07-01-2018,07-03-2018)}
2768	6 \| {[07-01-2018,07-10-2018)}
2769	7 \| {[07-01-2018,07-14-2018)}
2770	8 \| {}
2771	(8 rows)
2772
2773	-- range_agg on a custom range type too	2762	-- range_agg on a custom range type too
2774	SELECT range_agg(r)	2763	SELECT range_agg(r)
2775	FROM (VALUES	2764	FROM (VALUES

Lines 4274-4344 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/geometry.out (-65 / +1 lines)
4274	FROM CIRCLE_TBL c1, POINT_TBL p1	4274	FROM CIRCLE_TBL c1, POINT_TBL p1
4275	WHERE (p1.f1 <-> c1.f1) > 0	4275	WHERE (p1.f1 <-> c1.f1) > 0
4276	ORDER BY distance, area(c1.f1), p1.f1[0];	4276	ORDER BY distance, area(c1.f1), p1.f1[0];
4277	circle \| point \| distance	4277	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
4278	----------------+-------------------+---------------
4279	<(1,2),3> \| (-3,4) \| 1.472135955
4280	<(5,1),3> \| (0,0) \| 2.09901951359
4281	<(5,1),3> \| (1e-300,-1e-300) \| 2.09901951359
4282	<(5,1),3> \| (-3,4) \| 5.54400374532
4283	<(3,5),0> \| (0,0) \| 5.83095189485
4284	<(3,5),0> \| (1e-300,-1e-300) \| 5.83095189485
4285	<(3,5),0> \| (-3,4) \| 6.0827625303
4286	<(1,3),5> \| (-10,0) \| 6.40175425099
4287	<(1,3),5> \| (10,10) \| 6.40175425099
4288	<(5,1),3> \| (10,10) \| 7.29563014099
4289	<(1,2),3> \| (-10,0) \| 8.1803398875
4290	<(3,5),0> \| (10,10) \| 8.60232526704
4291	<(1,2),3> \| (10,10) \| 9.04159457879
4292	<(1,3),5> \| (-5,-12) \| 11.1554944214
4293	<(5,1),3> \| (-10,0) \| 12.0332963784
4294	<(1,2),3> \| (-5,-12) \| 12.2315462117
4295	<(5,1),3> \| (-5,-12) \| 13.4012194669
4296	<(3,5),0> \| (-10,0) \| 13.9283882772
4297	<(3,5),0> \| (-5,-12) \| 18.7882942281
4298	<(1,3),5> \| (5.1,34.5) \| 26.7657047773
4299	<(3,5),0> \| (5.1,34.5) \| 29.5746513082
4300	<(1,2),3> \| (5.1,34.5) \| 29.7575945393
4301	<(5,1),3> \| (5.1,34.5) \| 30.5001492534
4302	<(100,200),10> \| (5.1,34.5) \| 180.778038568
4303	<(100,200),10> \| (10,10) \| 200.237960416
4304	<(100,200),10> \| (-3,4) \| 211.415898255
4305	<(100,200),10> \| (0,0) \| 213.60679775
4306	<(100,200),10> \| (1e-300,-1e-300) \| 213.60679775
4307	<(100,200),10> \| (-10,0) \| 218.25424421
4308	<(100,200),10> \| (-5,-12) \| 226.577682802
4309	<(3,5),0> \| (1e+300,Infinity) \| Infinity
4310	<(3,5),0> \| (Infinity,1e+300) \| Infinity
4311	<(1,2),3> \| (1e+300,Infinity) \| Infinity
4312	<(5,1),3> \| (1e+300,Infinity) \| Infinity
4313	<(5,1),3> \| (Infinity,1e+300) \| Infinity
4314	<(1,2),3> \| (Infinity,1e+300) \| Infinity
4315	<(1,3),5> \| (1e+300,Infinity) \| Infinity
4316	<(1,3),5> \| (Infinity,1e+300) \| Infinity
4317	<(100,200),10> \| (1e+300,Infinity) \| Infinity
4318	<(100,200),10> \| (Infinity,1e+300) \| Infinity
4319	<(1,2),100> \| (1e+300,Infinity) \| Infinity
4320	<(1,2),100> \| (Infinity,1e+300) \| Infinity
4321	<(100,1),115> \| (1e+300,Infinity) \| Infinity
4322	<(100,1),115> \| (Infinity,1e+300) \| Infinity
4323	<(3,5),0> \| (NaN,NaN) \| NaN
4324	<(1,2),3> \| (NaN,NaN) \| NaN
4325	<(5,1),3> \| (NaN,NaN) \| NaN
4326	<(1,3),5> \| (NaN,NaN) \| NaN
4327	<(100,200),10> \| (NaN,NaN) \| NaN
4328	<(1,2),100> \| (NaN,NaN) \| NaN
4329	<(100,1),115> \| (NaN,NaN) \| NaN
4330	<(3,5),NaN> \| (-10,0) \| NaN
4331	<(3,5),NaN> \| (-5,-12) \| NaN
4332	<(3,5),NaN> \| (-3,4) \| NaN
4333	<(3,5),NaN> \| (0,0) \| NaN
4334	<(3,5),NaN> \| (1e-300,-1e-300) \| NaN
4335	<(3,5),NaN> \| (5.1,34.5) \| NaN
4336	<(3,5),NaN> \| (10,10) \| NaN
4337	<(3,5),NaN> \| (1e+300,Infinity) \| NaN
4338	<(3,5),NaN> \| (Infinity,1e+300) \| NaN
4339	<(3,5),NaN> \| (NaN,NaN) \| NaN
4340	(61 rows)
4341
4342	-- To polygon	4278	-- To polygon
4343	SELECT f1, f1::polygon FROM CIRCLE_TBL WHERE f1 >= '<(0,0),1>';	4279	SELECT f1, f1::polygon FROM CIRCLE_TBL WHERE f1 >= '<(0,0),1>';
4344	f1 \| f1	4280	f1 \| f1

Lines 1051-1160 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/horology.out (-104 / +1 lines)
1051	SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"	1051	SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"
1052	FROM TIME_TBL t, INTERVAL_TBL i	1052	FROM TIME_TBL t, INTERVAL_TBL i
1053	ORDER BY 1,2;	1053	ORDER BY 1,2;
1054	t \| i \| add \| subtract	1054	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
1055	-------------+-------------------------------+-------------+-------------
1056	00:00:00 \| @ 14 secs ago \| 23:59:46 \| 00:00:14
1057	00:00:00 \| @ 1 min \| 00:01:00 \| 23:59:00
1058	00:00:00 \| @ 5 hours \| 05:00:00 \| 19:00:00
1059	00:00:00 \| @ 1 day 2 hours 3 mins 4 secs \| 02:03:04 \| 21:56:56
1060	00:00:00 \| @ 10 days \| 00:00:00 \| 00:00:00
1061	00:00:00 \| @ 3 mons \| 00:00:00 \| 00:00:00
1062	00:00:00 \| @ 5 mons \| 00:00:00 \| 00:00:00
1063	00:00:00 \| @ 5 mons 12 hours \| 12:00:00 \| 12:00:00
1064	00:00:00 \| @ 6 years \| 00:00:00 \| 00:00:00
1065	00:00:00 \| @ 34 years \| 00:00:00 \| 00:00:00
1066	01:00:00 \| @ 14 secs ago \| 00:59:46 \| 01:00:14
1067	01:00:00 \| @ 1 min \| 01:01:00 \| 00:59:00
1068	01:00:00 \| @ 5 hours \| 06:00:00 \| 20:00:00
1069	01:00:00 \| @ 1 day 2 hours 3 mins 4 secs \| 03:03:04 \| 22:56:56
1070	01:00:00 \| @ 10 days \| 01:00:00 \| 01:00:00
1071	01:00:00 \| @ 3 mons \| 01:00:00 \| 01:00:00
1072	01:00:00 \| @ 5 mons \| 01:00:00 \| 01:00:00
1073	01:00:00 \| @ 5 mons 12 hours \| 13:00:00 \| 13:00:00
1074	01:00:00 \| @ 6 years \| 01:00:00 \| 01:00:00
1075	01:00:00 \| @ 34 years \| 01:00:00 \| 01:00:00
1076	02:03:00 \| @ 14 secs ago \| 02:02:46 \| 02:03:14
1077	02:03:00 \| @ 1 min \| 02:04:00 \| 02:02:00
1078	02:03:00 \| @ 5 hours \| 07:03:00 \| 21:03:00
1079	02:03:00 \| @ 1 day 2 hours 3 mins 4 secs \| 04:06:04 \| 23:59:56
1080	02:03:00 \| @ 10 days \| 02:03:00 \| 02:03:00
1081	02:03:00 \| @ 3 mons \| 02:03:00 \| 02:03:00
1082	02:03:00 \| @ 5 mons \| 02:03:00 \| 02:03:00
1083	02:03:00 \| @ 5 mons 12 hours \| 14:03:00 \| 14:03:00
1084	02:03:00 \| @ 6 years \| 02:03:00 \| 02:03:00
1085	02:03:00 \| @ 34 years \| 02:03:00 \| 02:03:00
1086	11:59:00 \| @ 14 secs ago \| 11:58:46 \| 11:59:14
1087	11:59:00 \| @ 1 min \| 12:00:00 \| 11:58:00
1088	11:59:00 \| @ 5 hours \| 16:59:00 \| 06:59:00
1089	11:59:00 \| @ 1 day 2 hours 3 mins 4 secs \| 14:02:04 \| 09:55:56
1090	11:59:00 \| @ 10 days \| 11:59:00 \| 11:59:00
1091	11:59:00 \| @ 3 mons \| 11:59:00 \| 11:59:00
1092	11:59:00 \| @ 5 mons \| 11:59:00 \| 11:59:00
1093	11:59:00 \| @ 5 mons 12 hours \| 23:59:00 \| 23:59:00
1094	11:59:00 \| @ 6 years \| 11:59:00 \| 11:59:00
1095	11:59:00 \| @ 34 years \| 11:59:00 \| 11:59:00
1096	12:00:00 \| @ 14 secs ago \| 11:59:46 \| 12:00:14
1097	12:00:00 \| @ 1 min \| 12:01:00 \| 11:59:00
1098	12:00:00 \| @ 5 hours \| 17:00:00 \| 07:00:00
1099	12:00:00 \| @ 1 day 2 hours 3 mins 4 secs \| 14:03:04 \| 09:56:56
1100	12:00:00 \| @ 10 days \| 12:00:00 \| 12:00:00
1101	12:00:00 \| @ 3 mons \| 12:00:00 \| 12:00:00
1102	12:00:00 \| @ 5 mons \| 12:00:00 \| 12:00:00
1103	12:00:00 \| @ 5 mons 12 hours \| 00:00:00 \| 00:00:00
1104	12:00:00 \| @ 6 years \| 12:00:00 \| 12:00:00
1105	12:00:00 \| @ 34 years \| 12:00:00 \| 12:00:00
1106	12:01:00 \| @ 14 secs ago \| 12:00:46 \| 12:01:14
1107	12:01:00 \| @ 1 min \| 12:02:00 \| 12:00:00
1108	12:01:00 \| @ 5 hours \| 17:01:00 \| 07:01:00
1109	12:01:00 \| @ 1 day 2 hours 3 mins 4 secs \| 14:04:04 \| 09:57:56
1110	12:01:00 \| @ 10 days \| 12:01:00 \| 12:01:00
1111	12:01:00 \| @ 3 mons \| 12:01:00 \| 12:01:00
1112	12:01:00 \| @ 5 mons \| 12:01:00 \| 12:01:00
1113	12:01:00 \| @ 5 mons 12 hours \| 00:01:00 \| 00:01:00
1114	12:01:00 \| @ 6 years \| 12:01:00 \| 12:01:00
1115	12:01:00 \| @ 34 years \| 12:01:00 \| 12:01:00
1116	15:36:39 \| @ 14 secs ago \| 15:36:25 \| 15:36:53
1117	15:36:39 \| @ 14 secs ago \| 15:36:25 \| 15:36:53
1118	15:36:39 \| @ 1 min \| 15:37:39 \| 15:35:39
1119	15:36:39 \| @ 1 min \| 15:37:39 \| 15:35:39
1120	15:36:39 \| @ 5 hours \| 20:36:39 \| 10:36:39
1121	15:36:39 \| @ 5 hours \| 20:36:39 \| 10:36:39
1122	15:36:39 \| @ 1 day 2 hours 3 mins 4 secs \| 17:39:43 \| 13:33:35
1123	15:36:39 \| @ 1 day 2 hours 3 mins 4 secs \| 17:39:43 \| 13:33:35
1124	15:36:39 \| @ 10 days \| 15:36:39 \| 15:36:39
1125	15:36:39 \| @ 10 days \| 15:36:39 \| 15:36:39
1126	15:36:39 \| @ 3 mons \| 15:36:39 \| 15:36:39
1127	15:36:39 \| @ 3 mons \| 15:36:39 \| 15:36:39
1128	15:36:39 \| @ 5 mons \| 15:36:39 \| 15:36:39
1129	15:36:39 \| @ 5 mons \| 15:36:39 \| 15:36:39
1130	15:36:39 \| @ 5 mons 12 hours \| 03:36:39 \| 03:36:39
1131	15:36:39 \| @ 5 mons 12 hours \| 03:36:39 \| 03:36:39
1132	15:36:39 \| @ 6 years \| 15:36:39 \| 15:36:39
1133	15:36:39 \| @ 6 years \| 15:36:39 \| 15:36:39
1134	15:36:39 \| @ 34 years \| 15:36:39 \| 15:36:39
1135	15:36:39 \| @ 34 years \| 15:36:39 \| 15:36:39
1136	23:59:00 \| @ 14 secs ago \| 23:58:46 \| 23:59:14
1137	23:59:00 \| @ 1 min \| 00:00:00 \| 23:58:00
1138	23:59:00 \| @ 5 hours \| 04:59:00 \| 18:59:00
1139	23:59:00 \| @ 1 day 2 hours 3 mins 4 secs \| 02:02:04 \| 21:55:56
1140	23:59:00 \| @ 10 days \| 23:59:00 \| 23:59:00
1141	23:59:00 \| @ 3 mons \| 23:59:00 \| 23:59:00
1142	23:59:00 \| @ 5 mons \| 23:59:00 \| 23:59:00
1143	23:59:00 \| @ 5 mons 12 hours \| 11:59:00 \| 11:59:00
1144	23:59:00 \| @ 6 years \| 23:59:00 \| 23:59:00
1145	23:59:00 \| @ 34 years \| 23:59:00 \| 23:59:00
1146	23:59:59.99 \| @ 14 secs ago \| 23:59:45.99 \| 00:00:13.99
1147	23:59:59.99 \| @ 1 min \| 00:00:59.99 \| 23:58:59.99
1148	23:59:59.99 \| @ 5 hours \| 04:59:59.99 \| 18:59:59.99
1149	23:59:59.99 \| @ 1 day 2 hours 3 mins 4 secs \| 02:03:03.99 \| 21:56:55.99
1150	23:59:59.99 \| @ 10 days \| 23:59:59.99 \| 23:59:59.99
1151	23:59:59.99 \| @ 3 mons \| 23:59:59.99 \| 23:59:59.99
1152	23:59:59.99 \| @ 5 mons \| 23:59:59.99 \| 23:59:59.99
1153	23:59:59.99 \| @ 5 mons 12 hours \| 11:59:59.99 \| 11:59:59.99
1154	23:59:59.99 \| @ 6 years \| 23:59:59.99 \| 23:59:59.99
1155	23:59:59.99 \| @ 34 years \| 23:59:59.99 \| 23:59:59.99
1156	(100 rows)
1157
1158	SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"	1055	SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"
1159	FROM TIMETZ_TBL t, INTERVAL_TBL i	1056	FROM TIMETZ_TBL t, INTERVAL_TBL i
1160	ORDER BY 1,2;	1057	ORDER BY 1,2;

Lines 148-157 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/type_sanity.out (-4 / +1 lines)
148	FROM pg_type t	148	FROM pg_type t
149	WHERE t.typarray = proargtypes[array_length(proargtypes, 1)-1])	149	WHERE t.typarray = proargtypes[array_length(proargtypes, 1)-1])
150	END != provariadic;	150	END != provariadic;
151	oid \| provariadic \| proargtypes	151	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
152	-----+-------------+-------------
153	(0 rows)
154
155	-- Check that all and only those functions with a variadic type have	152	-- Check that all and only those functions with a variadic type have
156	-- a variadic argument.	153	-- a variadic argument.
157	SELECT oid::regprocedure, proargmodes, provariadic	154	SELECT oid::regprocedure, proargmodes, provariadic

Lines 342-351 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/create_index_spgist.out (-4 / +1 lines)
342	SELECT * FROM quad_point_tbl_ord_seq1 seq FULL JOIN quad_point_tbl_ord_idx1 idx	342	SELECT * FROM quad_point_tbl_ord_seq1 seq FULL JOIN quad_point_tbl_ord_idx1 idx
343	ON seq.n = idx.n	343	ON seq.n = idx.n
344	WHERE seq.dist IS DISTINCT FROM idx.dist;	344	WHERE seq.dist IS DISTINCT FROM idx.dist;
345	n \| dist \| p \| n \| dist \| p	345	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
346	---+------+---+---+------+---
347	(0 rows)
348
349	EXPLAIN (COSTS OFF)	346	EXPLAIN (COSTS OFF)
350	SELECT row_number() OVER (ORDER BY p <-> '0,0') n, p <-> '0,0' dist, p	347	SELECT row_number() OVER (ORDER BY p <-> '0,0') n, p <-> '0,0' dist, p
351	FROM quad_point_tbl WHERE p <@ box '(200,200,1000,1000)';	348	FROM quad_point_tbl WHERE p <@ box '(200,200,1000,1000)';




(4 rows)

select sillysrf(-1) order by 1;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
----------
       -1
        1
        2
       10
(4 rows)

drop function sillysrf(int);
-- X = X isn't a no-op, it's effectively X IS NOT NULL assuming = is strict
-- (see bug #5084)




set enable_seqscan = off;  -- plan with fewest seqscans should be merge
set enable_parallel_append = off; -- Don't let parallel-append interfere
explain (verbose, costs off) select * from matest0 order by 1-id;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
------------------------------------------------------------------------
 Merge Append
   Sort Key: ((1 - matest0.id))
   ->  Index Scan using matest0i on public.matest0 matest0_1
         Output: matest0_1.id, matest0_1.name, (1 - matest0_1.id)
   ->  Index Scan using matest1i on public.matest1 matest0_2
         Output: matest0_2.id, matest0_2.name, (1 - matest0_2.id)
   ->  Sort
         Output: matest0_3.id, matest0_3.name, ((1 - matest0_3.id))
         Sort Key: ((1 - matest0_3.id))
         ->  Seq Scan on public.matest2 matest0_3
               Output: matest0_3.id, matest0_3.name, (1 - matest0_3.id)
   ->  Index Scan using matest3i on public.matest3 matest0_4
         Output: matest0_4.id, matest0_4.name, (1 - matest0_4.id)
(13 rows)

select * from matest0 order by 1-id;
 id |  name  
----+--------




WHERE pa.oid = pc.relam
   AND pa.amname = 'heap2'
ORDER BY 3, 1, 2;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
---------+--------+----------------------------------
 r       | heap2  | tableam_parted_b_heap2
 r       | heap2  | tableam_parted_d_heap2
 r       | heap2  | tableam_tbl_heap2
 r       | heap2  | tableam_tblas_heap2
 m       | heap2  | tableam_tblmv_heap2
 t       | heap2  | toast for tableam_parted_b_heap2
 t       | heap2  | toast for tableam_parted_d_heap2
(7 rows)

-- Show dependencies onto AM - there shouldn't be any for toast
SELECT pg_describe_object(classid,objid,objsubid) AS obj
FROM pg_depend, pg_am




SET jit_above_cost=0;
EXPLAIN (costs off)
SELECT DISTINCT g%1000 FROM generate_series(0,9999) g;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
------------------------------------------------
 Unique
   ->  Sort
         Sort Key: ((g % 1000))
         ->  Function Scan on generate_series g
(4 rows)

CREATE TABLE distinct_group_1 AS
SELECT DISTINCT g%1000 FROM generate_series(0,9999) g;
SET jit_above_cost TO DEFAULT;

Lines 663-1563 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/join.out (-895 / +1 lines)
663		663
664	SELECT *	664	SELECT *
665	FROM J1_TBL CROSS JOIN J2_TBL a CROSS JOIN J2_TBL b;	665	FROM J1_TBL CROSS JOIN J2_TBL a CROSS JOIN J2_TBL b;
666	i \| j \| t \| i \| k \| i \| k	666	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
667	---+---+-------+---+----+---+----
668	1 \| 4 \| one \| 1 \| -1 \| 1 \| -1
669	1 \| 4 \| one \| 1 \| -1 \| 2 \| 2
670	1 \| 4 \| one \| 1 \| -1 \| 3 \| -3
671	1 \| 4 \| one \| 1 \| -1 \| 2 \| 4
672	1 \| 4 \| one \| 1 \| -1 \| 5 \| -5
673	1 \| 4 \| one \| 1 \| -1 \| 5 \| -5
674	1 \| 4 \| one \| 1 \| -1 \| 0 \|
675	1 \| 4 \| one \| 1 \| -1 \| \|
676	1 \| 4 \| one \| 1 \| -1 \| \| 0
677	2 \| 3 \| two \| 1 \| -1 \| 1 \| -1
678	2 \| 3 \| two \| 1 \| -1 \| 2 \| 2
679	2 \| 3 \| two \| 1 \| -1 \| 3 \| -3
680	2 \| 3 \| two \| 1 \| -1 \| 2 \| 4
681	2 \| 3 \| two \| 1 \| -1 \| 5 \| -5
682	2 \| 3 \| two \| 1 \| -1 \| 5 \| -5
683	2 \| 3 \| two \| 1 \| -1 \| 0 \|
684	2 \| 3 \| two \| 1 \| -1 \| \|
685	2 \| 3 \| two \| 1 \| -1 \| \| 0
686	3 \| 2 \| three \| 1 \| -1 \| 1 \| -1
687	3 \| 2 \| three \| 1 \| -1 \| 2 \| 2
688	3 \| 2 \| three \| 1 \| -1 \| 3 \| -3
689	3 \| 2 \| three \| 1 \| -1 \| 2 \| 4
690	3 \| 2 \| three \| 1 \| -1 \| 5 \| -5
691	3 \| 2 \| three \| 1 \| -1 \| 5 \| -5
692	3 \| 2 \| three \| 1 \| -1 \| 0 \|
693	3 \| 2 \| three \| 1 \| -1 \| \|
694	3 \| 2 \| three \| 1 \| -1 \| \| 0
695	4 \| 1 \| four \| 1 \| -1 \| 1 \| -1
696	4 \| 1 \| four \| 1 \| -1 \| 2 \| 2
697	4 \| 1 \| four \| 1 \| -1 \| 3 \| -3
698	4 \| 1 \| four \| 1 \| -1 \| 2 \| 4
699	4 \| 1 \| four \| 1 \| -1 \| 5 \| -5
700	4 \| 1 \| four \| 1 \| -1 \| 5 \| -5
701	4 \| 1 \| four \| 1 \| -1 \| 0 \|
702	4 \| 1 \| four \| 1 \| -1 \| \|
703	4 \| 1 \| four \| 1 \| -1 \| \| 0
704	5 \| 0 \| five \| 1 \| -1 \| 1 \| -1
705	5 \| 0 \| five \| 1 \| -1 \| 2 \| 2
706	5 \| 0 \| five \| 1 \| -1 \| 3 \| -3
707	5 \| 0 \| five \| 1 \| -1 \| 2 \| 4
708	5 \| 0 \| five \| 1 \| -1 \| 5 \| -5
709	5 \| 0 \| five \| 1 \| -1 \| 5 \| -5
710	5 \| 0 \| five \| 1 \| -1 \| 0 \|
711	5 \| 0 \| five \| 1 \| -1 \| \|
712	5 \| 0 \| five \| 1 \| -1 \| \| 0
713	6 \| 6 \| six \| 1 \| -1 \| 1 \| -1
714	6 \| 6 \| six \| 1 \| -1 \| 2 \| 2
715	6 \| 6 \| six \| 1 \| -1 \| 3 \| -3
716	6 \| 6 \| six \| 1 \| -1 \| 2 \| 4
717	6 \| 6 \| six \| 1 \| -1 \| 5 \| -5
718	6 \| 6 \| six \| 1 \| -1 \| 5 \| -5
719	6 \| 6 \| six \| 1 \| -1 \| 0 \|
720	6 \| 6 \| six \| 1 \| -1 \| \|
721	6 \| 6 \| six \| 1 \| -1 \| \| 0
722	7 \| 7 \| seven \| 1 \| -1 \| 1 \| -1
723	7 \| 7 \| seven \| 1 \| -1 \| 2 \| 2
724	7 \| 7 \| seven \| 1 \| -1 \| 3 \| -3
725	7 \| 7 \| seven \| 1 \| -1 \| 2 \| 4
726	7 \| 7 \| seven \| 1 \| -1 \| 5 \| -5
727	7 \| 7 \| seven \| 1 \| -1 \| 5 \| -5
728	7 \| 7 \| seven \| 1 \| -1 \| 0 \|
729	7 \| 7 \| seven \| 1 \| -1 \| \|
730	7 \| 7 \| seven \| 1 \| -1 \| \| 0
731	8 \| 8 \| eight \| 1 \| -1 \| 1 \| -1
732	8 \| 8 \| eight \| 1 \| -1 \| 2 \| 2
733	8 \| 8 \| eight \| 1 \| -1 \| 3 \| -3
734	8 \| 8 \| eight \| 1 \| -1 \| 2 \| 4
735	8 \| 8 \| eight \| 1 \| -1 \| 5 \| -5
736	8 \| 8 \| eight \| 1 \| -1 \| 5 \| -5
737	8 \| 8 \| eight \| 1 \| -1 \| 0 \|
738	8 \| 8 \| eight \| 1 \| -1 \| \|
739	8 \| 8 \| eight \| 1 \| -1 \| \| 0
740	0 \| \| zero \| 1 \| -1 \| 1 \| -1
741	0 \| \| zero \| 1 \| -1 \| 2 \| 2
742	0 \| \| zero \| 1 \| -1 \| 3 \| -3
743	0 \| \| zero \| 1 \| -1 \| 2 \| 4
744	0 \| \| zero \| 1 \| -1 \| 5 \| -5
745	0 \| \| zero \| 1 \| -1 \| 5 \| -5
746	0 \| \| zero \| 1 \| -1 \| 0 \|
747	0 \| \| zero \| 1 \| -1 \| \|
748	0 \| \| zero \| 1 \| -1 \| \| 0
749	\| \| null \| 1 \| -1 \| 1 \| -1
750	\| \| null \| 1 \| -1 \| 2 \| 2
751	\| \| null \| 1 \| -1 \| 3 \| -3
752	\| \| null \| 1 \| -1 \| 2 \| 4
753	\| \| null \| 1 \| -1 \| 5 \| -5
754	\| \| null \| 1 \| -1 \| 5 \| -5
755	\| \| null \| 1 \| -1 \| 0 \|
756	\| \| null \| 1 \| -1 \| \|
757	\| \| null \| 1 \| -1 \| \| 0
758	\| 0 \| zero \| 1 \| -1 \| 1 \| -1
759	\| 0 \| zero \| 1 \| -1 \| 2 \| 2
760	\| 0 \| zero \| 1 \| -1 \| 3 \| -3
761	\| 0 \| zero \| 1 \| -1 \| 2 \| 4
762	\| 0 \| zero \| 1 \| -1 \| 5 \| -5
763	\| 0 \| zero \| 1 \| -1 \| 5 \| -5
764	\| 0 \| zero \| 1 \| -1 \| 0 \|
765	\| 0 \| zero \| 1 \| -1 \| \|
766	\| 0 \| zero \| 1 \| -1 \| \| 0
767	1 \| 4 \| one \| 2 \| 2 \| 1 \| -1
768	1 \| 4 \| one \| 2 \| 2 \| 2 \| 2
769	1 \| 4 \| one \| 2 \| 2 \| 3 \| -3
770	1 \| 4 \| one \| 2 \| 2 \| 2 \| 4
771	1 \| 4 \| one \| 2 \| 2 \| 5 \| -5
772	1 \| 4 \| one \| 2 \| 2 \| 5 \| -5
773	1 \| 4 \| one \| 2 \| 2 \| 0 \|
774	1 \| 4 \| one \| 2 \| 2 \| \|
775	1 \| 4 \| one \| 2 \| 2 \| \| 0
776	2 \| 3 \| two \| 2 \| 2 \| 1 \| -1
777	2 \| 3 \| two \| 2 \| 2 \| 2 \| 2
778	2 \| 3 \| two \| 2 \| 2 \| 3 \| -3
779	2 \| 3 \| two \| 2 \| 2 \| 2 \| 4
780	2 \| 3 \| two \| 2 \| 2 \| 5 \| -5
781	2 \| 3 \| two \| 2 \| 2 \| 5 \| -5
782	2 \| 3 \| two \| 2 \| 2 \| 0 \|
783	2 \| 3 \| two \| 2 \| 2 \| \|
784	2 \| 3 \| two \| 2 \| 2 \| \| 0
785	3 \| 2 \| three \| 2 \| 2 \| 1 \| -1
786	3 \| 2 \| three \| 2 \| 2 \| 2 \| 2
787	3 \| 2 \| three \| 2 \| 2 \| 3 \| -3
788	3 \| 2 \| three \| 2 \| 2 \| 2 \| 4
789	3 \| 2 \| three \| 2 \| 2 \| 5 \| -5
790	3 \| 2 \| three \| 2 \| 2 \| 5 \| -5
791	3 \| 2 \| three \| 2 \| 2 \| 0 \|
792	3 \| 2 \| three \| 2 \| 2 \| \|
793	3 \| 2 \| three \| 2 \| 2 \| \| 0
794	4 \| 1 \| four \| 2 \| 2 \| 1 \| -1
795	4 \| 1 \| four \| 2 \| 2 \| 2 \| 2
796	4 \| 1 \| four \| 2 \| 2 \| 3 \| -3
797	4 \| 1 \| four \| 2 \| 2 \| 2 \| 4
798	4 \| 1 \| four \| 2 \| 2 \| 5 \| -5
799	4 \| 1 \| four \| 2 \| 2 \| 5 \| -5
800	4 \| 1 \| four \| 2 \| 2 \| 0 \|
801	4 \| 1 \| four \| 2 \| 2 \| \|
802	4 \| 1 \| four \| 2 \| 2 \| \| 0
803	5 \| 0 \| five \| 2 \| 2 \| 1 \| -1
804	5 \| 0 \| five \| 2 \| 2 \| 2 \| 2
805	5 \| 0 \| five \| 2 \| 2 \| 3 \| -3
806	5 \| 0 \| five \| 2 \| 2 \| 2 \| 4
807	5 \| 0 \| five \| 2 \| 2 \| 5 \| -5
808	5 \| 0 \| five \| 2 \| 2 \| 5 \| -5
809	5 \| 0 \| five \| 2 \| 2 \| 0 \|
810	5 \| 0 \| five \| 2 \| 2 \| \|
811	5 \| 0 \| five \| 2 \| 2 \| \| 0
812	6 \| 6 \| six \| 2 \| 2 \| 1 \| -1
813	6 \| 6 \| six \| 2 \| 2 \| 2 \| 2
814	6 \| 6 \| six \| 2 \| 2 \| 3 \| -3
815	6 \| 6 \| six \| 2 \| 2 \| 2 \| 4
816	6 \| 6 \| six \| 2 \| 2 \| 5 \| -5
817	6 \| 6 \| six \| 2 \| 2 \| 5 \| -5
818	6 \| 6 \| six \| 2 \| 2 \| 0 \|
819	6 \| 6 \| six \| 2 \| 2 \| \|
820	6 \| 6 \| six \| 2 \| 2 \| \| 0
821	7 \| 7 \| seven \| 2 \| 2 \| 1 \| -1
822	7 \| 7 \| seven \| 2 \| 2 \| 2 \| 2
823	7 \| 7 \| seven \| 2 \| 2 \| 3 \| -3
824	7 \| 7 \| seven \| 2 \| 2 \| 2 \| 4
825	7 \| 7 \| seven \| 2 \| 2 \| 5 \| -5
826	7 \| 7 \| seven \| 2 \| 2 \| 5 \| -5
827	7 \| 7 \| seven \| 2 \| 2 \| 0 \|
828	7 \| 7 \| seven \| 2 \| 2 \| \|
829	7 \| 7 \| seven \| 2 \| 2 \| \| 0
830	8 \| 8 \| eight \| 2 \| 2 \| 1 \| -1
831	8 \| 8 \| eight \| 2 \| 2 \| 2 \| 2
832	8 \| 8 \| eight \| 2 \| 2 \| 3 \| -3
833	8 \| 8 \| eight \| 2 \| 2 \| 2 \| 4
834	8 \| 8 \| eight \| 2 \| 2 \| 5 \| -5
835	8 \| 8 \| eight \| 2 \| 2 \| 5 \| -5
836	8 \| 8 \| eight \| 2 \| 2 \| 0 \|
837	8 \| 8 \| eight \| 2 \| 2 \| \|
838	8 \| 8 \| eight \| 2 \| 2 \| \| 0
839	0 \| \| zero \| 2 \| 2 \| 1 \| -1
840	0 \| \| zero \| 2 \| 2 \| 2 \| 2
841	0 \| \| zero \| 2 \| 2 \| 3 \| -3
842	0 \| \| zero \| 2 \| 2 \| 2 \| 4
843	0 \| \| zero \| 2 \| 2 \| 5 \| -5
844	0 \| \| zero \| 2 \| 2 \| 5 \| -5
845	0 \| \| zero \| 2 \| 2 \| 0 \|
846	0 \| \| zero \| 2 \| 2 \| \|
847	0 \| \| zero \| 2 \| 2 \| \| 0
848	\| \| null \| 2 \| 2 \| 1 \| -1
849	\| \| null \| 2 \| 2 \| 2 \| 2
850	\| \| null \| 2 \| 2 \| 3 \| -3
851	\| \| null \| 2 \| 2 \| 2 \| 4
852	\| \| null \| 2 \| 2 \| 5 \| -5
853	\| \| null \| 2 \| 2 \| 5 \| -5
854	\| \| null \| 2 \| 2 \| 0 \|
855	\| \| null \| 2 \| 2 \| \|
856	\| \| null \| 2 \| 2 \| \| 0
857	\| 0 \| zero \| 2 \| 2 \| 1 \| -1
858	\| 0 \| zero \| 2 \| 2 \| 2 \| 2
859	\| 0 \| zero \| 2 \| 2 \| 3 \| -3
860	\| 0 \| zero \| 2 \| 2 \| 2 \| 4
861	\| 0 \| zero \| 2 \| 2 \| 5 \| -5
862	\| 0 \| zero \| 2 \| 2 \| 5 \| -5
863	\| 0 \| zero \| 2 \| 2 \| 0 \|
864	\| 0 \| zero \| 2 \| 2 \| \|
865	\| 0 \| zero \| 2 \| 2 \| \| 0
866	1 \| 4 \| one \| 3 \| -3 \| 1 \| -1
867	1 \| 4 \| one \| 3 \| -3 \| 2 \| 2
868	1 \| 4 \| one \| 3 \| -3 \| 3 \| -3
869	1 \| 4 \| one \| 3 \| -3 \| 2 \| 4
870	1 \| 4 \| one \| 3 \| -3 \| 5 \| -5
871	1 \| 4 \| one \| 3 \| -3 \| 5 \| -5
872	1 \| 4 \| one \| 3 \| -3 \| 0 \|
873	1 \| 4 \| one \| 3 \| -3 \| \|
874	1 \| 4 \| one \| 3 \| -3 \| \| 0
875	2 \| 3 \| two \| 3 \| -3 \| 1 \| -1
876	2 \| 3 \| two \| 3 \| -3 \| 2 \| 2
877	2 \| 3 \| two \| 3 \| -3 \| 3 \| -3
878	2 \| 3 \| two \| 3 \| -3 \| 2 \| 4
879	2 \| 3 \| two \| 3 \| -3 \| 5 \| -5
880	2 \| 3 \| two \| 3 \| -3 \| 5 \| -5
881	2 \| 3 \| two \| 3 \| -3 \| 0 \|
882	2 \| 3 \| two \| 3 \| -3 \| \|
883	2 \| 3 \| two \| 3 \| -3 \| \| 0
884	3 \| 2 \| three \| 3 \| -3 \| 1 \| -1
885	3 \| 2 \| three \| 3 \| -3 \| 2 \| 2
886	3 \| 2 \| three \| 3 \| -3 \| 3 \| -3
887	3 \| 2 \| three \| 3 \| -3 \| 2 \| 4
888	3 \| 2 \| three \| 3 \| -3 \| 5 \| -5
889	3 \| 2 \| three \| 3 \| -3 \| 5 \| -5
890	3 \| 2 \| three \| 3 \| -3 \| 0 \|
891	3 \| 2 \| three \| 3 \| -3 \| \|
892	3 \| 2 \| three \| 3 \| -3 \| \| 0
893	4 \| 1 \| four \| 3 \| -3 \| 1 \| -1
894	4 \| 1 \| four \| 3 \| -3 \| 2 \| 2
895	4 \| 1 \| four \| 3 \| -3 \| 3 \| -3
896	4 \| 1 \| four \| 3 \| -3 \| 2 \| 4
897	4 \| 1 \| four \| 3 \| -3 \| 5 \| -5
898	4 \| 1 \| four \| 3 \| -3 \| 5 \| -5
899	4 \| 1 \| four \| 3 \| -3 \| 0 \|
900	4 \| 1 \| four \| 3 \| -3 \| \|
901	4 \| 1 \| four \| 3 \| -3 \| \| 0
902	5 \| 0 \| five \| 3 \| -3 \| 1 \| -1
903	5 \| 0 \| five \| 3 \| -3 \| 2 \| 2
904	5 \| 0 \| five \| 3 \| -3 \| 3 \| -3
905	5 \| 0 \| five \| 3 \| -3 \| 2 \| 4
906	5 \| 0 \| five \| 3 \| -3 \| 5 \| -5
907	5 \| 0 \| five \| 3 \| -3 \| 5 \| -5
908	5 \| 0 \| five \| 3 \| -3 \| 0 \|
909	5 \| 0 \| five \| 3 \| -3 \| \|
910	5 \| 0 \| five \| 3 \| -3 \| \| 0
911	6 \| 6 \| six \| 3 \| -3 \| 1 \| -1
912	6 \| 6 \| six \| 3 \| -3 \| 2 \| 2
913	6 \| 6 \| six \| 3 \| -3 \| 3 \| -3
914	6 \| 6 \| six \| 3 \| -3 \| 2 \| 4
915	6 \| 6 \| six \| 3 \| -3 \| 5 \| -5
916	6 \| 6 \| six \| 3 \| -3 \| 5 \| -5
917	6 \| 6 \| six \| 3 \| -3 \| 0 \|
918	6 \| 6 \| six \| 3 \| -3 \| \|
919	6 \| 6 \| six \| 3 \| -3 \| \| 0
920	7 \| 7 \| seven \| 3 \| -3 \| 1 \| -1
921	7 \| 7 \| seven \| 3 \| -3 \| 2 \| 2
922	7 \| 7 \| seven \| 3 \| -3 \| 3 \| -3
923	7 \| 7 \| seven \| 3 \| -3 \| 2 \| 4
924	7 \| 7 \| seven \| 3 \| -3 \| 5 \| -5
925	7 \| 7 \| seven \| 3 \| -3 \| 5 \| -5
926	7 \| 7 \| seven \| 3 \| -3 \| 0 \|
927	7 \| 7 \| seven \| 3 \| -3 \| \|
928	7 \| 7 \| seven \| 3 \| -3 \| \| 0
929	8 \| 8 \| eight \| 3 \| -3 \| 1 \| -1
930	8 \| 8 \| eight \| 3 \| -3 \| 2 \| 2
931	8 \| 8 \| eight \| 3 \| -3 \| 3 \| -3
932	8 \| 8 \| eight \| 3 \| -3 \| 2 \| 4
933	8 \| 8 \| eight \| 3 \| -3 \| 5 \| -5
934	8 \| 8 \| eight \| 3 \| -3 \| 5 \| -5
935	8 \| 8 \| eight \| 3 \| -3 \| 0 \|
936	8 \| 8 \| eight \| 3 \| -3 \| \|
937	8 \| 8 \| eight \| 3 \| -3 \| \| 0
938	0 \| \| zero \| 3 \| -3 \| 1 \| -1
939	0 \| \| zero \| 3 \| -3 \| 2 \| 2
940	0 \| \| zero \| 3 \| -3 \| 3 \| -3
941	0 \| \| zero \| 3 \| -3 \| 2 \| 4
942	0 \| \| zero \| 3 \| -3 \| 5 \| -5
943	0 \| \| zero \| 3 \| -3 \| 5 \| -5
944	0 \| \| zero \| 3 \| -3 \| 0 \|
945	0 \| \| zero \| 3 \| -3 \| \|
946	0 \| \| zero \| 3 \| -3 \| \| 0
947	\| \| null \| 3 \| -3 \| 1 \| -1
948	\| \| null \| 3 \| -3 \| 2 \| 2
949	\| \| null \| 3 \| -3 \| 3 \| -3
950	\| \| null \| 3 \| -3 \| 2 \| 4
951	\| \| null \| 3 \| -3 \| 5 \| -5
952	\| \| null \| 3 \| -3 \| 5 \| -5
953	\| \| null \| 3 \| -3 \| 0 \|
954	\| \| null \| 3 \| -3 \| \|
955	\| \| null \| 3 \| -3 \| \| 0
956	\| 0 \| zero \| 3 \| -3 \| 1 \| -1
957	\| 0 \| zero \| 3 \| -3 \| 2 \| 2
958	\| 0 \| zero \| 3 \| -3 \| 3 \| -3
959	\| 0 \| zero \| 3 \| -3 \| 2 \| 4
960	\| 0 \| zero \| 3 \| -3 \| 5 \| -5
961	\| 0 \| zero \| 3 \| -3 \| 5 \| -5
962	\| 0 \| zero \| 3 \| -3 \| 0 \|
963	\| 0 \| zero \| 3 \| -3 \| \|
964	\| 0 \| zero \| 3 \| -3 \| \| 0
965	1 \| 4 \| one \| 2 \| 4 \| 1 \| -1
966	1 \| 4 \| one \| 2 \| 4 \| 2 \| 2
967	1 \| 4 \| one \| 2 \| 4 \| 3 \| -3
968	1 \| 4 \| one \| 2 \| 4 \| 2 \| 4
969	1 \| 4 \| one \| 2 \| 4 \| 5 \| -5
970	1 \| 4 \| one \| 2 \| 4 \| 5 \| -5
971	1 \| 4 \| one \| 2 \| 4 \| 0 \|
972	1 \| 4 \| one \| 2 \| 4 \| \|
973	1 \| 4 \| one \| 2 \| 4 \| \| 0
974	2 \| 3 \| two \| 2 \| 4 \| 1 \| -1
975	2 \| 3 \| two \| 2 \| 4 \| 2 \| 2
976	2 \| 3 \| two \| 2 \| 4 \| 3 \| -3
977	2 \| 3 \| two \| 2 \| 4 \| 2 \| 4
978	2 \| 3 \| two \| 2 \| 4 \| 5 \| -5
979	2 \| 3 \| two \| 2 \| 4 \| 5 \| -5
980	2 \| 3 \| two \| 2 \| 4 \| 0 \|
981	2 \| 3 \| two \| 2 \| 4 \| \|
982	2 \| 3 \| two \| 2 \| 4 \| \| 0
983	3 \| 2 \| three \| 2 \| 4 \| 1 \| -1
984	3 \| 2 \| three \| 2 \| 4 \| 2 \| 2
985	3 \| 2 \| three \| 2 \| 4 \| 3 \| -3
986	3 \| 2 \| three \| 2 \| 4 \| 2 \| 4
987	3 \| 2 \| three \| 2 \| 4 \| 5 \| -5
988	3 \| 2 \| three \| 2 \| 4 \| 5 \| -5
989	3 \| 2 \| three \| 2 \| 4 \| 0 \|
990	3 \| 2 \| three \| 2 \| 4 \| \|
991	3 \| 2 \| three \| 2 \| 4 \| \| 0
992	4 \| 1 \| four \| 2 \| 4 \| 1 \| -1
993	4 \| 1 \| four \| 2 \| 4 \| 2 \| 2
994	4 \| 1 \| four \| 2 \| 4 \| 3 \| -3
995	4 \| 1 \| four \| 2 \| 4 \| 2 \| 4
996	4 \| 1 \| four \| 2 \| 4 \| 5 \| -5
997	4 \| 1 \| four \| 2 \| 4 \| 5 \| -5
998	4 \| 1 \| four \| 2 \| 4 \| 0 \|
999	4 \| 1 \| four \| 2 \| 4 \| \|
1000	4 \| 1 \| four \| 2 \| 4 \| \| 0
1001	5 \| 0 \| five \| 2 \| 4 \| 1 \| -1
1002	5 \| 0 \| five \| 2 \| 4 \| 2 \| 2
1003	5 \| 0 \| five \| 2 \| 4 \| 3 \| -3
1004	5 \| 0 \| five \| 2 \| 4 \| 2 \| 4
1005	5 \| 0 \| five \| 2 \| 4 \| 5 \| -5
1006	5 \| 0 \| five \| 2 \| 4 \| 5 \| -5
1007	5 \| 0 \| five \| 2 \| 4 \| 0 \|
1008	5 \| 0 \| five \| 2 \| 4 \| \|
1009	5 \| 0 \| five \| 2 \| 4 \| \| 0
1010	6 \| 6 \| six \| 2 \| 4 \| 1 \| -1
1011	6 \| 6 \| six \| 2 \| 4 \| 2 \| 2
1012	6 \| 6 \| six \| 2 \| 4 \| 3 \| -3
1013	6 \| 6 \| six \| 2 \| 4 \| 2 \| 4
1014	6 \| 6 \| six \| 2 \| 4 \| 5 \| -5
1015	6 \| 6 \| six \| 2 \| 4 \| 5 \| -5
1016	6 \| 6 \| six \| 2 \| 4 \| 0 \|
1017	6 \| 6 \| six \| 2 \| 4 \| \|
1018	6 \| 6 \| six \| 2 \| 4 \| \| 0
1019	7 \| 7 \| seven \| 2 \| 4 \| 1 \| -1
1020	7 \| 7 \| seven \| 2 \| 4 \| 2 \| 2
1021	7 \| 7 \| seven \| 2 \| 4 \| 3 \| -3
1022	7 \| 7 \| seven \| 2 \| 4 \| 2 \| 4
1023	7 \| 7 \| seven \| 2 \| 4 \| 5 \| -5
1024	7 \| 7 \| seven \| 2 \| 4 \| 5 \| -5
1025	7 \| 7 \| seven \| 2 \| 4 \| 0 \|
1026	7 \| 7 \| seven \| 2 \| 4 \| \|
1027	7 \| 7 \| seven \| 2 \| 4 \| \| 0
1028	8 \| 8 \| eight \| 2 \| 4 \| 1 \| -1
1029	8 \| 8 \| eight \| 2 \| 4 \| 2 \| 2
1030	8 \| 8 \| eight \| 2 \| 4 \| 3 \| -3
1031	8 \| 8 \| eight \| 2 \| 4 \| 2 \| 4
1032	8 \| 8 \| eight \| 2 \| 4 \| 5 \| -5
1033	8 \| 8 \| eight \| 2 \| 4 \| 5 \| -5
1034	8 \| 8 \| eight \| 2 \| 4 \| 0 \|
1035	8 \| 8 \| eight \| 2 \| 4 \| \|
1036	8 \| 8 \| eight \| 2 \| 4 \| \| 0
1037	0 \| \| zero \| 2 \| 4 \| 1 \| -1
1038	0 \| \| zero \| 2 \| 4 \| 2 \| 2
1039	0 \| \| zero \| 2 \| 4 \| 3 \| -3
1040	0 \| \| zero \| 2 \| 4 \| 2 \| 4
1041	0 \| \| zero \| 2 \| 4 \| 5 \| -5
1042	0 \| \| zero \| 2 \| 4 \| 5 \| -5
1043	0 \| \| zero \| 2 \| 4 \| 0 \|
1044	0 \| \| zero \| 2 \| 4 \| \|
1045	0 \| \| zero \| 2 \| 4 \| \| 0
1046	\| \| null \| 2 \| 4 \| 1 \| -1
1047	\| \| null \| 2 \| 4 \| 2 \| 2
1048	\| \| null \| 2 \| 4 \| 3 \| -3
1049	\| \| null \| 2 \| 4 \| 2 \| 4
1050	\| \| null \| 2 \| 4 \| 5 \| -5
1051	\| \| null \| 2 \| 4 \| 5 \| -5
1052	\| \| null \| 2 \| 4 \| 0 \|
1053	\| \| null \| 2 \| 4 \| \|
1054	\| \| null \| 2 \| 4 \| \| 0
1055	\| 0 \| zero \| 2 \| 4 \| 1 \| -1
1056	\| 0 \| zero \| 2 \| 4 \| 2 \| 2
1057	\| 0 \| zero \| 2 \| 4 \| 3 \| -3
1058	\| 0 \| zero \| 2 \| 4 \| 2 \| 4
1059	\| 0 \| zero \| 2 \| 4 \| 5 \| -5
1060	\| 0 \| zero \| 2 \| 4 \| 5 \| -5
1061	\| 0 \| zero \| 2 \| 4 \| 0 \|
1062	\| 0 \| zero \| 2 \| 4 \| \|
1063	\| 0 \| zero \| 2 \| 4 \| \| 0
1064	1 \| 4 \| one \| 5 \| -5 \| 1 \| -1
1065	1 \| 4 \| one \| 5 \| -5 \| 2 \| 2
1066	1 \| 4 \| one \| 5 \| -5 \| 3 \| -3
1067	1 \| 4 \| one \| 5 \| -5 \| 2 \| 4
1068	1 \| 4 \| one \| 5 \| -5 \| 5 \| -5
1069	1 \| 4 \| one \| 5 \| -5 \| 5 \| -5
1070	1 \| 4 \| one \| 5 \| -5 \| 0 \|
1071	1 \| 4 \| one \| 5 \| -5 \| \|
1072	1 \| 4 \| one \| 5 \| -5 \| \| 0
1073	2 \| 3 \| two \| 5 \| -5 \| 1 \| -1
1074	2 \| 3 \| two \| 5 \| -5 \| 2 \| 2
1075	2 \| 3 \| two \| 5 \| -5 \| 3 \| -3
1076	2 \| 3 \| two \| 5 \| -5 \| 2 \| 4
1077	2 \| 3 \| two \| 5 \| -5 \| 5 \| -5
1078	2 \| 3 \| two \| 5 \| -5 \| 5 \| -5
1079	2 \| 3 \| two \| 5 \| -5 \| 0 \|
1080	2 \| 3 \| two \| 5 \| -5 \| \|
1081	2 \| 3 \| two \| 5 \| -5 \| \| 0
1082	3 \| 2 \| three \| 5 \| -5 \| 1 \| -1
1083	3 \| 2 \| three \| 5 \| -5 \| 2 \| 2
1084	3 \| 2 \| three \| 5 \| -5 \| 3 \| -3
1085	3 \| 2 \| three \| 5 \| -5 \| 2 \| 4
1086	3 \| 2 \| three \| 5 \| -5 \| 5 \| -5
1087	3 \| 2 \| three \| 5 \| -5 \| 5 \| -5
1088	3 \| 2 \| three \| 5 \| -5 \| 0 \|
1089	3 \| 2 \| three \| 5 \| -5 \| \|
1090	3 \| 2 \| three \| 5 \| -5 \| \| 0
1091	4 \| 1 \| four \| 5 \| -5 \| 1 \| -1
1092	4 \| 1 \| four \| 5 \| -5 \| 2 \| 2
1093	4 \| 1 \| four \| 5 \| -5 \| 3 \| -3
1094	4 \| 1 \| four \| 5 \| -5 \| 2 \| 4
1095	4 \| 1 \| four \| 5 \| -5 \| 5 \| -5
1096	4 \| 1 \| four \| 5 \| -5 \| 5 \| -5
1097	4 \| 1 \| four \| 5 \| -5 \| 0 \|
1098	4 \| 1 \| four \| 5 \| -5 \| \|
1099	4 \| 1 \| four \| 5 \| -5 \| \| 0
1100	5 \| 0 \| five \| 5 \| -5 \| 1 \| -1
1101	5 \| 0 \| five \| 5 \| -5 \| 2 \| 2
1102	5 \| 0 \| five \| 5 \| -5 \| 3 \| -3
1103	5 \| 0 \| five \| 5 \| -5 \| 2 \| 4
1104	5 \| 0 \| five \| 5 \| -5 \| 5 \| -5
1105	5 \| 0 \| five \| 5 \| -5 \| 5 \| -5
1106	5 \| 0 \| five \| 5 \| -5 \| 0 \|
1107	5 \| 0 \| five \| 5 \| -5 \| \|
1108	5 \| 0 \| five \| 5 \| -5 \| \| 0
1109	6 \| 6 \| six \| 5 \| -5 \| 1 \| -1
1110	6 \| 6 \| six \| 5 \| -5 \| 2 \| 2
1111	6 \| 6 \| six \| 5 \| -5 \| 3 \| -3
1112	6 \| 6 \| six \| 5 \| -5 \| 2 \| 4
1113	6 \| 6 \| six \| 5 \| -5 \| 5 \| -5
1114	6 \| 6 \| six \| 5 \| -5 \| 5 \| -5
1115	6 \| 6 \| six \| 5 \| -5 \| 0 \|
1116	6 \| 6 \| six \| 5 \| -5 \| \|
1117	6 \| 6 \| six \| 5 \| -5 \| \| 0
1118	7 \| 7 \| seven \| 5 \| -5 \| 1 \| -1
1119	7 \| 7 \| seven \| 5 \| -5 \| 2 \| 2
1120	7 \| 7 \| seven \| 5 \| -5 \| 3 \| -3
1121	7 \| 7 \| seven \| 5 \| -5 \| 2 \| 4
1122	7 \| 7 \| seven \| 5 \| -5 \| 5 \| -5
1123	7 \| 7 \| seven \| 5 \| -5 \| 5 \| -5
1124	7 \| 7 \| seven \| 5 \| -5 \| 0 \|
1125	7 \| 7 \| seven \| 5 \| -5 \| \|
1126	7 \| 7 \| seven \| 5 \| -5 \| \| 0
1127	8 \| 8 \| eight \| 5 \| -5 \| 1 \| -1
1128	8 \| 8 \| eight \| 5 \| -5 \| 2 \| 2
1129	8 \| 8 \| eight \| 5 \| -5 \| 3 \| -3
1130	8 \| 8 \| eight \| 5 \| -5 \| 2 \| 4
1131	8 \| 8 \| eight \| 5 \| -5 \| 5 \| -5
1132	8 \| 8 \| eight \| 5 \| -5 \| 5 \| -5
1133	8 \| 8 \| eight \| 5 \| -5 \| 0 \|
1134	8 \| 8 \| eight \| 5 \| -5 \| \|
1135	8 \| 8 \| eight \| 5 \| -5 \| \| 0
1136	0 \| \| zero \| 5 \| -5 \| 1 \| -1
1137	0 \| \| zero \| 5 \| -5 \| 2 \| 2
1138	0 \| \| zero \| 5 \| -5 \| 3 \| -3
1139	0 \| \| zero \| 5 \| -5 \| 2 \| 4
1140	0 \| \| zero \| 5 \| -5 \| 5 \| -5
1141	0 \| \| zero \| 5 \| -5 \| 5 \| -5
1142	0 \| \| zero \| 5 \| -5 \| 0 \|
1143	0 \| \| zero \| 5 \| -5 \| \|
1144	0 \| \| zero \| 5 \| -5 \| \| 0
1145	\| \| null \| 5 \| -5 \| 1 \| -1
1146	\| \| null \| 5 \| -5 \| 2 \| 2
1147	\| \| null \| 5 \| -5 \| 3 \| -3
1148	\| \| null \| 5 \| -5 \| 2 \| 4
1149	\| \| null \| 5 \| -5 \| 5 \| -5
1150	\| \| null \| 5 \| -5 \| 5 \| -5
1151	\| \| null \| 5 \| -5 \| 0 \|
1152	\| \| null \| 5 \| -5 \| \|
1153	\| \| null \| 5 \| -5 \| \| 0
1154	\| 0 \| zero \| 5 \| -5 \| 1 \| -1
1155	\| 0 \| zero \| 5 \| -5 \| 2 \| 2
1156	\| 0 \| zero \| 5 \| -5 \| 3 \| -3
1157	\| 0 \| zero \| 5 \| -5 \| 2 \| 4
1158	\| 0 \| zero \| 5 \| -5 \| 5 \| -5
1159	\| 0 \| zero \| 5 \| -5 \| 5 \| -5
1160	\| 0 \| zero \| 5 \| -5 \| 0 \|
1161	\| 0 \| zero \| 5 \| -5 \| \|
1162	\| 0 \| zero \| 5 \| -5 \| \| 0
1163	1 \| 4 \| one \| 5 \| -5 \| 1 \| -1
1164	1 \| 4 \| one \| 5 \| -5 \| 2 \| 2
1165	1 \| 4 \| one \| 5 \| -5 \| 3 \| -3
1166	1 \| 4 \| one \| 5 \| -5 \| 2 \| 4
1167	1 \| 4 \| one \| 5 \| -5 \| 5 \| -5
1168	1 \| 4 \| one \| 5 \| -5 \| 5 \| -5
1169	1 \| 4 \| one \| 5 \| -5 \| 0 \|
1170	1 \| 4 \| one \| 5 \| -5 \| \|
1171	1 \| 4 \| one \| 5 \| -5 \| \| 0
1172	2 \| 3 \| two \| 5 \| -5 \| 1 \| -1
1173	2 \| 3 \| two \| 5 \| -5 \| 2 \| 2
1174	2 \| 3 \| two \| 5 \| -5 \| 3 \| -3
1175	2 \| 3 \| two \| 5 \| -5 \| 2 \| 4
1176	2 \| 3 \| two \| 5 \| -5 \| 5 \| -5
1177	2 \| 3 \| two \| 5 \| -5 \| 5 \| -5
1178	2 \| 3 \| two \| 5 \| -5 \| 0 \|
1179	2 \| 3 \| two \| 5 \| -5 \| \|
1180	2 \| 3 \| two \| 5 \| -5 \| \| 0
1181	3 \| 2 \| three \| 5 \| -5 \| 1 \| -1
1182	3 \| 2 \| three \| 5 \| -5 \| 2 \| 2
1183	3 \| 2 \| three \| 5 \| -5 \| 3 \| -3
1184	3 \| 2 \| three \| 5 \| -5 \| 2 \| 4
1185	3 \| 2 \| three \| 5 \| -5 \| 5 \| -5
1186	3 \| 2 \| three \| 5 \| -5 \| 5 \| -5
1187	3 \| 2 \| three \| 5 \| -5 \| 0 \|
1188	3 \| 2 \| three \| 5 \| -5 \| \|
1189	3 \| 2 \| three \| 5 \| -5 \| \| 0
1190	4 \| 1 \| four \| 5 \| -5 \| 1 \| -1
1191	4 \| 1 \| four \| 5 \| -5 \| 2 \| 2
1192	4 \| 1 \| four \| 5 \| -5 \| 3 \| -3
1193	4 \| 1 \| four \| 5 \| -5 \| 2 \| 4
1194	4 \| 1 \| four \| 5 \| -5 \| 5 \| -5
1195	4 \| 1 \| four \| 5 \| -5 \| 5 \| -5
1196	4 \| 1 \| four \| 5 \| -5 \| 0 \|
1197	4 \| 1 \| four \| 5 \| -5 \| \|
1198	4 \| 1 \| four \| 5 \| -5 \| \| 0
1199	5 \| 0 \| five \| 5 \| -5 \| 1 \| -1
1200	5 \| 0 \| five \| 5 \| -5 \| 2 \| 2
1201	5 \| 0 \| five \| 5 \| -5 \| 3 \| -3
1202	5 \| 0 \| five \| 5 \| -5 \| 2 \| 4
1203	5 \| 0 \| five \| 5 \| -5 \| 5 \| -5
1204	5 \| 0 \| five \| 5 \| -5 \| 5 \| -5
1205	5 \| 0 \| five \| 5 \| -5 \| 0 \|
1206	5 \| 0 \| five \| 5 \| -5 \| \|
1207	5 \| 0 \| five \| 5 \| -5 \| \| 0
1208	6 \| 6 \| six \| 5 \| -5 \| 1 \| -1
1209	6 \| 6 \| six \| 5 \| -5 \| 2 \| 2
1210	6 \| 6 \| six \| 5 \| -5 \| 3 \| -3
1211	6 \| 6 \| six \| 5 \| -5 \| 2 \| 4
1212	6 \| 6 \| six \| 5 \| -5 \| 5 \| -5
1213	6 \| 6 \| six \| 5 \| -5 \| 5 \| -5
1214	6 \| 6 \| six \| 5 \| -5 \| 0 \|
1215	6 \| 6 \| six \| 5 \| -5 \| \|
1216	6 \| 6 \| six \| 5 \| -5 \| \| 0
1217	7 \| 7 \| seven \| 5 \| -5 \| 1 \| -1
1218	7 \| 7 \| seven \| 5 \| -5 \| 2 \| 2
1219	7 \| 7 \| seven \| 5 \| -5 \| 3 \| -3
1220	7 \| 7 \| seven \| 5 \| -5 \| 2 \| 4
1221	7 \| 7 \| seven \| 5 \| -5 \| 5 \| -5
1222	7 \| 7 \| seven \| 5 \| -5 \| 5 \| -5
1223	7 \| 7 \| seven \| 5 \| -5 \| 0 \|
1224	7 \| 7 \| seven \| 5 \| -5 \| \|
1225	7 \| 7 \| seven \| 5 \| -5 \| \| 0
1226	8 \| 8 \| eight \| 5 \| -5 \| 1 \| -1
1227	8 \| 8 \| eight \| 5 \| -5 \| 2 \| 2
1228	8 \| 8 \| eight \| 5 \| -5 \| 3 \| -3
1229	8 \| 8 \| eight \| 5 \| -5 \| 2 \| 4
1230	8 \| 8 \| eight \| 5 \| -5 \| 5 \| -5
1231	8 \| 8 \| eight \| 5 \| -5 \| 5 \| -5
1232	8 \| 8 \| eight \| 5 \| -5 \| 0 \|
1233	8 \| 8 \| eight \| 5 \| -5 \| \|
1234	8 \| 8 \| eight \| 5 \| -5 \| \| 0
1235	0 \| \| zero \| 5 \| -5 \| 1 \| -1
1236	0 \| \| zero \| 5 \| -5 \| 2 \| 2
1237	0 \| \| zero \| 5 \| -5 \| 3 \| -3
1238	0 \| \| zero \| 5 \| -5 \| 2 \| 4
1239	0 \| \| zero \| 5 \| -5 \| 5 \| -5
1240	0 \| \| zero \| 5 \| -5 \| 5 \| -5
1241	0 \| \| zero \| 5 \| -5 \| 0 \|
1242	0 \| \| zero \| 5 \| -5 \| \|
1243	0 \| \| zero \| 5 \| -5 \| \| 0
1244	\| \| null \| 5 \| -5 \| 1 \| -1
1245	\| \| null \| 5 \| -5 \| 2 \| 2
1246	\| \| null \| 5 \| -5 \| 3 \| -3
1247	\| \| null \| 5 \| -5 \| 2 \| 4
1248	\| \| null \| 5 \| -5 \| 5 \| -5
1249	\| \| null \| 5 \| -5 \| 5 \| -5
1250	\| \| null \| 5 \| -5 \| 0 \|
1251	\| \| null \| 5 \| -5 \| \|
1252	\| \| null \| 5 \| -5 \| \| 0
1253	\| 0 \| zero \| 5 \| -5 \| 1 \| -1
1254	\| 0 \| zero \| 5 \| -5 \| 2 \| 2
1255	\| 0 \| zero \| 5 \| -5 \| 3 \| -3
1256	\| 0 \| zero \| 5 \| -5 \| 2 \| 4
1257	\| 0 \| zero \| 5 \| -5 \| 5 \| -5
1258	\| 0 \| zero \| 5 \| -5 \| 5 \| -5
1259	\| 0 \| zero \| 5 \| -5 \| 0 \|
1260	\| 0 \| zero \| 5 \| -5 \| \|
1261	\| 0 \| zero \| 5 \| -5 \| \| 0
1262	1 \| 4 \| one \| 0 \| \| 1 \| -1
1263	1 \| 4 \| one \| 0 \| \| 2 \| 2
1264	1 \| 4 \| one \| 0 \| \| 3 \| -3
1265	1 \| 4 \| one \| 0 \| \| 2 \| 4
1266	1 \| 4 \| one \| 0 \| \| 5 \| -5
1267	1 \| 4 \| one \| 0 \| \| 5 \| -5
1268	1 \| 4 \| one \| 0 \| \| 0 \|
1269	1 \| 4 \| one \| 0 \| \| \|
1270	1 \| 4 \| one \| 0 \| \| \| 0
1271	2 \| 3 \| two \| 0 \| \| 1 \| -1
1272	2 \| 3 \| two \| 0 \| \| 2 \| 2
1273	2 \| 3 \| two \| 0 \| \| 3 \| -3
1274	2 \| 3 \| two \| 0 \| \| 2 \| 4
1275	2 \| 3 \| two \| 0 \| \| 5 \| -5
1276	2 \| 3 \| two \| 0 \| \| 5 \| -5
1277	2 \| 3 \| two \| 0 \| \| 0 \|
1278	2 \| 3 \| two \| 0 \| \| \|
1279	2 \| 3 \| two \| 0 \| \| \| 0
1280	3 \| 2 \| three \| 0 \| \| 1 \| -1
1281	3 \| 2 \| three \| 0 \| \| 2 \| 2
1282	3 \| 2 \| three \| 0 \| \| 3 \| -3
1283	3 \| 2 \| three \| 0 \| \| 2 \| 4
1284	3 \| 2 \| three \| 0 \| \| 5 \| -5
1285	3 \| 2 \| three \| 0 \| \| 5 \| -5
1286	3 \| 2 \| three \| 0 \| \| 0 \|
1287	3 \| 2 \| three \| 0 \| \| \|
1288	3 \| 2 \| three \| 0 \| \| \| 0
1289	4 \| 1 \| four \| 0 \| \| 1 \| -1
1290	4 \| 1 \| four \| 0 \| \| 2 \| 2
1291	4 \| 1 \| four \| 0 \| \| 3 \| -3
1292	4 \| 1 \| four \| 0 \| \| 2 \| 4
1293	4 \| 1 \| four \| 0 \| \| 5 \| -5
1294	4 \| 1 \| four \| 0 \| \| 5 \| -5
1295	4 \| 1 \| four \| 0 \| \| 0 \|
1296	4 \| 1 \| four \| 0 \| \| \|
1297	4 \| 1 \| four \| 0 \| \| \| 0
1298	5 \| 0 \| five \| 0 \| \| 1 \| -1
1299	5 \| 0 \| five \| 0 \| \| 2 \| 2
1300	5 \| 0 \| five \| 0 \| \| 3 \| -3
1301	5 \| 0 \| five \| 0 \| \| 2 \| 4
1302	5 \| 0 \| five \| 0 \| \| 5 \| -5
1303	5 \| 0 \| five \| 0 \| \| 5 \| -5
1304	5 \| 0 \| five \| 0 \| \| 0 \|
1305	5 \| 0 \| five \| 0 \| \| \|
1306	5 \| 0 \| five \| 0 \| \| \| 0
1307	6 \| 6 \| six \| 0 \| \| 1 \| -1
1308	6 \| 6 \| six \| 0 \| \| 2 \| 2
1309	6 \| 6 \| six \| 0 \| \| 3 \| -3
1310	6 \| 6 \| six \| 0 \| \| 2 \| 4
1311	6 \| 6 \| six \| 0 \| \| 5 \| -5
1312	6 \| 6 \| six \| 0 \| \| 5 \| -5
1313	6 \| 6 \| six \| 0 \| \| 0 \|
1314	6 \| 6 \| six \| 0 \| \| \|
1315	6 \| 6 \| six \| 0 \| \| \| 0
1316	7 \| 7 \| seven \| 0 \| \| 1 \| -1
1317	7 \| 7 \| seven \| 0 \| \| 2 \| 2
1318	7 \| 7 \| seven \| 0 \| \| 3 \| -3
1319	7 \| 7 \| seven \| 0 \| \| 2 \| 4
1320	7 \| 7 \| seven \| 0 \| \| 5 \| -5
1321	7 \| 7 \| seven \| 0 \| \| 5 \| -5
1322	7 \| 7 \| seven \| 0 \| \| 0 \|
1323	7 \| 7 \| seven \| 0 \| \| \|
1324	7 \| 7 \| seven \| 0 \| \| \| 0
1325	8 \| 8 \| eight \| 0 \| \| 1 \| -1
1326	8 \| 8 \| eight \| 0 \| \| 2 \| 2
1327	8 \| 8 \| eight \| 0 \| \| 3 \| -3
1328	8 \| 8 \| eight \| 0 \| \| 2 \| 4
1329	8 \| 8 \| eight \| 0 \| \| 5 \| -5
1330	8 \| 8 \| eight \| 0 \| \| 5 \| -5
1331	8 \| 8 \| eight \| 0 \| \| 0 \|
1332	8 \| 8 \| eight \| 0 \| \| \|
1333	8 \| 8 \| eight \| 0 \| \| \| 0
1334	0 \| \| zero \| 0 \| \| 1 \| -1
1335	0 \| \| zero \| 0 \| \| 2 \| 2
1336	0 \| \| zero \| 0 \| \| 3 \| -3
1337	0 \| \| zero \| 0 \| \| 2 \| 4
1338	0 \| \| zero \| 0 \| \| 5 \| -5
1339	0 \| \| zero \| 0 \| \| 5 \| -5
1340	0 \| \| zero \| 0 \| \| 0 \|
1341	0 \| \| zero \| 0 \| \| \|
1342	0 \| \| zero \| 0 \| \| \| 0
1343	\| \| null \| 0 \| \| 1 \| -1
1344	\| \| null \| 0 \| \| 2 \| 2
1345	\| \| null \| 0 \| \| 3 \| -3
1346	\| \| null \| 0 \| \| 2 \| 4
1347	\| \| null \| 0 \| \| 5 \| -5
1348	\| \| null \| 0 \| \| 5 \| -5
1349	\| \| null \| 0 \| \| 0 \|
1350	\| \| null \| 0 \| \| \|
1351	\| \| null \| 0 \| \| \| 0
1352	\| 0 \| zero \| 0 \| \| 1 \| -1
1353	\| 0 \| zero \| 0 \| \| 2 \| 2
1354	\| 0 \| zero \| 0 \| \| 3 \| -3
1355	\| 0 \| zero \| 0 \| \| 2 \| 4
1356	\| 0 \| zero \| 0 \| \| 5 \| -5
1357	\| 0 \| zero \| 0 \| \| 5 \| -5
1358	\| 0 \| zero \| 0 \| \| 0 \|
1359	\| 0 \| zero \| 0 \| \| \|
1360	\| 0 \| zero \| 0 \| \| \| 0
1361	1 \| 4 \| one \| \| \| 1 \| -1
1362	1 \| 4 \| one \| \| \| 2 \| 2
1363	1 \| 4 \| one \| \| \| 3 \| -3
1364	1 \| 4 \| one \| \| \| 2 \| 4
1365	1 \| 4 \| one \| \| \| 5 \| -5
1366	1 \| 4 \| one \| \| \| 5 \| -5
1367	1 \| 4 \| one \| \| \| 0 \|
1368	1 \| 4 \| one \| \| \| \|
1369	1 \| 4 \| one \| \| \| \| 0
1370	2 \| 3 \| two \| \| \| 1 \| -1
1371	2 \| 3 \| two \| \| \| 2 \| 2
1372	2 \| 3 \| two \| \| \| 3 \| -3
1373	2 \| 3 \| two \| \| \| 2 \| 4
1374	2 \| 3 \| two \| \| \| 5 \| -5
1375	2 \| 3 \| two \| \| \| 5 \| -5
1376	2 \| 3 \| two \| \| \| 0 \|
1377	2 \| 3 \| two \| \| \| \|
1378	2 \| 3 \| two \| \| \| \| 0
1379	3 \| 2 \| three \| \| \| 1 \| -1
1380	3 \| 2 \| three \| \| \| 2 \| 2
1381	3 \| 2 \| three \| \| \| 3 \| -3
1382	3 \| 2 \| three \| \| \| 2 \| 4
1383	3 \| 2 \| three \| \| \| 5 \| -5
1384	3 \| 2 \| three \| \| \| 5 \| -5
1385	3 \| 2 \| three \| \| \| 0 \|
1386	3 \| 2 \| three \| \| \| \|
1387	3 \| 2 \| three \| \| \| \| 0
1388	4 \| 1 \| four \| \| \| 1 \| -1
1389	4 \| 1 \| four \| \| \| 2 \| 2
1390	4 \| 1 \| four \| \| \| 3 \| -3
1391	4 \| 1 \| four \| \| \| 2 \| 4
1392	4 \| 1 \| four \| \| \| 5 \| -5
1393	4 \| 1 \| four \| \| \| 5 \| -5
1394	4 \| 1 \| four \| \| \| 0 \|
1395	4 \| 1 \| four \| \| \| \|
1396	4 \| 1 \| four \| \| \| \| 0
1397	5 \| 0 \| five \| \| \| 1 \| -1
1398	5 \| 0 \| five \| \| \| 2 \| 2
1399	5 \| 0 \| five \| \| \| 3 \| -3
1400	5 \| 0 \| five \| \| \| 2 \| 4
1401	5 \| 0 \| five \| \| \| 5 \| -5
1402	5 \| 0 \| five \| \| \| 5 \| -5
1403	5 \| 0 \| five \| \| \| 0 \|
1404	5 \| 0 \| five \| \| \| \|
1405	5 \| 0 \| five \| \| \| \| 0
1406	6 \| 6 \| six \| \| \| 1 \| -1
1407	6 \| 6 \| six \| \| \| 2 \| 2
1408	6 \| 6 \| six \| \| \| 3 \| -3
1409	6 \| 6 \| six \| \| \| 2 \| 4
1410	6 \| 6 \| six \| \| \| 5 \| -5
1411	6 \| 6 \| six \| \| \| 5 \| -5
1412	6 \| 6 \| six \| \| \| 0 \|
1413	6 \| 6 \| six \| \| \| \|
1414	6 \| 6 \| six \| \| \| \| 0
1415	7 \| 7 \| seven \| \| \| 1 \| -1
1416	7 \| 7 \| seven \| \| \| 2 \| 2
1417	7 \| 7 \| seven \| \| \| 3 \| -3
1418	7 \| 7 \| seven \| \| \| 2 \| 4
1419	7 \| 7 \| seven \| \| \| 5 \| -5
1420	7 \| 7 \| seven \| \| \| 5 \| -5
1421	7 \| 7 \| seven \| \| \| 0 \|
1422	7 \| 7 \| seven \| \| \| \|
1423	7 \| 7 \| seven \| \| \| \| 0
1424	8 \| 8 \| eight \| \| \| 1 \| -1
1425	8 \| 8 \| eight \| \| \| 2 \| 2
1426	8 \| 8 \| eight \| \| \| 3 \| -3
1427	8 \| 8 \| eight \| \| \| 2 \| 4
1428	8 \| 8 \| eight \| \| \| 5 \| -5
1429	8 \| 8 \| eight \| \| \| 5 \| -5
1430	8 \| 8 \| eight \| \| \| 0 \|
1431	8 \| 8 \| eight \| \| \| \|
1432	8 \| 8 \| eight \| \| \| \| 0
1433	0 \| \| zero \| \| \| 1 \| -1
1434	0 \| \| zero \| \| \| 2 \| 2
1435	0 \| \| zero \| \| \| 3 \| -3
1436	0 \| \| zero \| \| \| 2 \| 4
1437	0 \| \| zero \| \| \| 5 \| -5
1438	0 \| \| zero \| \| \| 5 \| -5
1439	0 \| \| zero \| \| \| 0 \|
1440	0 \| \| zero \| \| \| \|
1441	0 \| \| zero \| \| \| \| 0
1442	\| \| null \| \| \| 1 \| -1
1443	\| \| null \| \| \| 2 \| 2
1444	\| \| null \| \| \| 3 \| -3
1445	\| \| null \| \| \| 2 \| 4
1446	\| \| null \| \| \| 5 \| -5
1447	\| \| null \| \| \| 5 \| -5
1448	\| \| null \| \| \| 0 \|
1449	\| \| null \| \| \| \|
1450	\| \| null \| \| \| \| 0
1451	\| 0 \| zero \| \| \| 1 \| -1
1452	\| 0 \| zero \| \| \| 2 \| 2
1453	\| 0 \| zero \| \| \| 3 \| -3
1454	\| 0 \| zero \| \| \| 2 \| 4
1455	\| 0 \| zero \| \| \| 5 \| -5
1456	\| 0 \| zero \| \| \| 5 \| -5
1457	\| 0 \| zero \| \| \| 0 \|
1458	\| 0 \| zero \| \| \| \|
1459	\| 0 \| zero \| \| \| \| 0
1460	1 \| 4 \| one \| \| 0 \| 1 \| -1
1461	1 \| 4 \| one \| \| 0 \| 2 \| 2
1462	1 \| 4 \| one \| \| 0 \| 3 \| -3
1463	1 \| 4 \| one \| \| 0 \| 2 \| 4
1464	1 \| 4 \| one \| \| 0 \| 5 \| -5
1465	1 \| 4 \| one \| \| 0 \| 5 \| -5
1466	1 \| 4 \| one \| \| 0 \| 0 \|
1467	1 \| 4 \| one \| \| 0 \| \|
1468	1 \| 4 \| one \| \| 0 \| \| 0
1469	2 \| 3 \| two \| \| 0 \| 1 \| -1
1470	2 \| 3 \| two \| \| 0 \| 2 \| 2
1471	2 \| 3 \| two \| \| 0 \| 3 \| -3
1472	2 \| 3 \| two \| \| 0 \| 2 \| 4
1473	2 \| 3 \| two \| \| 0 \| 5 \| -5
1474	2 \| 3 \| two \| \| 0 \| 5 \| -5
1475	2 \| 3 \| two \| \| 0 \| 0 \|
1476	2 \| 3 \| two \| \| 0 \| \|
1477	2 \| 3 \| two \| \| 0 \| \| 0
1478	3 \| 2 \| three \| \| 0 \| 1 \| -1
1479	3 \| 2 \| three \| \| 0 \| 2 \| 2
1480	3 \| 2 \| three \| \| 0 \| 3 \| -3
1481	3 \| 2 \| three \| \| 0 \| 2 \| 4
1482	3 \| 2 \| three \| \| 0 \| 5 \| -5
1483	3 \| 2 \| three \| \| 0 \| 5 \| -5
1484	3 \| 2 \| three \| \| 0 \| 0 \|
1485	3 \| 2 \| three \| \| 0 \| \|
1486	3 \| 2 \| three \| \| 0 \| \| 0
1487	4 \| 1 \| four \| \| 0 \| 1 \| -1
1488	4 \| 1 \| four \| \| 0 \| 2 \| 2
1489	4 \| 1 \| four \| \| 0 \| 3 \| -3
1490	4 \| 1 \| four \| \| 0 \| 2 \| 4
1491	4 \| 1 \| four \| \| 0 \| 5 \| -5
1492	4 \| 1 \| four \| \| 0 \| 5 \| -5
1493	4 \| 1 \| four \| \| 0 \| 0 \|
1494	4 \| 1 \| four \| \| 0 \| \|
1495	4 \| 1 \| four \| \| 0 \| \| 0
1496	5 \| 0 \| five \| \| 0 \| 1 \| -1
1497	5 \| 0 \| five \| \| 0 \| 2 \| 2
1498	5 \| 0 \| five \| \| 0 \| 3 \| -3
1499	5 \| 0 \| five \| \| 0 \| 2 \| 4
1500	5 \| 0 \| five \| \| 0 \| 5 \| -5
1501	5 \| 0 \| five \| \| 0 \| 5 \| -5
1502	5 \| 0 \| five \| \| 0 \| 0 \|
1503	5 \| 0 \| five \| \| 0 \| \|
1504	5 \| 0 \| five \| \| 0 \| \| 0
1505	6 \| 6 \| six \| \| 0 \| 1 \| -1
1506	6 \| 6 \| six \| \| 0 \| 2 \| 2
1507	6 \| 6 \| six \| \| 0 \| 3 \| -3
1508	6 \| 6 \| six \| \| 0 \| 2 \| 4
1509	6 \| 6 \| six \| \| 0 \| 5 \| -5
1510	6 \| 6 \| six \| \| 0 \| 5 \| -5
1511	6 \| 6 \| six \| \| 0 \| 0 \|
1512	6 \| 6 \| six \| \| 0 \| \|
1513	6 \| 6 \| six \| \| 0 \| \| 0
1514	7 \| 7 \| seven \| \| 0 \| 1 \| -1
1515	7 \| 7 \| seven \| \| 0 \| 2 \| 2
1516	7 \| 7 \| seven \| \| 0 \| 3 \| -3
1517	7 \| 7 \| seven \| \| 0 \| 2 \| 4
1518	7 \| 7 \| seven \| \| 0 \| 5 \| -5
1519	7 \| 7 \| seven \| \| 0 \| 5 \| -5
1520	7 \| 7 \| seven \| \| 0 \| 0 \|
1521	7 \| 7 \| seven \| \| 0 \| \|
1522	7 \| 7 \| seven \| \| 0 \| \| 0
1523	8 \| 8 \| eight \| \| 0 \| 1 \| -1
1524	8 \| 8 \| eight \| \| 0 \| 2 \| 2
1525	8 \| 8 \| eight \| \| 0 \| 3 \| -3
1526	8 \| 8 \| eight \| \| 0 \| 2 \| 4
1527	8 \| 8 \| eight \| \| 0 \| 5 \| -5
1528	8 \| 8 \| eight \| \| 0 \| 5 \| -5
1529	8 \| 8 \| eight \| \| 0 \| 0 \|
1530	8 \| 8 \| eight \| \| 0 \| \|
1531	8 \| 8 \| eight \| \| 0 \| \| 0
1532	0 \| \| zero \| \| 0 \| 1 \| -1
1533	0 \| \| zero \| \| 0 \| 2 \| 2
1534	0 \| \| zero \| \| 0 \| 3 \| -3
1535	0 \| \| zero \| \| 0 \| 2 \| 4
1536	0 \| \| zero \| \| 0 \| 5 \| -5
1537	0 \| \| zero \| \| 0 \| 5 \| -5
1538	0 \| \| zero \| \| 0 \| 0 \|
1539	0 \| \| zero \| \| 0 \| \|
1540	0 \| \| zero \| \| 0 \| \| 0
1541	\| \| null \| \| 0 \| 1 \| -1
1542	\| \| null \| \| 0 \| 2 \| 2
1543	\| \| null \| \| 0 \| 3 \| -3
1544	\| \| null \| \| 0 \| 2 \| 4
1545	\| \| null \| \| 0 \| 5 \| -5
1546	\| \| null \| \| 0 \| 5 \| -5
1547	\| \| null \| \| 0 \| 0 \|
1548	\| \| null \| \| 0 \| \|
1549	\| \| null \| \| 0 \| \| 0
1550	\| 0 \| zero \| \| 0 \| 1 \| -1
1551	\| 0 \| zero \| \| 0 \| 2 \| 2
1552	\| 0 \| zero \| \| 0 \| 3 \| -3
1553	\| 0 \| zero \| \| 0 \| 2 \| 4
1554	\| 0 \| zero \| \| 0 \| 5 \| -5
1555	\| 0 \| zero \| \| 0 \| 5 \| -5
1556	\| 0 \| zero \| \| 0 \| 0 \|
1557	\| 0 \| zero \| \| 0 \| \|
1558	\| 0 \| zero \| \| 0 \| \| 0
1559	(891 rows)
1560
1561	--	667	--
1562	--	668	--
1563	-- Inner joins (equi-joins)	669	-- Inner joins (equi-joins)

Lines 2656-2713 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/aggregates.out (-52 / +1 lines)
2656	group by unique1	2656	group by unique1
2657	having sum(fivethous) > 4975	2657	having sum(fivethous) > 4975
2658	order by sum(twothousand);	2658	order by sum(twothousand);
2659	unique1 \| count \| sum	2659	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
2660	---------+-------+------
2661	4976 \| 1 \| 976
2662	4977 \| 1 \| 977
2663	4978 \| 1 \| 978
2664	4979 \| 1 \| 979
2665	4980 \| 1 \| 980
2666	4981 \| 1 \| 981
2667	4982 \| 1 \| 982
2668	4983 \| 1 \| 983
2669	4984 \| 1 \| 984
2670	4985 \| 1 \| 985
2671	4986 \| 1 \| 986
2672	4987 \| 1 \| 987
2673	4988 \| 1 \| 988
2674	4989 \| 1 \| 989
2675	4990 \| 1 \| 990
2676	4991 \| 1 \| 991
2677	4992 \| 1 \| 992
2678	4993 \| 1 \| 993
2679	4994 \| 1 \| 994
2680	4995 \| 1 \| 995
2681	4996 \| 1 \| 996
2682	4997 \| 1 \| 997
2683	4998 \| 1 \| 998
2684	4999 \| 1 \| 999
2685	9976 \| 1 \| 1976
2686	9977 \| 1 \| 1977
2687	9978 \| 1 \| 1978
2688	9979 \| 1 \| 1979
2689	9980 \| 1 \| 1980
2690	9981 \| 1 \| 1981
2691	9982 \| 1 \| 1982
2692	9983 \| 1 \| 1983
2693	9984 \| 1 \| 1984
2694	9985 \| 1 \| 1985
2695	9986 \| 1 \| 1986
2696	9987 \| 1 \| 1987
2697	9988 \| 1 \| 1988
2698	9989 \| 1 \| 1989
2699	9990 \| 1 \| 1990
2700	9991 \| 1 \| 1991
2701	9992 \| 1 \| 1992
2702	9993 \| 1 \| 1993
2703	9994 \| 1 \| 1994
2704	9995 \| 1 \| 1995
2705	9996 \| 1 \| 1996
2706	9997 \| 1 \| 1997
2707	9998 \| 1 \| 1998
2708	9999 \| 1 \| 1999
2709	(48 rows)
2710
2711	set work_mem to default;	2660	set work_mem to default;
2712	set enable_sort to default;	2661	set enable_sort to default;
2713	--	2662	--





explain (costs off)
select proname from pg_proc where proname ilike 'ri%foo' order by 1;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
-----------------------------------------------------------------
 Index Only Scan using pg_proc_proname_args_nsp_index on pg_proc
   Filter: (proname ~~* 'ri%foo'::text)
(2 rows)

reset enable_seqscan;
reset enable_indexscan;
reset enable_bitmapscan;




CREATE VIEW upview AS SELECT * FROM range_parted WHERE (select c > c1 FROM mintab) WITH CHECK OPTION;
-- ok
UPDATE upview set c = 199 WHERE b = 4;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
-- fail, check option violation
UPDATE upview set c = 120 WHERE b = 4;
ERROR:  new row violates check option for view "upview"

DETAIL:  Failing row contains (b, 15, 120, 1, 1).
-- ok, row movement, check option passes
UPDATE upview set a = 'b', b = 15 WHERE b = 4;
ERROR:  no partition of relation "part_b_10_b_20" found for row
DETAIL:  Partition key of the failing row contains (c) = (200).
:show_data;
   partname    | a | b  |  c  | d | e 
---------------+---+----+-----+---+---
 part_a_1_a_10 | a |  1 |   1 | 1 | 1
 part_a_1_a_10 | a |  4 | 200 | 1 | 1
 part_b_1_b_10 | b |  7 | 117 | 2 | 2
 part_b_1_b_10 | b |  9 | 125 | 6 | 6
 part_d_1_15   | b | 11 | 125 | 9 | 9
 part_d_1_15   | b | 12 | 116 | 1 | 1
 part_d_1_15   | b | 15 | 199 | 1 | 1
(6 rows)

-- cleanup




  lateral explain_query_json($$select * from t_gin_test_tbl where $$ || query) js,
  lateral execute_text_query_index($$select string_agg((i, j)::text, ' ') from t_gin_test_tbl where $$ || query) res_index,
  lateral execute_text_query_heap($$select string_agg((i, j)::text, ' ') from t_gin_test_tbl where $$ || query) res_heap;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
-------------------------------------------+-----------------+--------------------+-------
  i @> '{}'                                | 7               | 0                  | t
  j @> '{}'                                | 6               | 0                  | t
  i @> '{}' and j @> '{}'                  | 4               | 0                  | t
  i @> '{1}'                               | 5               | 0                  | t
  i @> '{1}' and j @> '{}'                 | 3               | 0                  | t
  i @> '{1}' and i @> '{}' and j @> '{}'   | 3               | 0                  | t
  j @> '{10}'                              | 4               | 0                  | t
  j @> '{10}' and i @> '{}'                | 3               | 0                  | t
  j @> '{10}' and j @> '{}' and i @> '{}'  | 3               | 0                  | t
  i @> '{1}' and j @> '{10}'               | 2               | 0                  | t
(10 rows)

reset enable_seqscan;
reset enable_bitmapscan;
-- re-purpose t_gin_test_tbl to test scans involving posting trees

Lines 623-630 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/collate.out (-2 / +2 lines)
623	CREATE TABLE collate_test22 (f2 text COLLATE "POSIX");	623	CREATE TABLE collate_test22 (f2 text COLLATE "POSIX");
624	INSERT INTO collate_test22 VALUES ('foo'), ('bar'), ('baz');	624	INSERT INTO collate_test22 VALUES ('foo'), ('bar'), ('baz');
625	ALTER TABLE collate_test22 ADD FOREIGN KEY (f2) REFERENCES collate_test20; -- fail	625	ALTER TABLE collate_test22 ADD FOREIGN KEY (f2) REFERENCES collate_test20; -- fail
626	ERROR: insert or update on table "collate_test22" violates foreign key constraint "collate_test22_f2_fkey"	626	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
627	DETAIL: Key (f2)=(baz) is not present in table "collate_test20".	627	CONTEXT: SQL statement "SELECT fk."f2" FROM ONLY "collate_tests"."collate_test22" fk LEFT OUTER JOIN ONLY "collate_tests"."collate_test20" pk ON ( pk."f1" OPERATOR(pg_catalog.=) fk."f2" COLLATE "pg_catalog"."C") WHERE pk."f1" IS NULL AND (fk."f2" IS NOT NULL)"
628	DELETE FROM collate_test22 WHERE f2 = 'baz';	628	DELETE FROM collate_test22 WHERE f2 = 'baz';
629	ALTER TABLE collate_test22 ADD FOREIGN KEY (f2) REFERENCES collate_test20;	629	ALTER TABLE collate_test22 ADD FOREIGN KEY (f2) REFERENCES collate_test20;
630	RESET enable_seqscan;	630	RESET enable_seqscan;

Lines 305-315 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/groupingsets.out (-5 / +1 lines)
305	-- empty input with joins tests some important code paths	305	-- empty input with joins tests some important code paths
306	select t1.a, t2.b, sum(t1.v), count(*) from gstest_empty t1, gstest_empty t2	306	select t1.a, t2.b, sum(t1.v), count(*) from gstest_empty t1, gstest_empty t2
307	group by grouping sets ((t1.a,t2.b),());	307	group by grouping sets ((t1.a,t2.b),());
308	a \| b \| sum \| count	308	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
309	---+---+-----+-------
310	\| \| \| 0
311	(1 row)
312
313	-- simple joins, var resolution, GROUPING on join vars	309	-- simple joins, var resolution, GROUPING on join vars
314	select t1.a, t2.b, grouping(t1.a, t2.b), sum(t1.v), max(t2.a)	310	select t1.a, t2.b, grouping(t1.a, t2.b), sum(t1.v), max(t2.a)
315	from gstest1 t1, gstest2 t2	311	from gstest1 t1, gstest2 t2




  select count(*) from join_foo
    left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
    on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
------------------------------------------------------------------------------------
 Aggregate
   ->  Nested Loop Left Join
         Join Filter: ((join_foo.id < (b1.id + 1)) AND (join_foo.id > (b1.id - 1)))
         ->  Seq Scan on join_foo
         ->  Gather
               Workers Planned: 2
               ->  Hash Join
                     Hash Cond: (b1.id = b2.id)
                     ->  Parallel Seq Scan on join_bar b1
                     ->  Hash
                           ->  Seq Scan on join_bar b2
(11 rows)

select count(*) from join_foo
  left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
  on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
     3
(1 row)

select final > 1 as multibatch
  from hash_join_batches(
$$

    left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
    on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
$$);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------
 t
(1 row)

rollback to settings;
-- single-batch with rescan, parallel-oblivious
savepoint settings;

select count(*) from join_foo
  left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
  on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
CONTEXT:  parallel worker
     3
(1 row)

select final > 1 as multibatch
  from hash_join_batches(
$$

    left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
    on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
$$);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------
 f
(1 row)

rollback to settings;
-- multi-batch with rescan, parallel-aware
savepoint settings;

select count(*) from join_foo
  left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
  on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
CONTEXT:  parallel worker
     3
(1 row)

select final > 1 as multibatch
  from hash_join_batches(
$$

    left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
    on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
$$);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------
 t
(1 row)

rollback to settings;
-- single-batch with rescan, parallel-aware
savepoint settings;

select count(*) from join_foo
  left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
  on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
CONTEXT:  parallel worker
     3
(1 row)

select final > 1 as multibatch
  from hash_join_batches(
$$

    left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
    on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
$$);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------
 f
(1 row)

rollback to settings;
-- A full outer join where every record is matched.
-- non-parallel




--
SELECT DISTINCT hobbies_r.name, name(hobbies_r.equipment) FROM hobbies_r
  ORDER BY 1,2;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
-------------+---------------
 basketball  | hightops
 posthacking | advil
 posthacking | peet's coffee
 skywalking  | guts
(4 rows)

SELECT hobbies_r.name, (hobbies_r.equipment).name FROM hobbies_r;
    name     |     name      
-------------+---------------

Lines 35-40 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/tidrangescan.out (-7 / +374 lines)
35	-- page sizes.	35	-- page sizes.
36	DELETE FROM tidrangescan	36	DELETE FROM tidrangescan
37	WHERE substring(ctid::text FROM ',(\d+)\)')::integer > 10 OR substring(ctid::text FROM '\((\d+),')::integer > 2;	37	WHERE substring(ctid::text FROM ',(\d+)\)')::integer > 10 OR substring(ctid::text FROM '\((\d+),')::integer > 2;
		38	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
38	VACUUM tidrangescan;	39	VACUUM tidrangescan;
39	-- range scans with upper bound	40	-- range scans with upper bound
40	EXPLAIN (COSTS OFF)	41	EXPLAIN (COSTS OFF)
Lines 58-64 Link Here
58	(0,8)	59	(0,8)
59	(0,9)	60	(0,9)
60	(0,10)	61	(0,10)
61	(10 rows)	62	(0,11)
		63	(0,12)
		64	(0,13)
		65	(0,14)
		66	(0,15)
		67	(0,16)
		68	(0,17)
		69	(0,18)
		70	(0,19)
		71	(0,20)
		72	(0,21)
		73	(0,22)
		74	(0,23)
		75	(0,24)
		76	(0,25)
		77	(0,26)
		78	(0,27)
		79	(0,28)
		80	(0,29)
		81	(0,30)
		82	(0,31)
		83	(0,32)
		84	(0,33)
		85	(0,34)
		86	(0,35)
		87	(0,36)
		88	(0,37)
		89	(0,38)
		90	(0,39)
		91	(0,40)
		92	(0,41)
		93	(0,42)
		94	(0,43)
		95	(0,44)
		96	(0,45)
		97	(0,46)
		98	(0,47)
		99	(0,48)
		100	(0,49)
		101	(0,50)
		102	(0,51)
		103	(0,52)
		104	(0,53)
		105	(0,54)
		106	(0,55)
		107	(0,56)
		108	(0,57)
		109	(0,58)
		110	(58 rows)
62		111
63	EXPLAIN (COSTS OFF)	112	EXPLAIN (COSTS OFF)
64	SELECT ctid FROM tidrangescan WHERE ctid <= '(1,5)';	113	SELECT ctid FROM tidrangescan WHERE ctid <= '(1,5)';
Lines 81-92 Link Here
81	(0,8)	130	(0,8)
82	(0,9)	131	(0,9)
83	(0,10)	132	(0,10)
		133	(0,11)
		134	(0,12)
		135	(0,13)
		136	(0,14)
		137	(0,15)
		138	(0,16)
		139	(0,17)
		140	(0,18)
		141	(0,19)
		142	(0,20)
		143	(0,21)
		144	(0,22)
		145	(0,23)
		146	(0,24)
		147	(0,25)
		148	(0,26)
		149	(0,27)
		150	(0,28)
		151	(0,29)
		152	(0,30)
		153	(0,31)
		154	(0,32)
		155	(0,33)
		156	(0,34)
		157	(0,35)
		158	(0,36)
		159	(0,37)
		160	(0,38)
		161	(0,39)
		162	(0,40)
		163	(0,41)
		164	(0,42)
		165	(0,43)
		166	(0,44)
		167	(0,45)
		168	(0,46)
		169	(0,47)
		170	(0,48)
		171	(0,49)
		172	(0,50)
		173	(0,51)
		174	(0,52)
		175	(0,53)
		176	(0,54)
		177	(0,55)
		178	(0,56)
		179	(0,57)
		180	(0,58)
84	(1,1)	181	(1,1)
85	(1,2)	182	(1,2)
86	(1,3)	183	(1,3)
87	(1,4)	184	(1,4)
88	(1,5)	185	(1,5)
89	(15 rows)	186	(63 rows)
90		187
91	EXPLAIN (COSTS OFF)	188	EXPLAIN (COSTS OFF)
92	SELECT ctid FROM tidrangescan WHERE ctid < '(0,0)';	189	SELECT ctid FROM tidrangescan WHERE ctid < '(0,0)';
Lines 115-121 Link Here
115	--------	212	--------
116	(2,9)	213	(2,9)
117	(2,10)	214	(2,10)
118	(2 rows)	215	(2,11)
		216	(2,12)
		217	(2,13)
		218	(2,14)
		219	(2,15)
		220	(2,16)
		221	(2,17)
		222	(2,18)
		223	(2,19)
		224	(2,20)
		225	(2,21)
		226	(2,22)
		227	(2,23)
		228	(2,24)
		229	(2,25)
		230	(2,26)
		231	(2,27)
		232	(2,28)
		233	(2,29)
		234	(2,30)
		235	(2,31)
		236	(2,32)
		237	(2,33)
		238	(2,34)
		239	(2,35)
		240	(2,36)
		241	(2,37)
		242	(2,38)
		243	(2,39)
		244	(2,40)
		245	(2,41)
		246	(2,42)
		247	(2,43)
		248	(2,44)
		249	(2,45)
		250	(2,46)
		251	(2,47)
		252	(2,48)
		253	(2,49)
		254	(2,50)
		255	(2,51)
		256	(2,52)
		257	(2,53)
		258	(2,54)
		259	(2,55)
		260	(2,56)
		261	(2,57)
		262	(2,58)
		263	(3,1)
		264	(3,2)
		265	(3,3)
		266	(3,4)
		267	(3,5)
		268	(3,6)
		269	(3,7)
		270	(3,8)
		271	(3,9)
		272	(3,10)
		273	(3,11)
		274	(3,12)
		275	(3,13)
		276	(3,14)
		277	(3,15)
		278	(3,16)
		279	(3,17)
280	(3,18)
281	(3,19)
282	(3,20)
283	(3,21)
284	(3,22)
285	(3,23)
286	(3,24)
287	(3,25)
288	(3,26)
289	(76 rows)
119		290
120	EXPLAIN (COSTS OFF)	291	EXPLAIN (COSTS OFF)
121	SELECT ctid FROM tidrangescan WHERE '(2,8)' < ctid;	292	SELECT ctid FROM tidrangescan WHERE '(2,8)' < ctid;
Lines 130-136 Link Here
130	--------	301	--------
131	(2,9)	302	(2,9)
132	(2,10)	303	(2,10)
133	(2 rows)	304	(2,11)
		305	(2,12)
		306	(2,13)
		307	(2,14)
		308	(2,15)
		309	(2,16)
		310	(2,17)
		311	(2,18)
		312	(2,19)
		313	(2,20)
		314	(2,21)
		315	(2,22)
		316	(2,23)
		317	(2,24)
		318	(2,25)
		319	(2,26)
		320	(2,27)
		321	(2,28)
		322	(2,29)
		323	(2,30)
		324	(2,31)
		325	(2,32)
		326	(2,33)
		327	(2,34)
		328	(2,35)
		329	(2,36)
		330	(2,37)
		331	(2,38)
		332	(2,39)
		333	(2,40)
		334	(2,41)
		335	(2,42)
		336	(2,43)
		337	(2,44)
		338	(2,45)
		339	(2,46)
		340	(2,47)
		341	(2,48)
		342	(2,49)
		343	(2,50)
		344	(2,51)
		345	(2,52)
		346	(2,53)
		347	(2,54)
		348	(2,55)
		349	(2,56)
		350	(2,57)
		351	(2,58)
		352	(3,1)
		353	(3,2)
		354	(3,3)
		355	(3,4)
		356	(3,5)
		357	(3,6)
		358	(3,7)
		359	(3,8)
		360	(3,9)
		361	(3,10)
		362	(3,11)
		363	(3,12)
		364	(3,13)
		365	(3,14)
		366	(3,15)
		367	(3,16)
		368	(3,17)
369	(3,18)
370	(3,19)
371	(3,20)
372	(3,21)
373	(3,22)
374	(3,23)
375	(3,24)
376	(3,25)
377	(3,26)
378	(76 rows)
134		379
135	EXPLAIN (COSTS OFF)	380	EXPLAIN (COSTS OFF)
136	SELECT ctid FROM tidrangescan WHERE ctid >= '(2,8)';	381	SELECT ctid FROM tidrangescan WHERE ctid >= '(2,8)';
Lines 146-152 Link Here
146	(2,8)	391	(2,8)
147	(2,9)	392	(2,9)
148	(2,10)	393	(2,10)
149	(3 rows)	394	(2,11)
		395	(2,12)
		396	(2,13)
		397	(2,14)
		398	(2,15)
		399	(2,16)
		400	(2,17)
		401	(2,18)
		402	(2,19)
		403	(2,20)
		404	(2,21)
		405	(2,22)
		406	(2,23)
		407	(2,24)
		408	(2,25)
		409	(2,26)
		410	(2,27)
		411	(2,28)
		412	(2,29)
		413	(2,30)
		414	(2,31)
		415	(2,32)
		416	(2,33)
		417	(2,34)
		418	(2,35)
		419	(2,36)
		420	(2,37)
		421	(2,38)
		422	(2,39)
		423	(2,40)
		424	(2,41)
		425	(2,42)
		426	(2,43)
		427	(2,44)
		428	(2,45)
		429	(2,46)
		430	(2,47)
		431	(2,48)
		432	(2,49)
		433	(2,50)
		434	(2,51)
		435	(2,52)
		436	(2,53)
		437	(2,54)
		438	(2,55)
		439	(2,56)
		440	(2,57)
		441	(2,58)
		442	(3,1)
		443	(3,2)
		444	(3,3)
		445	(3,4)
		446	(3,5)
		447	(3,6)
		448	(3,7)
		449	(3,8)
		450	(3,9)
		451	(3,10)
		452	(3,11)
		453	(3,12)
		454	(3,13)
		455	(3,14)
		456	(3,15)
		457	(3,16)
		458	(3,17)
459	(3,18)
460	(3,19)
461	(3,20)
462	(3,21)
463	(3,22)
464	(3,23)
465	(3,24)
466	(3,25)
467	(3,26)
468	(77 rows)
150		469
151	EXPLAIN (COSTS OFF)	470	EXPLAIN (COSTS OFF)
152	SELECT ctid FROM tidrangescan WHERE ctid >= '(100,0)';	471	SELECT ctid FROM tidrangescan WHERE ctid >= '(100,0)';
Lines 251-257 Link Here
251	(0,8) \| 8	570	(0,8) \| 8
252	(0,9) \| 9	571	(0,9) \| 9
253	(0,10) \| 10	572	(0,10) \| 10
254	(10 rows)	573	(0,11) \| 11
		574	(0,12) \| 12
		575	(0,13) \| 13
		576	(0,14) \| 14
		577	(0,15) \| 15
		578	(0,16) \| 16
		579	(0,17) \| 17
		580	(0,18) \| 18
		581	(0,19) \| 19
		582	(0,20) \| 20
		583	(0,21) \| 21
		584	(0,22) \| 22
		585	(0,23) \| 23
		586	(0,24) \| 24
		587	(0,25) \| 25
		588	(0,26) \| 26
		589	(0,27) \| 27
		590	(0,28) \| 28
		591	(0,29) \| 29
		592	(0,30) \| 30
		593	(0,31) \| 31
		594	(0,32) \| 32
		595	(0,33) \| 33
		596	(0,34) \| 34
		597	(0,35) \| 35
		598	(0,36) \| 36
		599	(0,37) \| 37
		600	(0,38) \| 38
		601	(0,39) \| 39
		602	(0,40) \| 40
		603	(0,41) \| 41
		604	(0,42) \| 42
		605	(0,43) \| 43
		606	(0,44) \| 44
		607	(0,45) \| 45
		608	(0,46) \| 46
		609	(0,47) \| 47
		610	(0,48) \| 48
		611	(0,49) \| 49
		612	(0,50) \| 50
		613	(0,51) \| 51
		614	(0,52) \| 52
		615	(0,53) \| 53
		616	(0,54) \| 54
		617	(0,55) \| 55
		618	(0,56) \| 56
		619	(0,57) \| 57
		620	(0,58) \| 58
		621	(58 rows)
255		622
256	-- cursors	623	-- cursors
257	-- Ensure we get a TID Range scan without a Materialize node.	624	-- Ensure we get a TID Range scan without a Materialize node.
Lines 292-298 Link Here
292	FETCH LAST c;	659	FETCH LAST c;
293	ctid	660	ctid
294	--------	661	--------
295	(0,10)	662	(0,58)
296	(1 row)	663	(1 row)
297		664
298	COMMIT;	665	COMMIT;




set local enable_material = off;
set local enable_sort = off;
explain (costs off) select * from t left join (select * from (select * from t order by a) v order by a, b) s on s.a = t.a where t.a in (1, 2);
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
------------------------------------------------
 Nested Loop Left Join
   Join Filter: (t_1.a = t.a)
   ->  Seq Scan on t
         Filter: (a = ANY ('{1,2}'::integer[]))
   ->  Incremental Sort
         Sort Key: t_1.a, t_1.b
         Presorted Key: t_1.a
         ->  Sort
               Sort Key: t_1.a
               ->  Seq Scan on t t_1
(10 rows)

select * from t left join (select * from (select * from t order by a) v order by a, b) s on s.a = t.a where t.a in (1, 2);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---+---+---+---
 1 | 1 | 1 | 1
 2 | 2 | 2 | 2
(2 rows)

rollback;
-- Test EXPLAIN ANALYZE with both fullsort and presorted groups.
select explain_analyze_without_memory('select * from (select * from t order by a) s order by a, b limit 70');




explain (costs off)
	select (select max((select pa1.b from part_pa_test pa1 where pa1.a = pa2.a)))
	from part_pa_test pa2;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
--------------------------------------------------------------
 Aggregate
   ->  Gather
         Workers Planned: 3
         ->  Parallel Append
               ->  Parallel Seq Scan on part_pa_test_p1 pa2_1
               ->  Parallel Seq Scan on part_pa_test_p2 pa2_2
   SubPlan 2
     ->  Result
   SubPlan 1
     ->  Append
           ->  Seq Scan on part_pa_test_p1 pa1_1
                 Filter: (a = pa2.a)
           ->  Seq Scan on part_pa_test_p2 pa1_2
                 Filter: (a = pa2.a)
(14 rows)

drop table part_pa_test;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test with leader participation disabled
set parallel_leader_participation = off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
  select count(*) from tenk1 where stringu1 = 'GRAAAA';
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---------------------------------------------------------
 Finalize Aggregate
   ->  Gather
         Workers Planned: 4
         ->  Partial Aggregate
               ->  Parallel Seq Scan on tenk1
                     Filter: (stringu1 = 'GRAAAA'::name)
(6 rows)

select count(*) from tenk1 where stringu1 = 'GRAAAA';
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
    15
(1 row)

-- test with leader participation disabled, but no workers available (so
-- the leader will have to run the plan despite the setting)
set max_parallel_workers = 0;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
  select count(*) from tenk1 where stringu1 = 'GRAAAA';
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---------------------------------------------------------
 Finalize Aggregate
   ->  Gather
         Workers Planned: 4
         ->  Partial Aggregate
               ->  Parallel Seq Scan on tenk1
                     Filter: (stringu1 = 'GRAAAA'::name)
(6 rows)

select count(*) from tenk1 where stringu1 = 'GRAAAA';
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
    15
(1 row)

reset max_parallel_workers;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset parallel_leader_participation;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test that parallel_restricted function doesn't run in worker
alter table tenk1 set (parallel_workers = 4);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (verbose, costs off)
select sp_parallel_restricted(unique1) from tenk1
  where stringu1 = 'GRAAAA' order by 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---------------------------------------------------------
 Sort
   Output: (sp_parallel_restricted(unique1))
   Sort Key: (sp_parallel_restricted(tenk1.unique1))
   ->  Gather
         Output: sp_parallel_restricted(unique1)
         Workers Planned: 4
         ->  Parallel Seq Scan on public.tenk1
               Output: unique1
               Filter: (tenk1.stringu1 = 'GRAAAA'::name)
(9 rows)

-- test parallel plan when group by expression is in target list.
explain (costs off)
	select length(stringu1) from tenk1 group by length(stringu1);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---------------------------------------------------
 Finalize HashAggregate
   Group Key: (length((stringu1)::text))
   ->  Gather
         Workers Planned: 4
         ->  Partial HashAggregate
               Group Key: length((stringu1)::text)
               ->  Parallel Seq Scan on tenk1
(7 rows)

select length(stringu1) from tenk1 group by length(stringu1);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--------
      6
(1 row)

explain (costs off)
	select stringu1, count(*) from tenk1 group by stringu1 order by stringu1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------------
 Sort
   Sort Key: stringu1
   ->  Finalize HashAggregate
         Group Key: stringu1
         ->  Gather
               Workers Planned: 4
               ->  Partial HashAggregate
                     Group Key: stringu1
                     ->  Parallel Seq Scan on tenk1
(9 rows)

-- test that parallel plan for aggregates is not selected when
-- target list contains parallel restricted clause.
explain (costs off)
	select  sum(sp_parallel_restricted(unique1)) from tenk1
	group by(sp_parallel_restricted(unique1));
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------------------------------------------------------------------
 HashAggregate
   Group Key: sp_parallel_restricted(unique1)
   ->  Gather
         Workers Planned: 4
         ->  Parallel Index Only Scan using tenk1_unique1 on tenk1
(5 rows)

-- test prepared statement
prepare tenk1_count(integer) As select  count((unique1)) from tenk1 where hundred > $1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off) execute tenk1_count(1);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------
 Finalize Aggregate
   ->  Gather
         Workers Planned: 4
         ->  Partial Aggregate
               ->  Parallel Seq Scan on tenk1
                     Filter: (hundred > 1)
(6 rows)

execute tenk1_count(1);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
  9800
(1 row)

deallocate tenk1_count;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test parallel plans for queries containing un-correlated subplans.
alter table tenk2 set (parallel_workers = 0);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
	select count(*) from tenk1 where (two, four) not in
	(select hundred, thousand from tenk2 where thousand > 100);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------------------------------------------------
 Finalize Aggregate
   ->  Gather
         Workers Planned: 4
         ->  Partial Aggregate
               ->  Parallel Seq Scan on tenk1
                     Filter: (NOT (hashed SubPlan 1))
                     SubPlan 1
                       ->  Seq Scan on tenk2
                             Filter: (thousand > 100)
(9 rows)

select count(*) from tenk1 where (two, four) not in
	(select hundred, thousand from tenk2 where thousand > 100);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
 10000
(1 row)

-- this is not parallel-safe due to use of random() within SubLink's testexpr:
explain (costs off)
	select * from tenk1 where (unique1 + random())::integer not in
	(select ten from tenk2);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------------------------------
 Seq Scan on tenk1
   Filter: (NOT (hashed SubPlan 1))
   SubPlan 1
     ->  Seq Scan on tenk2
(4 rows)

alter table tenk2 reset (parallel_workers);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test parallel plan for a query containing initplan.
set enable_indexscan = off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_indexonlyscan = off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_bitmapscan = off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
alter table tenk2 set (parallel_workers = 2);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
	select count(*) from tenk1
        where tenk1.unique1 = (Select max(tenk2.unique1) from tenk2);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------------------------------------------------
 Aggregate
   InitPlan 1 (returns $2)
     ->  Finalize Aggregate
           ->  Gather
                 Workers Planned: 2
                 ->  Partial Aggregate
                       ->  Parallel Seq Scan on tenk2
   ->  Gather
         Workers Planned: 4
         Params Evaluated: $2
         ->  Parallel Seq Scan on tenk1
               Filter: (unique1 = $2)
(12 rows)

select count(*) from tenk1
    where tenk1.unique1 = (Select max(tenk2.unique1) from tenk2);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
     1
(1 row)

reset enable_indexscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_indexonlyscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_bitmapscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
alter table tenk2 reset (parallel_workers);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test parallel index scans.
set enable_seqscan to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_bitmapscan to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
	select  count((unique1)) from tenk1 where hundred > 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--------------------------------------------------------------------
 Finalize Aggregate
   ->  Gather
         Workers Planned: 4
         ->  Partial Aggregate
               ->  Parallel Index Scan using tenk1_hundred on tenk1
                     Index Cond: (hundred > 1)
(6 rows)

select  count((unique1)) from tenk1 where hundred > 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
  9800
(1 row)

-- test parallel index-only scans.
explain (costs off)
	select  count(*) from tenk1 where thousand > 95;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--------------------------------------------------------------------------------
 Finalize Aggregate
   ->  Gather
         Workers Planned: 4
         ->  Partial Aggregate
               ->  Parallel Index Only Scan using tenk1_thous_tenthous on tenk1
                     Index Cond: (thousand > 95)
(6 rows)

select  count(*) from tenk1 where thousand > 95;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
  9040
(1 row)

-- test rescan cases too
set enable_material = false;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
select * from
  (select count(unique1) from tenk1 where hundred > 10) ss
  right join (values (1),(2),(3)) v(x) on true;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--------------------------------------------------------------------------
 Nested Loop Left Join
   ->  Values Scan on "*VALUES*"
   ->  Finalize Aggregate
         ->  Gather
               Workers Planned: 4
               ->  Partial Aggregate
                     ->  Parallel Index Scan using tenk1_hundred on tenk1
                           Index Cond: (hundred > 10)
(8 rows)

select * from
  (select count(unique1) from tenk1 where hundred > 10) ss
  right join (values (1),(2),(3)) v(x) on true;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------+---
  8900 | 1
  8900 | 2
  8900 | 3
(3 rows)

explain (costs off)
select * from
  (select count(*) from tenk1 where thousand > 99) ss
  right join (values (1),(2),(3)) v(x) on true;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--------------------------------------------------------------------------------------
 Nested Loop Left Join
   ->  Values Scan on "*VALUES*"
   ->  Finalize Aggregate
         ->  Gather
               Workers Planned: 4
               ->  Partial Aggregate
                     ->  Parallel Index Only Scan using tenk1_thous_tenthous on tenk1
                           Index Cond: (thousand > 99)
(8 rows)

select * from
  (select count(*) from tenk1 where thousand > 99) ss
  right join (values (1),(2),(3)) v(x) on true;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------+---
  9000 | 1
  9000 | 2
  9000 | 3
(3 rows)

-- test rescans for a Limit node with a parallel node beneath it.
reset enable_seqscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_indexonlyscan to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_indexscan to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
alter table tenk1 set (parallel_workers = 0);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
alter table tenk2 set (parallel_workers = 1);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
select count(*) from tenk1
  left join (select tenk2.unique1 from tenk2 order by 1 limit 1000) ss
  on tenk1.unique1 < ss.unique1 + 1
  where tenk1.unique1 < 2;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------------------------------------------------------
 Aggregate
   ->  Nested Loop Left Join
         Join Filter: (tenk1.unique1 < (tenk2.unique1 + 1))
         ->  Seq Scan on tenk1
               Filter: (unique1 < 2)
         ->  Limit
               ->  Gather Merge
                     Workers Planned: 1
                     ->  Sort
                           Sort Key: tenk2.unique1
                           ->  Parallel Seq Scan on tenk2
(11 rows)

select count(*) from tenk1
  left join (select tenk2.unique1 from tenk2 order by 1 limit 1000) ss
  on tenk1.unique1 < ss.unique1 + 1
  where tenk1.unique1 < 2;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
  1999
(1 row)

--reset the value of workers for each table as it was before this test.
alter table tenk1 set (parallel_workers = 4);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
alter table tenk2 reset (parallel_workers);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_material;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_bitmapscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_indexonlyscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_indexscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test parallel bitmap heap scan.
set enable_seqscan to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_indexscan to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_hashjoin to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_mergejoin to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_material to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test prefetching, if the platform allows it
DO $$
BEGIN
 SET effective_io_concurrency = 50;
EXCEPTION WHEN invalid_parameter_value THEN
END $$;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set work_mem='64kB';  --set small work mem to force lossy pages
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
	select count(*) from tenk1, tenk2 where tenk1.hundred > 1 and tenk2.thousand=0;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------------------------------------------------------
 Aggregate
   ->  Nested Loop
         ->  Seq Scan on tenk2
               Filter: (thousand = 0)
         ->  Gather
               Workers Planned: 4
               ->  Parallel Bitmap Heap Scan on tenk1
                     Recheck Cond: (hundred > 1)
                     ->  Bitmap Index Scan on tenk1_hundred
                           Index Cond: (hundred > 1)
(10 rows)

select count(*) from tenk1, tenk2 where tenk1.hundred > 1 and tenk2.thousand=0;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
 98000
(1 row)

create table bmscantest (a int, t text);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
insert into bmscantest select r, 'fooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo' FROM generate_series(1,100000) r;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
create index i_bmtest ON bmscantest(a);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
select count(*) from bmscantest where a>1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
 99999
(1 row)

-- test accumulation of stats for parallel nodes
reset enable_seqscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
alter table tenk2 set (parallel_workers = 0);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (analyze, timing off, summary off, costs off)
   select count(*) from tenk1, tenk2 where tenk1.hundred > 1
        and tenk2.thousand=0;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--------------------------------------------------------------------------
 Aggregate (actual rows=1 loops=1)
   ->  Nested Loop (actual rows=98000 loops=1)
         ->  Seq Scan on tenk2 (actual rows=10 loops=1)
               Filter: (thousand = 0)
               Rows Removed by Filter: 9990
         ->  Gather (actual rows=9800 loops=10)
               Workers Planned: 4
               Workers Launched: 4
               ->  Parallel Seq Scan on tenk1 (actual rows=1960 loops=50)
                     Filter: (hundred > 1)
                     Rows Removed by Filter: 40
(11 rows)

alter table tenk2 reset (parallel_workers);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset work_mem;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
create function explain_parallel_sort_stats() returns setof text
language plpgsql as
$$

    end loop;
end;
$$;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
select * from explain_parallel_sort_stats();
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--------------------------------------------------------------------------
 Nested Loop Left Join (actual rows=30000 loops=1)
   ->  Values Scan on "*VALUES*" (actual rows=3 loops=1)
   ->  Gather Merge (actual rows=10000 loops=3)
         Workers Planned: 4
         Workers Launched: 4
         ->  Sort (actual rows=2000 loops=15)
               Sort Key: tenk1.ten
               Sort Method: quicksort  Memory: xxx
               Worker 0:  Sort Method: quicksort  Memory: xxx
               Worker 1:  Sort Method: quicksort  Memory: xxx
               Worker 2:  Sort Method: quicksort  Memory: xxx
               Worker 3:  Sort Method: quicksort  Memory: xxx
               ->  Parallel Seq Scan on tenk1 (actual rows=2000 loops=15)
                     Filter: (ten < 100)
(14 rows)

reset enable_indexscan;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_hashjoin;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_mergejoin;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_material;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset effective_io_concurrency;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
drop table bmscantest;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
drop function explain_parallel_sort_stats();
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test parallel merge join path.
set enable_hashjoin to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set enable_nestloop to off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
	select  count(*) from tenk1, tenk2 where tenk1.unique1 = tenk2.unique1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------------------------------------------------------------------------------
 Finalize Aggregate
   ->  Gather
         Workers Planned: 4
         ->  Partial Aggregate
               ->  Merge Join
                     Merge Cond: (tenk1.unique1 = tenk2.unique1)
                     ->  Parallel Index Only Scan using tenk1_unique1 on tenk1
                     ->  Index Only Scan using tenk2_unique1 on tenk2
(8 rows)

select  count(*) from tenk1, tenk2 where tenk1.unique1 = tenk2.unique1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
 10000
(1 row)

reset enable_hashjoin;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_nestloop;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test gather merge
set enable_hashagg = false;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
   select count(*) from tenk1 group by twenty;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------------
 Finalize GroupAggregate
   Group Key: twenty
   ->  Gather Merge
         Workers Planned: 4
         ->  Partial GroupAggregate
               Group Key: twenty
               ->  Sort
                     Sort Key: twenty
                     ->  Parallel Seq Scan on tenk1
(9 rows)

select count(*) from tenk1 group by twenty;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
(20 rows)

--test expressions in targetlist are pushed down for gather merge
create function sp_simple_func(var1 integer) returns integer
as $$

        return var1 + 10;
end;
$$ language plpgsql PARALLEL SAFE;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off, verbose)
    select ten, sp_simple_func(ten) from tenk1 where ten < 100 order by ten;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-----------------------------------------------------
 Gather Merge
   Output: ten, (sp_simple_func(ten))
   Workers Planned: 4
   ->  Result
         Output: ten, sp_simple_func(ten)
         ->  Sort
               Output: ten
               Sort Key: tenk1.ten
               ->  Parallel Seq Scan on public.tenk1
                     Output: ten
                     Filter: (tenk1.ten < 100)
(11 rows)

drop function sp_simple_func(integer);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test handling of SRFs in targetlist (bug in 10.0)
explain (costs off)
   select count(*), generate_series(1,2) from tenk1 group by twenty;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------------------
 ProjectSet
   ->  Finalize GroupAggregate
         Group Key: twenty
         ->  Gather Merge
               Workers Planned: 4
               ->  Partial GroupAggregate
                     Group Key: twenty
                     ->  Sort
                           Sort Key: twenty
                           ->  Parallel Seq Scan on tenk1
(10 rows)

select count(*), generate_series(1,2) from tenk1 group by twenty;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------+-----------------
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
   500 |               1
   500 |               2
(40 rows)

-- test gather merge with parallel leader participation disabled
set parallel_leader_participation = off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
   select count(*) from tenk1 group by twenty;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------------
 Finalize GroupAggregate
   Group Key: twenty
   ->  Gather Merge
         Workers Planned: 4
         ->  Partial GroupAggregate
               Group Key: twenty
               ->  Sort
                     Sort Key: twenty
                     ->  Parallel Seq Scan on tenk1
(9 rows)

select count(*) from tenk1 group by twenty;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
   500
(20 rows)

reset parallel_leader_participation;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--test rescan behavior of gather merge
set enable_material = false;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
select * from
  (select string4, count(unique2)
   from tenk1 group by string4 order by string4) ss
  right join (values (1),(2),(3)) v(x) on true;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------------------
 Nested Loop Left Join
   ->  Values Scan on "*VALUES*"
   ->  Finalize GroupAggregate
         Group Key: tenk1.string4
         ->  Gather Merge
               Workers Planned: 4
               ->  Partial GroupAggregate
                     Group Key: tenk1.string4
                     ->  Sort
                           Sort Key: tenk1.string4
                           ->  Parallel Seq Scan on tenk1
(11 rows)

select * from
  (select string4, count(unique2)
   from tenk1 group by string4 order by string4) ss
  right join (values (1),(2),(3)) v(x) on true;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---------+-------+---
 AAAAxx  |  2500 | 1
 HHHHxx  |  2500 | 1
 OOOOxx  |  2500 | 1
 VVVVxx  |  2500 | 1
 AAAAxx  |  2500 | 2
 HHHHxx  |  2500 | 2
 OOOOxx  |  2500 | 2
 VVVVxx  |  2500 | 2
 AAAAxx  |  2500 | 3
 HHHHxx  |  2500 | 3
 OOOOxx  |  2500 | 3
 VVVVxx  |  2500 | 3
(12 rows)

reset enable_material;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset enable_hashagg;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- check parallelized int8 aggregate (bug #14897)
explain (costs off)
select avg(unique1::int8) from tenk1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------------------------------------------------------------------------
 Finalize Aggregate
   ->  Gather
         Workers Planned: 4
         ->  Partial Aggregate
               ->  Parallel Index Only Scan using tenk1_unique1 on tenk1
(5 rows)

select avg(unique1::int8) from tenk1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-----------------------
 4999.5000000000000000
(1 row)

-- gather merge test with a LIMIT
explain (costs off)
  select fivethous from tenk1 order by fivethous limit 4;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------
 Limit
   ->  Gather Merge
         Workers Planned: 4
         ->  Sort
               Sort Key: fivethous
               ->  Parallel Seq Scan on tenk1
(6 rows)

select fivethous from tenk1 order by fivethous limit 4;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-----------
         0
         0
         1
         1
(4 rows)

-- gather merge test with 0 worker
set max_parallel_workers = 0;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
   select string4 from tenk1 order by string4 limit 5;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------
 Limit
   ->  Gather Merge
         Workers Planned: 4
         ->  Sort
               Sort Key: string4
               ->  Parallel Seq Scan on tenk1
(6 rows)

select string4 from tenk1 order by string4 limit 5;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---------
 AAAAxx
 AAAAxx
 AAAAxx
 AAAAxx
 AAAAxx
(5 rows)

-- gather merge test with 0 workers, with parallel leader
-- participation disabled (the leader will have to run the plan
-- despite the setting)
set parallel_leader_participation = off;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
   select string4 from tenk1 order by string4 limit 5;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------
 Limit
   ->  Gather Merge
         Workers Planned: 4
         ->  Sort
               Sort Key: string4
               ->  Parallel Seq Scan on tenk1
(6 rows)

select string4 from tenk1 order by string4 limit 5;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---------
 AAAAxx
 AAAAxx
 AAAAxx
 AAAAxx
 AAAAxx
(5 rows)

reset parallel_leader_participation;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset max_parallel_workers;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
SAVEPOINT settings;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
SET LOCAL force_parallel_mode = 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
explain (costs off)
  select stringu1::int2 from tenk1 where unique1 = 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-----------------------------------------------
 Gather
   Workers Planned: 1
   Single Copy: true
   ->  Index Scan using tenk1_unique1 on tenk1
         Index Cond: (unique1 = 1)
(5 rows)

ROLLBACK TO SAVEPOINT settings;
ERROR:  savepoint "settings" does not exist
-- exercise record typmod remapping between backends
CREATE FUNCTION make_record(n int)
  RETURNS RECORD LANGUAGE plpgsql PARALLEL SAFE AS

         END;
END;
$$;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
SAVEPOINT settings;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
SET LOCAL force_parallel_mode = 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
SELECT make_record(x) FROM (SELECT generate_series(1, 5) x) ss ORDER BY x;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------------
 (1)
 (1,2)
 (1,2,3)
 (1,2,3,4)
 (1,2,3,4,5)
(5 rows)

ROLLBACK TO SAVEPOINT settings;
ERROR:  savepoint "settings" does not exist
DROP function make_record(n int);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test the sanity of parallel query after the active role is dropped.
drop role if exists regress_parallel_worker;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
create role regress_parallel_worker;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set role regress_parallel_worker;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset session authorization;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
drop role regress_parallel_worker;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
set force_parallel_mode = 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
select count(*) from tenk1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------
 10000
(1 row)

reset force_parallel_mode;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
reset role;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- Window function calculation can't be pushed to workers.
explain (costs off, verbose)
  select count(*) from tenk1 a where (unique1, two) in
    (select unique1, row_number() over() from tenk1 b);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------------------------------------------------------
 Aggregate
   Output: count(*)
   ->  Hash Semi Join
         Hash Cond: ((a.unique1 = b.unique1) AND (a.two = (row_number() OVER (?))))
         ->  Gather
               Output: a.unique1, a.two
               Workers Planned: 4
               ->  Parallel Seq Scan on public.tenk1 a
                     Output: a.unique1, a.two
         ->  Hash
               Output: b.unique1, (row_number() OVER (?))
               ->  WindowAgg
                     Output: b.unique1, row_number() OVER (?)
                     ->  Gather
                           Output: b.unique1
                           Workers Planned: 4
                           ->  Parallel Index Only Scan using tenk1_unique1 on public.tenk1 b
                                 Output: b.unique1
(18 rows)

-- LIMIT/OFFSET within sub-selects can't be pushed to workers.
explain (costs off)
  select * from tenk1 a where two in
    (select two from tenk1 b where stringu1 like '%AAAA' limit 3);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
---------------------------------------------------------------
 Hash Semi Join
   Hash Cond: (a.two = b.two)
   ->  Gather
         Workers Planned: 4
         ->  Parallel Seq Scan on tenk1 a
   ->  Hash
         ->  Limit
               ->  Gather
                     Workers Planned: 4
                     ->  Parallel Seq Scan on tenk1 b
                           Filter: (stringu1 ~~ '%AAAA'::text)
(11 rows)

-- to increase the parallel query test coverage
SAVEPOINT settings;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
SET LOCAL force_parallel_mode = 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
EXPLAIN (analyze, timing off, summary off, costs off) SELECT * FROM tenk1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------------------------------------------------------------
 Gather (actual rows=10000 loops=1)
   Workers Planned: 4
   Workers Launched: 4
   ->  Parallel Seq Scan on tenk1 (actual rows=2000 loops=5)
(4 rows)

ROLLBACK TO SAVEPOINT settings;
ERROR:  savepoint "settings" does not exist
-- provoke error in worker
-- (make the error message long enough to require multiple bufferloads)
SAVEPOINT settings;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
SET LOCAL force_parallel_mode = 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
select (stringu1 || repeat('abcd', 5000))::int2 from tenk1 where unique1 = 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
CONTEXT:  parallel worker
ROLLBACK TO SAVEPOINT settings;
ERROR:  savepoint "settings" does not exist
-- test interaction with set-returning functions
SAVEPOINT settings;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- multiple subqueries under a single Gather node
-- must set parallel_setup_cost > 0 to discourage multiple Gather nodes
SET LOCAL parallel_setup_cost = 10;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
EXPLAIN (COSTS OFF)
SELECT unique1 FROM tenk1 WHERE fivethous = tenthous + 1
UNION ALL
SELECT unique1 FROM tenk1 WHERE fivethous = tenthous + 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------------
 Gather
   Workers Planned: 4
   ->  Parallel Append
         ->  Parallel Seq Scan on tenk1
               Filter: (fivethous = (tenthous + 1))
         ->  Parallel Seq Scan on tenk1 tenk1_1
               Filter: (fivethous = (tenthous + 1))
(7 rows)

ROLLBACK TO SAVEPOINT settings;
ERROR:  savepoint "settings" does not exist
-- can't use multiple subqueries under a single Gather node due to initPlans
EXPLAIN (COSTS OFF)
SELECT unique1 FROM tenk1 WHERE fivethous =

SELECT unique1 FROM tenk1 WHERE fivethous =
	(SELECT unique2 FROM tenk1 WHERE fivethous = 1 LIMIT 1)
ORDER BY 1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
--------------------------------------------------------------------
 Sort
   Sort Key: tenk1.unique1
   ->  Append
         ->  Gather
               Workers Planned: 4
               Params Evaluated: $1
               InitPlan 1 (returns $1)
                 ->  Limit
                       ->  Gather
                             Workers Planned: 4
                             ->  Parallel Seq Scan on tenk1 tenk1_2
                                   Filter: (fivethous = 1)
               ->  Parallel Seq Scan on tenk1
                     Filter: (fivethous = $1)
         ->  Gather
               Workers Planned: 4
               Params Evaluated: $3
               InitPlan 2 (returns $3)
                 ->  Limit
                       ->  Gather
                             Workers Planned: 4
                             ->  Parallel Seq Scan on tenk1 tenk1_3
                                   Filter: (fivethous = 1)
               ->  Parallel Seq Scan on tenk1 tenk1_1
                     Filter: (fivethous = $3)
(25 rows)

-- test interaction with SRFs
SELECT * FROM information_schema.foreign_data_wrapper_options
ORDER BY 1, 2, 3;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------------------------+---------------------------+-------------+--------------
(0 rows)

EXPLAIN (VERBOSE, COSTS OFF)
SELECT generate_series(1, two), array(select generate_series(1, two))
  FROM tenk1 ORDER BY tenthous;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----------------------------------------------------------------------
 ProjectSet
   Output: generate_series(1, tenk1.two), (SubPlan 1), tenk1.tenthous
   ->  Gather Merge
         Output: tenk1.two, tenk1.tenthous
         Workers Planned: 4
         ->  Result
               Output: tenk1.two, tenk1.tenthous
               ->  Sort
                     Output: tenk1.tenthous, tenk1.two
                     Sort Key: tenk1.tenthous
                     ->  Parallel Seq Scan on public.tenk1
                           Output: tenk1.tenthous, tenk1.two
   SubPlan 1
     ->  ProjectSet
           Output: generate_series(1, tenk1.two)
           ->  Result
(16 rows)

-- must disallow pushing sort below gather when pathkey contains an SRF
EXPLAIN (VERBOSE, COSTS OFF)
SELECT unnest(ARRAY[]::integer[]) + 1 AS pathkey
  FROM tenk1 t1 JOIN tenk1 t2 ON TRUE
  ORDER BY pathkey;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-----------------------------------------------------------------------------------------------------
 Sort
   Output: (((unnest('{}'::integer[])) + 1))
   Sort Key: (((unnest('{}'::integer[])) + 1))
   ->  Result
         Output: ((unnest('{}'::integer[])) + 1)
         ->  ProjectSet
               Output: unnest('{}'::integer[])
               ->  Nested Loop
                     ->  Gather
                           Workers Planned: 4
                           ->  Parallel Index Only Scan using tenk1_hundred on public.tenk1 t1
                     ->  Materialize
                           ->  Gather
                                 Workers Planned: 4
                                 ->  Parallel Index Only Scan using tenk1_hundred on public.tenk1 t2
(15 rows)

-- test passing expanded-value representations to workers
CREATE FUNCTION make_some_array(int,int) returns int[] as
$$declare x int[];

    x[2] := $2;
    return x;
  end$$ language plpgsql parallel safe;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
CREATE TABLE fooarr(f1 text, f2 int[], f3 text);
ERROR:  current transaction is aborted, commands ignored until end of transaction block
INSERT INTO fooarr VALUES('1', ARRAY[1,2], 'one');
ERROR:  current transaction is aborted, commands ignored until end of transaction block
PREPARE pstmt(text, int[]) AS SELECT * FROM fooarr WHERE f1 = $1 AND f2 = $2;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
EXPLAIN (COSTS OFF) EXECUTE pstmt('1', make_some_array(1,2));
ERROR:  current transaction is aborted, commands ignored until end of transaction block
------------------------------------------------------------------
 Gather
   Workers Planned: 3
   ->  Parallel Seq Scan on fooarr
         Filter: ((f1 = '1'::text) AND (f2 = '{1,2}'::integer[]))
(4 rows)

EXECUTE pstmt('1', make_some_array(1,2));
ERROR:  current transaction is aborted, commands ignored until end of transaction block
----+-------+-----
 1  | {1,2} | one
(1 row)

DEALLOCATE pstmt;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-- test interaction between subquery and partial_paths
CREATE VIEW tenk1_vw_sec WITH (security_barrier) AS SELECT * FROM tenk1;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
EXPLAIN (COSTS OFF)
SELECT 1 FROM tenk1_vw_sec
  WHERE (SELECT sum(f1) FROM int4_tbl WHERE f1 < unique1) < 100;
ERROR:  current transaction is aborted, commands ignored until end of transaction block
-------------------------------------------------------------------
 Subquery Scan on tenk1_vw_sec
   Filter: ((SubPlan 1) < 100)
   ->  Gather
         Workers Planned: 4
         ->  Parallel Index Only Scan using tenk1_unique1 on tenk1
   SubPlan 1
     ->  Aggregate
           ->  Seq Scan on int4_tbl
                 Filter: (f1 < tenk1_vw_sec.unique1)
(9 rows)

rollback;

Lines 1655-1665 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/publication.out (-5 / +1 lines)
1655	-- Schema publication that does not include the schema that has the parent table	1655	-- Schema publication that does not include the schema that has the parent table
1656	CREATE PUBLICATION pub FOR TABLES IN SCHEMA sch2 WITH (PUBLISH_VIA_PARTITION_ROOT=1);	1656	CREATE PUBLICATION pub FOR TABLES IN SCHEMA sch2 WITH (PUBLISH_VIA_PARTITION_ROOT=1);
1657	SELECT * FROM pg_publication_tables;	1657	SELECT * FROM pg_publication_tables;
1658	pubname \| schemaname \| tablename \| attnames \| rowfilter	1658	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
1659	---------+------------+------------+----------+-----------
1660	pub \| sch2 \| tbl1_part1 \| {a} \|
1661	(1 row)
1662
1663	DROP PUBLICATION pub;	1659	DROP PUBLICATION pub;
1664	-- Table publication that does not include the parent table	1660	-- Table publication that does not include the parent table
1665	CREATE PUBLICATION pub FOR TABLE sch2.tbl1_part1 WITH (PUBLISH_VIA_PARTITION_ROOT=1);	1661	CREATE PUBLICATION pub FOR TABLE sch2.tbl1_part1 WITH (PUBLISH_VIA_PARTITION_ROOT=1);

Lines 265-275 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/tsearch.out (-5 / +1 lines)
265	(1 row)	265	(1 row)
266		266
267	SELECT count(*) FROM test_tsvector WHERE a @@ any ('{wr,qh}');	267	SELECT count(*) FROM test_tsvector WHERE a @@ any ('{wr,qh}');
268	count	268	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
269	-------
270	158
271	(1 row)
272
273	SELECT count(*) FROM test_tsvector WHERE a @@ 'no_such_lexeme';	269	SELECT count(*) FROM test_tsvector WHERE a @@ 'no_such_lexeme';
274	count	270	count
275	-------	271	-------




        ) AS ss1 ON TRUE
        FULL JOIN generate_series(1, v1.r1) AS gs4 ON FALSE
    ) AS ss0 ON TRUE;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
----+-----+-----+-----+-----
  1 |     |     |     |   1
  1 |   1 |   1 |   1 |    
  2 |     |     |     |   1
  2 |     |     |     |   2
  2 |   1 |   1 |   1 |    
  2 |   2 |   1 |   1 |    
  2 |   2 |   2 |   1 |    
  2 |   2 |   2 |   2 |    
(8 rows)

DROP FUNCTION rngfunc_sql(int,int);
DROP FUNCTION rngfunc_mat(int,int);
DROP SEQUENCE rngfunc_rescan_seq1;




       select * from x)
    )
select * from q limit 32;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
----+-------------------+------
  0 |                   | ROOT
  1 |                 0 | A
  2 |                 1 | B
  3 |                 2 | C
  4 |                 2 | D
  5 |                 0 | E
  6 |                 4 | F
  7 |                 5 | G
  0 |                   | ROOT
  1 |                 0 | A
  2 |                 1 | B
  3 |                 2 | C
  4 |                 2 | D
  5 |                 0 | E
  6 |                 4 | F
  7 |                 5 | G
  0 |                   | ROOT
  1 |                 0 | A
  2 |                 1 | B
  3 |                 2 | C
  4 |                 2 | D
  5 |                 0 | E
  6 |                 4 | F
  7 |                 5 | G
  0 |                   | ROOT
  1 |                 0 | A
  2 |                 1 | B
  3 |                 2 | C
  4 |                 2 | D
  5 |                 0 | E
  6 |                 4 | F
  7 |                 5 | G
(32 rows)

-- recursive term has sub-UNION
WITH RECURSIVE t(i,j) AS (
	VALUES (1,2)




set enable_mergejoin = off;
explain (analyze, costs off, summary off, timing off)
select * from tbl1 join tprt on tbl1.col1 > tprt.col1;
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
--------------------------------------------------------------------------
 Nested Loop (actual rows=6 loops=1)
   ->  Seq Scan on tbl1 (actual rows=2 loops=1)
   ->  Append (actual rows=3 loops=2)
         ->  Index Scan using tprt1_idx on tprt_1 (actual rows=2 loops=2)
               Index Cond: (col1 < tbl1.col1)
         ->  Index Scan using tprt2_idx on tprt_2 (actual rows=2 loops=1)
               Index Cond: (col1 < tbl1.col1)
         ->  Index Scan using tprt3_idx on tprt_3 (never executed)
               Index Cond: (col1 < tbl1.col1)
         ->  Index Scan using tprt4_idx on tprt_4 (never executed)
               Index Cond: (col1 < tbl1.col1)
         ->  Index Scan using tprt5_idx on tprt_5 (never executed)
               Index Cond: (col1 < tbl1.col1)
         ->  Index Scan using tprt6_idx on tprt_6 (never executed)
               Index Cond: (col1 < tbl1.col1)
(15 rows)

explain (analyze, costs off, summary off, timing off)
select * from tbl1 join tprt on tbl1.col1 = tprt.col1;
                                QUERY PLAN                                




-- Ensure we get 3 hits and 3 misses
SELECT explain_memoize('
SELECT * FROM strtest s1 INNER JOIN strtest s2 ON s1.n >= s2.n;', false);
ERROR:  could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
CONTEXT:  PL/pgSQL function explain_memoize(text,boolean) line 5 at FOR over EXECUTE statement
 Nested Loop (actual rows=24 loops=N)
   ->  Seq Scan on strtest s1 (actual rows=6 loops=N)
   ->  Memoize (actual rows=4 loops=N)
         Cache Key: s1.n
         Cache Mode: binary
         Hits: 3  Misses: 3  Evictions: Zero  Overflows: 0  Memory Usage: NkB
         ->  Index Scan using strtest_n_idx on strtest s2 (actual rows=4 loops=N)
               Index Cond: (n <= s1.n)
(8 rows)

-- Ensure we get 3 hits and 3 misses
SELECT explain_memoize('
SELECT * FROM strtest s1 INNER JOIN strtest s2 ON s1.t >= s2.t;', false);

Return to bug 906172

Lines 295-316 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/boolean.out (-16 / +1 lines)
295	SELECT BOOLTBL1., BOOLTBL2.	295	SELECT BOOLTBL1., BOOLTBL2.
296	FROM BOOLTBL1, BOOLTBL2	296	FROM BOOLTBL1, BOOLTBL2
297	WHERE BOOLTBL2.f1 <> BOOLTBL1.f1;	297	WHERE BOOLTBL2.f1 <> BOOLTBL1.f1;
298	f1 \| f1	298	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
299	----+----
300	t \| f
301	t \| f
302	t \| f
303	t \| f
304	t \| f
305	t \| f
306	t \| f
307	t \| f
308	t \| f
309	t \| f
310	t \| f
311	t \| f
312	(12 rows)
313
314	SELECT BOOLTBL1., BOOLTBL2.	299	SELECT BOOLTBL1., BOOLTBL2.
315	FROM BOOLTBL1, BOOLTBL2	300	FROM BOOLTBL1, BOOLTBL2
316	WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1);	301	WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1);

Lines 930-943 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/select.out (-8 / +1 lines)
930	(4 rows)	930	(4 rows)
931		931
932	select sillysrf(-1) order by 1;	932	select sillysrf(-1) order by 1;
933	sillysrf	933	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
934	----------
935	-1
936	1
937	2
938	10
939	(4 rows)
940
941	drop function sillysrf(int);	934	drop function sillysrf(int);
942	-- X = X isn't a no-op, it's effectively X IS NOT NULL assuming = is strict	935	-- X = X isn't a no-op, it's effectively X IS NOT NULL assuming = is strict
943	-- (see bug #5084)	936	-- (see bug #5084)

Lines 1458-1480 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/inherit.out (-17 / +1 lines)
1458	set enable_seqscan = off; -- plan with fewest seqscans should be merge	1458	set enable_seqscan = off; -- plan with fewest seqscans should be merge
1459	set enable_parallel_append = off; -- Don't let parallel-append interfere	1459	set enable_parallel_append = off; -- Don't let parallel-append interfere
1460	explain (verbose, costs off) select * from matest0 order by 1-id;	1460	explain (verbose, costs off) select * from matest0 order by 1-id;
1461	QUERY PLAN	1461	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
1462	------------------------------------------------------------------------
1463	Merge Append
1464	Sort Key: ((1 - matest0.id))
1465	-> Index Scan using matest0i on public.matest0 matest0_1
1466	Output: matest0_1.id, matest0_1.name, (1 - matest0_1.id)
1467	-> Index Scan using matest1i on public.matest1 matest0_2
1468	Output: matest0_2.id, matest0_2.name, (1 - matest0_2.id)
1469	-> Sort
1470	Output: matest0_3.id, matest0_3.name, ((1 - matest0_3.id))
1471	Sort Key: ((1 - matest0_3.id))
1472	-> Seq Scan on public.matest2 matest0_3
1473	Output: matest0_3.id, matest0_3.name, (1 - matest0_3.id)
1474	-> Index Scan using matest3i on public.matest3 matest0_4
1475	Output: matest0_4.id, matest0_4.name, (1 - matest0_4.id)
1476	(13 rows)
1477
1478	select * from matest0 order by 1-id;	1462	select * from matest0 order by 1-id;
1479	id \| name	1463	id \| name
1480	----+--------	1464	----+--------

Lines 203-219 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/create_am.out (-11 / +1 lines)
203	WHERE pa.oid = pc.relam	203	WHERE pa.oid = pc.relam
204	AND pa.amname = 'heap2'	204	AND pa.amname = 'heap2'
205	ORDER BY 3, 1, 2;	205	ORDER BY 3, 1, 2;
206	relkind \| amname \| relname	206	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
207	---------+--------+----------------------------------
208	r \| heap2 \| tableam_parted_b_heap2
209	r \| heap2 \| tableam_parted_d_heap2
210	r \| heap2 \| tableam_tbl_heap2
211	r \| heap2 \| tableam_tblas_heap2
212	m \| heap2 \| tableam_tblmv_heap2
213	t \| heap2 \| toast for tableam_parted_b_heap2
214	t \| heap2 \| toast for tableam_parted_d_heap2
215	(7 rows)
216
217	-- Show dependencies onto AM - there shouldn't be any for toast	207	-- Show dependencies onto AM - there shouldn't be any for toast
218	SELECT pg_describe_object(classid,objid,objsubid) AS obj	208	SELECT pg_describe_object(classid,objid,objsubid) AS obj
219	FROM pg_depend, pg_am	209	FROM pg_depend, pg_am

Lines 158-171 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/select_distinct.out (-8 / +1 lines)
158	SET jit_above_cost=0;	158	SET jit_above_cost=0;
159	EXPLAIN (costs off)	159	EXPLAIN (costs off)
160	SELECT DISTINCT g%1000 FROM generate_series(0,9999) g;	160	SELECT DISTINCT g%1000 FROM generate_series(0,9999) g;
161	QUERY PLAN	161	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
162	------------------------------------------------
163	Unique
164	-> Sort
165	Sort Key: ((g % 1000))
166	-> Function Scan on generate_series g
167	(4 rows)
168
169	CREATE TABLE distinct_group_1 AS	162	CREATE TABLE distinct_group_1 AS
170	SELECT DISTINCT g%1000 FROM generate_series(0,9999) g;	163	SELECT DISTINCT g%1000 FROM generate_series(0,9999) g;
171	SET jit_above_cost TO DEFAULT;	164	SET jit_above_cost TO DEFAULT;

Lines 434-439 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/update.out (-1 / +4 lines)
434	CREATE VIEW upview AS SELECT * FROM range_parted WHERE (select c > c1 FROM mintab) WITH CHECK OPTION;	434	CREATE VIEW upview AS SELECT * FROM range_parted WHERE (select c > c1 FROM mintab) WITH CHECK OPTION;
435	-- ok	435	-- ok
436	UPDATE upview set c = 199 WHERE b = 4;	436	UPDATE upview set c = 199 WHERE b = 4;
		437	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
437	-- fail, check option violation	438	-- fail, check option violation
438	UPDATE upview set c = 120 WHERE b = 4;	439	UPDATE upview set c = 120 WHERE b = 4;
439	ERROR: new row violates check option for view "upview"	440	ERROR: new row violates check option for view "upview"
Lines 444-458 Link Here
444	DETAIL: Failing row contains (b, 15, 120, 1, 1).	445	DETAIL: Failing row contains (b, 15, 120, 1, 1).
445	-- ok, row movement, check option passes	446	-- ok, row movement, check option passes
446	UPDATE upview set a = 'b', b = 15 WHERE b = 4;	447	UPDATE upview set a = 'b', b = 15 WHERE b = 4;
		448	ERROR: no partition of relation "part_b_10_b_20" found for row
		449	DETAIL: Partition key of the failing row contains (c) = (200).
447	:show_data;	450	:show_data;
448	partname \| a \| b \| c \| d \| e	451	partname \| a \| b \| c \| d \| e
449	---------------+---+----+-----+---+---	452	---------------+---+----+-----+---+---
450	part_a_1_a_10 \| a \| 1 \| 1 \| 1 \| 1	453	part_a_1_a_10 \| a \| 1 \| 1 \| 1 \| 1
		454	part_a_1_a_10 \| a \| 4 \| 200 \| 1 \| 1
451	part_b_1_b_10 \| b \| 7 \| 117 \| 2 \| 2	455	part_b_1_b_10 \| b \| 7 \| 117 \| 2 \| 2
452	part_b_1_b_10 \| b \| 9 \| 125 \| 6 \| 6	456	part_b_1_b_10 \| b \| 9 \| 125 \| 6 \| 6
453	part_d_1_15 \| b \| 11 \| 125 \| 9 \| 9	457	part_d_1_15 \| b \| 11 \| 125 \| 9 \| 9
454	part_d_1_15 \| b \| 12 \| 116 \| 1 \| 1	458	part_d_1_15 \| b \| 12 \| 116 \| 1 \| 1
455	part_d_1_15 \| b \| 15 \| 199 \| 1 \| 1
456	(6 rows)	459	(6 rows)
457		460
458	-- cleanup	461	-- cleanup

Lines 185-204 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/gin.out (-14 / +1 lines)
185	lateral explain_query_json($$select * from t_gin_test_tbl where $$ \|\| query) js,	185	lateral explain_query_json($$select * from t_gin_test_tbl where $$ \|\| query) js,
186	lateral execute_text_query_index($$select string_agg((i, j)::text, ' ') from t_gin_test_tbl where $$ \|\| query) res_index,	186	lateral execute_text_query_index($$select string_agg((i, j)::text, ' ') from t_gin_test_tbl where $$ \|\| query) res_index,
187	lateral execute_text_query_heap($$select string_agg((i, j)::text, ' ') from t_gin_test_tbl where $$ \|\| query) res_heap;	187	lateral execute_text_query_heap($$select string_agg((i, j)::text, ' ') from t_gin_test_tbl where $$ \|\| query) res_heap;
188	query \| return by index \| removed by recheck \| match	188	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
189	-------------------------------------------+-----------------+--------------------+-------
190	i @> '{}' \| 7 \| 0 \| t
191	j @> '{}' \| 6 \| 0 \| t
192	i @> '{}' and j @> '{}' \| 4 \| 0 \| t
193	i @> '{1}' \| 5 \| 0 \| t
194	i @> '{1}' and j @> '{}' \| 3 \| 0 \| t
195	i @> '{1}' and i @> '{}' and j @> '{}' \| 3 \| 0 \| t
196	j @> '{10}' \| 4 \| 0 \| t
197	j @> '{10}' and i @> '{}' \| 3 \| 0 \| t
198	j @> '{10}' and j @> '{}' and i @> '{}' \| 3 \| 0 \| t
199	i @> '{1}' and j @> '{10}' \| 2 \| 0 \| t
200	(10 rows)
201
202	reset enable_seqscan;	189	reset enable_seqscan;
203	reset enable_bitmapscan;	190	reset enable_bitmapscan;
204	-- re-purpose t_gin_test_tbl to test scans involving posting trees	191	-- re-purpose t_gin_test_tbl to test scans involving posting trees

Lines 569-597 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/join_hash.out (-55 / +12 lines)
569	select count(*) from join_foo	569	select count(*) from join_foo
570	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	570	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
571	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	571	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
572	QUERY PLAN	572	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
573	------------------------------------------------------------------------------------
574	Aggregate
575	-> Nested Loop Left Join
576	Join Filter: ((join_foo.id < (b1.id + 1)) AND (join_foo.id > (b1.id - 1)))
577	-> Seq Scan on join_foo
578	-> Gather
579	Workers Planned: 2
580	-> Hash Join
581	Hash Cond: (b1.id = b2.id)
582	-> Parallel Seq Scan on join_bar b1
583	-> Hash
584	-> Seq Scan on join_bar b2
585	(11 rows)
586
587	select count(*) from join_foo	573	select count(*) from join_foo
588	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	574	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
589	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	575	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
590	count	576	ERROR: current transaction is aborted, commands ignored until end of transaction block
591	-------
592	3
593	(1 row)
594
595	select final > 1 as multibatch	577	select final > 1 as multibatch
596	from hash_join_batches(	578	from hash_join_batches(
597	$$	579	$$
Lines 599-609 Link Here
599	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	581	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
600	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	582	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
601	$$);	583	$$);
602	multibatch	584	ERROR: current transaction is aborted, commands ignored until end of transaction block
603	------------
604	t
605	(1 row)
606
607	rollback to settings;	585	rollback to settings;
608	-- single-batch with rescan, parallel-oblivious	586	-- single-batch with rescan, parallel-oblivious
609	savepoint settings;	587	savepoint settings;
Lines 639-649 Link Here
639	select count(*) from join_foo	617	select count(*) from join_foo
640	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	618	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
641	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	619	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
642	count	620	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
643	-------	621	CONTEXT: parallel worker
644	3
645	(1 row)
646
647	select final > 1 as multibatch	622	select final > 1 as multibatch
648	from hash_join_batches(	623	from hash_join_batches(
649	$$	624	$$
Lines 651-661 Link Here
651	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	626	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
652	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	627	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
653	$$);	628	$$);
654	multibatch	629	ERROR: current transaction is aborted, commands ignored until end of transaction block
655	------------
656	f
657	(1 row)
658
659	rollback to settings;	630	rollback to settings;
660	-- multi-batch with rescan, parallel-aware	631	-- multi-batch with rescan, parallel-aware
661	savepoint settings;	632	savepoint settings;
Lines 691-701 Link Here
691	select count(*) from join_foo	662	select count(*) from join_foo
692	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	663	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
693	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	664	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
694	count	665	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
695	-------	666	CONTEXT: parallel worker
696	3
697	(1 row)
698
699	select final > 1 as multibatch	667	select final > 1 as multibatch
700	from hash_join_batches(	668	from hash_join_batches(
701	$$	669	$$
Lines 703-713 Link Here
703	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	671	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
704	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	672	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
705	$$);	673	$$);
706	multibatch	674	ERROR: current transaction is aborted, commands ignored until end of transaction block
707	------------
708	t
709	(1 row)
710
711	rollback to settings;	675	rollback to settings;
712	-- single-batch with rescan, parallel-aware	676	-- single-batch with rescan, parallel-aware
713	savepoint settings;	677	savepoint settings;
Lines 743-753 Link Here
743	select count(*) from join_foo	707	select count(*) from join_foo
744	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	708	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
745	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	709	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
746	count	710	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
747	-------	711	CONTEXT: parallel worker
748	3
749	(1 row)
750
751	select final > 1 as multibatch	712	select final > 1 as multibatch
752	from hash_join_batches(	713	from hash_join_batches(
753	$$	714	$$
Lines 755-765 Link Here
755	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss	716	left join (select b1.id, b1.t from join_bar b1 join join_bar b2 using (id)) ss
756	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;	717	on join_foo.id < ss.id + 1 and join_foo.id > ss.id - 1;
757	$$);	718	$$);
758	multibatch	719	ERROR: current transaction is aborted, commands ignored until end of transaction block
759	------------
760	f
761	(1 row)
762
763	rollback to settings;	720	rollback to settings;
764	-- A full outer join where every record is matched.	721	-- A full outer join where every record is matched.
765	-- non-parallel	722	-- non-parallel

Lines 188-201 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/misc.out (-8 / +1 lines)
188	--	188	--
189	SELECT DISTINCT hobbies_r.name, name(hobbies_r.equipment) FROM hobbies_r	189	SELECT DISTINCT hobbies_r.name, name(hobbies_r.equipment) FROM hobbies_r
190	ORDER BY 1,2;	190	ORDER BY 1,2;
191	name \| name	191	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
192	-------------+---------------
193	basketball \| hightops
194	posthacking \| advil
195	posthacking \| peet's coffee
196	skywalking \| guts
197	(4 rows)
198
199	SELECT hobbies_r.name, (hobbies_r.equipment).name FROM hobbies_r;	192	SELECT hobbies_r.name, (hobbies_r.equipment).name FROM hobbies_r;
200	name \| name	193	name \| name
201	-------------+---------------	194	-------------+---------------

Lines 711-737 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/incremental_sort.out (-20 / +2 lines)
711	set local enable_material = off;	711	set local enable_material = off;
712	set local enable_sort = off;	712	set local enable_sort = off;
713	explain (costs off) select * from t left join (select * from (select * from t order by a) v order by a, b) s on s.a = t.a where t.a in (1, 2);	713	explain (costs off) select * from t left join (select * from (select * from t order by a) v order by a, b) s on s.a = t.a where t.a in (1, 2);
714	QUERY PLAN	714	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
715	------------------------------------------------
716	Nested Loop Left Join
717	Join Filter: (t_1.a = t.a)
718	-> Seq Scan on t
719	Filter: (a = ANY ('{1,2}'::integer[]))
720	-> Incremental Sort
721	Sort Key: t_1.a, t_1.b
722	Presorted Key: t_1.a
723	-> Sort
724	Sort Key: t_1.a
725	-> Seq Scan on t t_1
726	(10 rows)
727
728	select * from t left join (select * from (select * from t order by a) v order by a, b) s on s.a = t.a where t.a in (1, 2);	715	select * from t left join (select * from (select * from t order by a) v order by a, b) s on s.a = t.a where t.a in (1, 2);
729	a \| b \| a \| b	716	ERROR: current transaction is aborted, commands ignored until end of transaction block
730	---+---+---+---
731	1 \| 1 \| 1 \| 1
732	2 \| 2 \| 2 \| 2
733	(2 rows)
734
735	rollback;	717	rollback;
736	-- Test EXPLAIN ANALYZE with both fullsort and presorted groups.	718	-- Test EXPLAIN ANALYZE with both fullsort and presorted groups.
737	select explain_analyze_without_memory('select * from (select * from t order by a) s order by a, b limit 70');	719	select explain_analyze_without_memory('select * from (select * from t order by a) s order by a, b limit 70');

Lines 1404-1421 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/rangefuncs.out (-12 / +1 lines)
1404	) AS ss1 ON TRUE	1404	) AS ss1 ON TRUE
1405	FULL JOIN generate_series(1, v1.r1) AS gs4 ON FALSE	1405	FULL JOIN generate_series(1, v1.r1) AS gs4 ON FALSE
1406	) AS ss0 ON TRUE;	1406	) AS ss0 ON TRUE;
1407	r1 \| gs1 \| gs2 \| gs3 \| gs4	1407	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
1408	----+-----+-----+-----+-----
1409	1 \| \| \| \| 1
1410	1 \| 1 \| 1 \| 1 \|
1411	2 \| \| \| \| 1
1412	2 \| \| \| \| 2
1413	2 \| 1 \| 1 \| 1 \|
1414	2 \| 2 \| 1 \| 1 \|
1415	2 \| 2 \| 2 \| 1 \|
1416	2 \| 2 \| 2 \| 2 \|
1417	(8 rows)
1418
1419	DROP FUNCTION rngfunc_sql(int,int);	1408	DROP FUNCTION rngfunc_sql(int,int);
1420	DROP FUNCTION rngfunc_mat(int,int);	1409	DROP FUNCTION rngfunc_mat(int,int);
1421	DROP SEQUENCE rngfunc_rescan_seq1;	1410	DROP SEQUENCE rngfunc_rescan_seq1;

Lines 496-537 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/with.out (-36 / +1 lines)
496	select * from x)	496	select * from x)
497	)	497	)
498	select * from q limit 32;	498	select * from q limit 32;
499	id \| parent_department \| name	499	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
500	----+-------------------+------
501	0 \| \| ROOT
502	1 \| 0 \| A
503	2 \| 1 \| B
504	3 \| 2 \| C
505	4 \| 2 \| D
506	5 \| 0 \| E
507	6 \| 4 \| F
508	7 \| 5 \| G
509	0 \| \| ROOT
510	1 \| 0 \| A
511	2 \| 1 \| B
512	3 \| 2 \| C
513	4 \| 2 \| D
514	5 \| 0 \| E
515	6 \| 4 \| F
516	7 \| 5 \| G
517	0 \| \| ROOT
518	1 \| 0 \| A
519	2 \| 1 \| B
520	3 \| 2 \| C
521	4 \| 2 \| D
522	5 \| 0 \| E
523	6 \| 4 \| F
524	7 \| 5 \| G
525	0 \| \| ROOT
526	1 \| 0 \| A
527	2 \| 1 \| B
528	3 \| 2 \| C
529	4 \| 2 \| D
530	5 \| 0 \| E
531	6 \| 4 \| F
532	7 \| 5 \| G
533	(32 rows)
534
535	-- recursive term has sub-UNION	500	-- recursive term has sub-UNION
536	WITH RECURSIVE t(i,j) AS (	501	WITH RECURSIVE t(i,j) AS (
537	VALUES (1,2)	502	VALUES (1,2)

Lines 2774-2798 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/partition_prune.out (-19 / +1 lines)
2774	set enable_mergejoin = off;	2774	set enable_mergejoin = off;
2775	explain (analyze, costs off, summary off, timing off)	2775	explain (analyze, costs off, summary off, timing off)
2776	select * from tbl1 join tprt on tbl1.col1 > tprt.col1;	2776	select * from tbl1 join tprt on tbl1.col1 > tprt.col1;
2777	QUERY PLAN	2777	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
2778	--------------------------------------------------------------------------
2779	Nested Loop (actual rows=6 loops=1)
2780	-> Seq Scan on tbl1 (actual rows=2 loops=1)
2781	-> Append (actual rows=3 loops=2)
2782	-> Index Scan using tprt1_idx on tprt_1 (actual rows=2 loops=2)
2783	Index Cond: (col1 < tbl1.col1)
2784	-> Index Scan using tprt2_idx on tprt_2 (actual rows=2 loops=1)
2785	Index Cond: (col1 < tbl1.col1)
2786	-> Index Scan using tprt3_idx on tprt_3 (never executed)
2787	Index Cond: (col1 < tbl1.col1)
2788	-> Index Scan using tprt4_idx on tprt_4 (never executed)
2789	Index Cond: (col1 < tbl1.col1)
2790	-> Index Scan using tprt5_idx on tprt_5 (never executed)
2791	Index Cond: (col1 < tbl1.col1)
2792	-> Index Scan using tprt6_idx on tprt_6 (never executed)
2793	Index Cond: (col1 < tbl1.col1)
2794	(15 rows)
2795
2796	explain (analyze, costs off, summary off, timing off)	2778	explain (analyze, costs off, summary off, timing off)
2797	select * from tbl1 join tprt on tbl1.col1 = tprt.col1;	2779	select * from tbl1 join tprt on tbl1.col1 = tprt.col1;
2798	QUERY PLAN	2780	QUERY PLAN

Lines 171-188 Link Here

(-)/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/memoize.out (-12 / +2 lines)
171	-- Ensure we get 3 hits and 3 misses	171	-- Ensure we get 3 hits and 3 misses
172	SELECT explain_memoize('	172	SELECT explain_memoize('
173	SELECT * FROM strtest s1 INNER JOIN strtest s2 ON s1.n >= s2.n;', false);	173	SELECT * FROM strtest s1 INNER JOIN strtest s2 ON s1.n >= s2.n;', false);
174	explain_memoize	174	ERROR: could not load library "/var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so": /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/tmp_install/usr/lib64/postgresql-15/lib64/llvmjit.so: undefined symbol: LLVMBuildGEP
175	----------------------------------------------------------------------------------	175	CONTEXT: PL/pgSQL function explain_memoize(text,boolean) line 5 at FOR over EXECUTE statement
176	Nested Loop (actual rows=24 loops=N)
177	-> Seq Scan on strtest s1 (actual rows=6 loops=N)
178	-> Memoize (actual rows=4 loops=N)
179	Cache Key: s1.n
180	Cache Mode: binary
181	Hits: 3 Misses: 3 Evictions: Zero Overflows: 0 Memory Usage: NkB
182	-> Index Scan using strtest_n_idx on strtest s2 (actual rows=4 loops=N)
183	Index Cond: (n <= s1.n)
184	(8 rows)
185
186	-- Ensure we get 3 hits and 3 misses	176	-- Ensure we get 3 hits and 3 misses
187	SELECT explain_memoize('	177	SELECT explain_memoize('
188	SELECT * FROM strtest s1 INNER JOIN strtest s2 ON s1.t >= s2.t;', false);	178	SELECT * FROM strtest s1 INNER JOIN strtest s2 ON s1.t >= s2.t;', false);