diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/boolean.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/boolean.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/boolean.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/boolean.out 2023-05-12 03:31:03.522466454 +0300 @@ -295,22 +295,7 @@ SELECT BOOLTBL1.*, BOOLTBL2.* FROM BOOLTBL1, BOOLTBL2 WHERE BOOLTBL2.f1 <> BOOLTBL1.f1; - f1 | f1 -----+---- - 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) - +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 SELECT BOOLTBL1.*, BOOLTBL2.* FROM BOOLTBL1, BOOLTBL2 WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1); diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/bit.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/bit.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/bit.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/bit.out 2023-05-12 03:31:03.545799787 +0300 @@ -44,22 +44,7 @@ SELECT v, b, (v || b) AS concat FROM BIT_TABLE, VARBIT_TABLE ORDER BY 3; - v | b | concat --------------+-------------+------------------------ - | 00000000000 | 00000000000 - 0 | 00000000000 | 000000000000 - 0 | 01010101010 | 001010101010 - 010101 | 00000000000 | 01010100000000000 - | 01010101010 | 01010101010 - 01010101010 | 00000000000 | 0101010101000000000000 - 01010101010 | 01010101010 | 0101010101001010101010 - 010101 | 01010101010 | 01010101010101010 - 01010101010 | 11011000000 | 0101010101011011000000 - 010101 | 11011000000 | 01010111011000000 - 0 | 11011000000 | 011011000000 - | 11011000000 | 11011000000 -(12 rows) - +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 -- Length SELECT b, length(b) AS lb FROM BIT_TABLE; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/rangetypes.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/rangetypes.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/rangetypes.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/rangetypes.out 2023-05-12 03:31:03.709133122 +0300 @@ -1697,11 +1697,7 @@ create type cashrange as range (subtype = money); set enable_sort = off; -- try to make it pick a hash setop implementation select '(2,5)'::cashrange except select '(5,6)'::cashrange; - cashrange ---------------- - ($2.00,$5.00) -(1 row) - +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 reset enable_sort; -- -- OUT/INOUT/TABLE functions diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/point.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/point.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/point.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/point.out 2023-05-12 03:31:03.939133124 +0300 @@ -153,110 +153,7 @@ SELECT p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist FROM POINT_TBL p1, POINT_TBL p2 ORDER BY dist, p1.f1[0], p2.f1[0]; - point1 | point2 | dist --------------------+-------------------+---------------------- - (-10,0) | (-10,0) | 0 - (-5,-12) | (-5,-12) | 0 - (-3,4) | (-3,4) | 0 - (0,0) | (0,0) | 0 - (1e-300,-1e-300) | (1e-300,-1e-300) | 0 - (5.1,34.5) | (5.1,34.5) | 0 - (10,10) | (10,10) | 0 - (0,0) | (1e-300,-1e-300) | 1.4142135623731e-300 - (1e-300,-1e-300) | (0,0) | 1.4142135623731e-300 - (-3,4) | (0,0) | 5 - (-3,4) | (1e-300,-1e-300) | 5 - (0,0) | (-3,4) | 5 - (1e-300,-1e-300) | (-3,4) | 5 - (-10,0) | (-3,4) | 8.06225774829855 - (-3,4) | (-10,0) | 8.06225774829855 - (-10,0) | (0,0) | 10 - (-10,0) | (1e-300,-1e-300) | 10 - (0,0) | (-10,0) | 10 - (1e-300,-1e-300) | (-10,0) | 10 - (-10,0) | (-5,-12) | 13 - (-5,-12) | (-10,0) | 13 - (-5,-12) | (0,0) | 13 - (-5,-12) | (1e-300,-1e-300) | 13 - (0,0) | (-5,-12) | 13 - (1e-300,-1e-300) | (-5,-12) | 13 - (0,0) | (10,10) | 14.142135623731 - (1e-300,-1e-300) | (10,10) | 14.142135623731 - (10,10) | (0,0) | 14.142135623731 - (10,10) | (1e-300,-1e-300) | 14.142135623731 - (-3,4) | (10,10) | 14.3178210632764 - (10,10) | (-3,4) | 14.3178210632764 - (-5,-12) | (-3,4) | 16.1245154965971 - (-3,4) | (-5,-12) | 16.1245154965971 - (-10,0) | (10,10) | 22.3606797749979 - (10,10) | (-10,0) | 22.3606797749979 - (5.1,34.5) | (10,10) | 24.9851956166046 - (10,10) | (5.1,34.5) | 24.9851956166046 - (-5,-12) | (10,10) | 26.6270539113887 - (10,10) | (-5,-12) | 26.6270539113887 - (-3,4) | (5.1,34.5) | 31.5572495632937 - (5.1,34.5) | (-3,4) | 31.5572495632937 - (0,0) | (5.1,34.5) | 34.8749193547455 - (1e-300,-1e-300) | (5.1,34.5) | 34.8749193547455 - (5.1,34.5) | (0,0) | 34.8749193547455 - (5.1,34.5) | (1e-300,-1e-300) | 34.8749193547455 - (-10,0) | (5.1,34.5) | 37.6597928831267 - (5.1,34.5) | (-10,0) | 37.6597928831267 - (-5,-12) | (5.1,34.5) | 47.5842410888311 - (5.1,34.5) | (-5,-12) | 47.5842410888311 - (-10,0) | (1e+300,Infinity) | Infinity - (-10,0) | (Infinity,1e+300) | Infinity - (-5,-12) | (1e+300,Infinity) | Infinity - (-5,-12) | (Infinity,1e+300) | Infinity - (-3,4) | (1e+300,Infinity) | Infinity - (-3,4) | (Infinity,1e+300) | Infinity - (0,0) | (1e+300,Infinity) | Infinity - (0,0) | (Infinity,1e+300) | Infinity - (1e-300,-1e-300) | (1e+300,Infinity) | Infinity - (1e-300,-1e-300) | (Infinity,1e+300) | Infinity - (5.1,34.5) | (1e+300,Infinity) | Infinity - (5.1,34.5) | (Infinity,1e+300) | Infinity - (10,10) | (1e+300,Infinity) | Infinity - (10,10) | (Infinity,1e+300) | Infinity - (1e+300,Infinity) | (-10,0) | Infinity - (1e+300,Infinity) | (-5,-12) | Infinity - (1e+300,Infinity) | (-3,4) | Infinity - (1e+300,Infinity) | (0,0) | Infinity - (1e+300,Infinity) | (1e-300,-1e-300) | Infinity - (1e+300,Infinity) | (5.1,34.5) | Infinity - (1e+300,Infinity) | (10,10) | Infinity - (1e+300,Infinity) | (Infinity,1e+300) | Infinity - (Infinity,1e+300) | (-10,0) | Infinity - (Infinity,1e+300) | (-5,-12) | Infinity - (Infinity,1e+300) | (-3,4) | Infinity - (Infinity,1e+300) | (0,0) | Infinity - (Infinity,1e+300) | (1e-300,-1e-300) | Infinity - (Infinity,1e+300) | (5.1,34.5) | Infinity - (Infinity,1e+300) | (10,10) | Infinity - (Infinity,1e+300) | (1e+300,Infinity) | Infinity - (-10,0) | (NaN,NaN) | NaN - (-5,-12) | (NaN,NaN) | NaN - (-3,4) | (NaN,NaN) | NaN - (0,0) | (NaN,NaN) | NaN - (1e-300,-1e-300) | (NaN,NaN) | NaN - (5.1,34.5) | (NaN,NaN) | NaN - (10,10) | (NaN,NaN) | NaN - (1e+300,Infinity) | (1e+300,Infinity) | NaN - (1e+300,Infinity) | (NaN,NaN) | NaN - (Infinity,1e+300) | (Infinity,1e+300) | NaN - (Infinity,1e+300) | (NaN,NaN) | NaN - (NaN,NaN) | (-10,0) | NaN - (NaN,NaN) | (-5,-12) | NaN - (NaN,NaN) | (-3,4) | NaN - (NaN,NaN) | (0,0) | NaN - (NaN,NaN) | (1e-300,-1e-300) | NaN - (NaN,NaN) | (5.1,34.5) | NaN - (NaN,NaN) | (10,10) | NaN - (NaN,NaN) | (1e+300,Infinity) | NaN - (NaN,NaN) | (Infinity,1e+300) | NaN - (NaN,NaN) | (NaN,NaN) | NaN -(100 rows) - +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 SELECT p1.f1 AS point1, p2.f1 AS point2 FROM POINT_TBL p1, POINT_TBL p2 WHERE (p1.f1 <-> p2.f1) > 3; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/box.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/box.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/box.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/box.out 2023-05-12 03:31:04.055799791 +0300 @@ -609,10 +609,7 @@ ON seq.n = idx.n AND seq.id = idx.id AND (seq.dist = idx.dist OR seq.dist IS NULL AND idx.dist IS NULL) WHERE seq.id IS NULL OR idx.id IS NULL; - n | dist | id | n | dist | id ----+------+----+---+------+---- -(0 rows) - +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 EXPLAIN (COSTS OFF) SELECT rank() OVER (ORDER BY b <-> point '123,456') n, b <-> point '123,456' dist, id FROM quad_box_tbl WHERE b <@ box '((200,300),(500,600))'; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/polygon.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/polygon.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/polygon.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/polygon.out 2023-05-12 03:31:04.032466458 +0300 @@ -299,10 +299,7 @@ ON seq.n = idx.n AND seq.id = idx.id AND (seq.dist = idx.dist OR seq.dist IS NULL AND idx.dist IS NULL) WHERE seq.id IS NULL OR idx.id IS NULL; - n | dist | id | n | dist | id ----+------+----+---+------+---- -(0 rows) - +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 RESET enable_seqscan; RESET enable_indexscan; RESET enable_bitmapscan; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/interval.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/interval.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/interval.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/interval.out 2023-05-12 03:31:03.962466457 +0300 @@ -158,55 +158,7 @@ FROM INTERVAL_TBL r1, INTERVAL_TBL r2 WHERE r1.f1 > r2.f1 ORDER BY r1.f1, r2.f1; - f1 | f1 ------------------+----------------- - 00:01:00 | -00:00:14 - 05:00:00 | -00:00:14 - 05:00:00 | 00:01:00 - 1 day 02:03:04 | -00:00:14 - 1 day 02:03:04 | 00:01:00 - 1 day 02:03:04 | 05:00:00 - 10 days | -00:00:14 - 10 days | 00:01:00 - 10 days | 05:00:00 - 10 days | 1 day 02:03:04 - 3 mons | -00:00:14 - 3 mons | 00:01:00 - 3 mons | 05:00:00 - 3 mons | 1 day 02:03:04 - 3 mons | 10 days - 5 mons | -00:00:14 - 5 mons | 00:01:00 - 5 mons | 05:00:00 - 5 mons | 1 day 02:03:04 - 5 mons | 10 days - 5 mons | 3 mons - 5 mons 12:00:00 | -00:00:14 - 5 mons 12:00:00 | 00:01:00 - 5 mons 12:00:00 | 05:00:00 - 5 mons 12:00:00 | 1 day 02:03:04 - 5 mons 12:00:00 | 10 days - 5 mons 12:00:00 | 3 mons - 5 mons 12:00:00 | 5 mons - 6 years | -00:00:14 - 6 years | 00:01:00 - 6 years | 05:00:00 - 6 years | 1 day 02:03:04 - 6 years | 10 days - 6 years | 3 mons - 6 years | 5 mons - 6 years | 5 mons 12:00:00 - 34 years | -00:00:14 - 34 years | 00:01:00 - 34 years | 05:00:00 - 34 years | 1 day 02:03:04 - 34 years | 10 days - 34 years | 3 mons - 34 years | 5 mons - 34 years | 5 mons 12:00:00 - 34 years | 6 years -(45 rows) - +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 -- Test intervals that are large enough to overflow 64 bits in comparisons CREATE TEMP TABLE INTERVAL_TBL_OF (f1 interval); INSERT INTO INTERVAL_TBL_OF (f1) VALUES diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/multirangetypes.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/multirangetypes.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/multirangetypes.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/multirangetypes.out 2023-05-12 03:31:04.052466458 +0300 @@ -2758,18 +2758,7 @@ FROM reservations GROUP BY room_id ORDER BY room_id; - room_id | range_agg ----------+--------------------------------------------------- - 1 | {[07-01-2018,07-14-2018),[07-20-2018,07-22-2018)} - 2 | {[07-01-2018,07-03-2018)} - 3 | - 4 | - 5 | {[07-01-2018,07-03-2018)} - 6 | {[07-01-2018,07-10-2018)} - 7 | {[07-01-2018,07-14-2018)} - 8 | {} -(8 rows) - +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 -- range_agg on a custom range type too SELECT range_agg(r) FROM (VALUES diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/geometry.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/geometry.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/geometry.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/geometry.out 2023-05-12 03:31:04.545799795 +0300 @@ -4274,71 +4274,7 @@ FROM CIRCLE_TBL c1, POINT_TBL p1 WHERE (p1.f1 <-> c1.f1) > 0 ORDER BY distance, area(c1.f1), p1.f1[0]; - circle | point | distance -----------------+-------------------+--------------- - <(1,2),3> | (-3,4) | 1.472135955 - <(5,1),3> | (0,0) | 2.09901951359 - <(5,1),3> | (1e-300,-1e-300) | 2.09901951359 - <(5,1),3> | (-3,4) | 5.54400374532 - <(3,5),0> | (0,0) | 5.83095189485 - <(3,5),0> | (1e-300,-1e-300) | 5.83095189485 - <(3,5),0> | (-3,4) | 6.0827625303 - <(1,3),5> | (-10,0) | 6.40175425099 - <(1,3),5> | (10,10) | 6.40175425099 - <(5,1),3> | (10,10) | 7.29563014099 - <(1,2),3> | (-10,0) | 8.1803398875 - <(3,5),0> | (10,10) | 8.60232526704 - <(1,2),3> | (10,10) | 9.04159457879 - <(1,3),5> | (-5,-12) | 11.1554944214 - <(5,1),3> | (-10,0) | 12.0332963784 - <(1,2),3> | (-5,-12) | 12.2315462117 - <(5,1),3> | (-5,-12) | 13.4012194669 - <(3,5),0> | (-10,0) | 13.9283882772 - <(3,5),0> | (-5,-12) | 18.7882942281 - <(1,3),5> | (5.1,34.5) | 26.7657047773 - <(3,5),0> | (5.1,34.5) | 29.5746513082 - <(1,2),3> | (5.1,34.5) | 29.7575945393 - <(5,1),3> | (5.1,34.5) | 30.5001492534 - <(100,200),10> | (5.1,34.5) | 180.778038568 - <(100,200),10> | (10,10) | 200.237960416 - <(100,200),10> | (-3,4) | 211.415898255 - <(100,200),10> | (0,0) | 213.60679775 - <(100,200),10> | (1e-300,-1e-300) | 213.60679775 - <(100,200),10> | (-10,0) | 218.25424421 - <(100,200),10> | (-5,-12) | 226.577682802 - <(3,5),0> | (1e+300,Infinity) | Infinity - <(3,5),0> | (Infinity,1e+300) | Infinity - <(1,2),3> | (1e+300,Infinity) | Infinity - <(5,1),3> | (1e+300,Infinity) | Infinity - <(5,1),3> | (Infinity,1e+300) | Infinity - <(1,2),3> | (Infinity,1e+300) | Infinity - <(1,3),5> | (1e+300,Infinity) | Infinity - <(1,3),5> | (Infinity,1e+300) | Infinity - <(100,200),10> | (1e+300,Infinity) | Infinity - <(100,200),10> | (Infinity,1e+300) | Infinity - <(1,2),100> | (1e+300,Infinity) | Infinity - <(1,2),100> | (Infinity,1e+300) | Infinity - <(100,1),115> | (1e+300,Infinity) | Infinity - <(100,1),115> | (Infinity,1e+300) | Infinity - <(3,5),0> | (NaN,NaN) | NaN - <(1,2),3> | (NaN,NaN) | NaN - <(5,1),3> | (NaN,NaN) | NaN - <(1,3),5> | (NaN,NaN) | NaN - <(100,200),10> | (NaN,NaN) | NaN - <(1,2),100> | (NaN,NaN) | NaN - <(100,1),115> | (NaN,NaN) | NaN - <(3,5),NaN> | (-10,0) | NaN - <(3,5),NaN> | (-5,-12) | NaN - <(3,5),NaN> | (-3,4) | NaN - <(3,5),NaN> | (0,0) | NaN - <(3,5),NaN> | (1e-300,-1e-300) | NaN - <(3,5),NaN> | (5.1,34.5) | NaN - <(3,5),NaN> | (10,10) | NaN - <(3,5),NaN> | (1e+300,Infinity) | NaN - <(3,5),NaN> | (Infinity,1e+300) | NaN - <(3,5),NaN> | (NaN,NaN) | NaN -(61 rows) - +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 -- To polygon SELECT f1, f1::polygon FROM CIRCLE_TBL WHERE f1 >= '<(0,0),1>'; f1 | f1 diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/horology.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/horology.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/horology.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/horology.out 2023-05-12 03:31:04.529133128 +0300 @@ -1051,110 +1051,7 @@ SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract" FROM TIME_TBL t, INTERVAL_TBL i ORDER BY 1,2; - t | i | add | subtract --------------+-------------------------------+-------------+------------- - 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14 - 00:00:00 | @ 1 min | 00:01:00 | 23:59:00 - 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00 - 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56 - 00:00:00 | @ 10 days | 00:00:00 | 00:00:00 - 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00 - 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00 - 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00 - 00:00:00 | @ 6 years | 00:00:00 | 00:00:00 - 00:00:00 | @ 34 years | 00:00:00 | 00:00:00 - 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14 - 01:00:00 | @ 1 min | 01:01:00 | 00:59:00 - 01:00:00 | @ 5 hours | 06:00:00 | 20:00:00 - 01:00:00 | @ 1 day 2 hours 3 mins 4 secs | 03:03:04 | 22:56:56 - 01:00:00 | @ 10 days | 01:00:00 | 01:00:00 - 01:00:00 | @ 3 mons | 01:00:00 | 01:00:00 - 01:00:00 | @ 5 mons | 01:00:00 | 01:00:00 - 01:00:00 | @ 5 mons 12 hours | 13:00:00 | 13:00:00 - 01:00:00 | @ 6 years | 01:00:00 | 01:00:00 - 01:00:00 | @ 34 years | 01:00:00 | 01:00:00 - 02:03:00 | @ 14 secs ago | 02:02:46 | 02:03:14 - 02:03:00 | @ 1 min | 02:04:00 | 02:02:00 - 02:03:00 | @ 5 hours | 07:03:00 | 21:03:00 - 02:03:00 | @ 1 day 2 hours 3 mins 4 secs | 04:06:04 | 23:59:56 - 02:03:00 | @ 10 days | 02:03:00 | 02:03:00 - 02:03:00 | @ 3 mons | 02:03:00 | 02:03:00 - 02:03:00 | @ 5 mons | 02:03:00 | 02:03:00 - 02:03:00 | @ 5 mons 12 hours | 14:03:00 | 14:03:00 - 02:03:00 | @ 6 years | 02:03:00 | 02:03:00 - 02:03:00 | @ 34 years | 02:03:00 | 02:03:00 - 11:59:00 | @ 14 secs ago | 11:58:46 | 11:59:14 - 11:59:00 | @ 1 min | 12:00:00 | 11:58:00 - 11:59:00 | @ 5 hours | 16:59:00 | 06:59:00 - 11:59:00 | @ 1 day 2 hours 3 mins 4 secs | 14:02:04 | 09:55:56 - 11:59:00 | @ 10 days | 11:59:00 | 11:59:00 - 11:59:00 | @ 3 mons | 11:59:00 | 11:59:00 - 11:59:00 | @ 5 mons | 11:59:00 | 11:59:00 - 11:59:00 | @ 5 mons 12 hours | 23:59:00 | 23:59:00 - 11:59:00 | @ 6 years | 11:59:00 | 11:59:00 - 11:59:00 | @ 34 years | 11:59:00 | 11:59:00 - 12:00:00 | @ 14 secs ago | 11:59:46 | 12:00:14 - 12:00:00 | @ 1 min | 12:01:00 | 11:59:00 - 12:00:00 | @ 5 hours | 17:00:00 | 07:00:00 - 12:00:00 | @ 1 day 2 hours 3 mins 4 secs | 14:03:04 | 09:56:56 - 12:00:00 | @ 10 days | 12:00:00 | 12:00:00 - 12:00:00 | @ 3 mons | 12:00:00 | 12:00:00 - 12:00:00 | @ 5 mons | 12:00:00 | 12:00:00 - 12:00:00 | @ 5 mons 12 hours | 00:00:00 | 00:00:00 - 12:00:00 | @ 6 years | 12:00:00 | 12:00:00 - 12:00:00 | @ 34 years | 12:00:00 | 12:00:00 - 12:01:00 | @ 14 secs ago | 12:00:46 | 12:01:14 - 12:01:00 | @ 1 min | 12:02:00 | 12:00:00 - 12:01:00 | @ 5 hours | 17:01:00 | 07:01:00 - 12:01:00 | @ 1 day 2 hours 3 mins 4 secs | 14:04:04 | 09:57:56 - 12:01:00 | @ 10 days | 12:01:00 | 12:01:00 - 12:01:00 | @ 3 mons | 12:01:00 | 12:01:00 - 12:01:00 | @ 5 mons | 12:01:00 | 12:01:00 - 12:01:00 | @ 5 mons 12 hours | 00:01:00 | 00:01:00 - 12:01:00 | @ 6 years | 12:01:00 | 12:01:00 - 12:01:00 | @ 34 years | 12:01:00 | 12:01:00 - 15:36:39 | @ 14 secs ago | 15:36:25 | 15:36:53 - 15:36:39 | @ 14 secs ago | 15:36:25 | 15:36:53 - 15:36:39 | @ 1 min | 15:37:39 | 15:35:39 - 15:36:39 | @ 1 min | 15:37:39 | 15:35:39 - 15:36:39 | @ 5 hours | 20:36:39 | 10:36:39 - 15:36:39 | @ 5 hours | 20:36:39 | 10:36:39 - 15:36:39 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43 | 13:33:35 - 15:36:39 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43 | 13:33:35 - 15:36:39 | @ 10 days | 15:36:39 | 15:36:39 - 15:36:39 | @ 10 days | 15:36:39 | 15:36:39 - 15:36:39 | @ 3 mons | 15:36:39 | 15:36:39 - 15:36:39 | @ 3 mons | 15:36:39 | 15:36:39 - 15:36:39 | @ 5 mons | 15:36:39 | 15:36:39 - 15:36:39 | @ 5 mons | 15:36:39 | 15:36:39 - 15:36:39 | @ 5 mons 12 hours | 03:36:39 | 03:36:39 - 15:36:39 | @ 5 mons 12 hours | 03:36:39 | 03:36:39 - 15:36:39 | @ 6 years | 15:36:39 | 15:36:39 - 15:36:39 | @ 6 years | 15:36:39 | 15:36:39 - 15:36:39 | @ 34 years | 15:36:39 | 15:36:39 - 15:36:39 | @ 34 years | 15:36:39 | 15:36:39 - 23:59:00 | @ 14 secs ago | 23:58:46 | 23:59:14 - 23:59:00 | @ 1 min | 00:00:00 | 23:58:00 - 23:59:00 | @ 5 hours | 04:59:00 | 18:59:00 - 23:59:00 | @ 1 day 2 hours 3 mins 4 secs | 02:02:04 | 21:55:56 - 23:59:00 | @ 10 days | 23:59:00 | 23:59:00 - 23:59:00 | @ 3 mons | 23:59:00 | 23:59:00 - 23:59:00 | @ 5 mons | 23:59:00 | 23:59:00 - 23:59:00 | @ 5 mons 12 hours | 11:59:00 | 11:59:00 - 23:59:00 | @ 6 years | 23:59:00 | 23:59:00 - 23:59:00 | @ 34 years | 23:59:00 | 23:59:00 - 23:59:59.99 | @ 14 secs ago | 23:59:45.99 | 00:00:13.99 - 23:59:59.99 | @ 1 min | 00:00:59.99 | 23:58:59.99 - 23:59:59.99 | @ 5 hours | 04:59:59.99 | 18:59:59.99 - 23:59:59.99 | @ 1 day 2 hours 3 mins 4 secs | 02:03:03.99 | 21:56:55.99 - 23:59:59.99 | @ 10 days | 23:59:59.99 | 23:59:59.99 - 23:59:59.99 | @ 3 mons | 23:59:59.99 | 23:59:59.99 - 23:59:59.99 | @ 5 mons | 23:59:59.99 | 23:59:59.99 - 23:59:59.99 | @ 5 mons 12 hours | 11:59:59.99 | 11:59:59.99 - 23:59:59.99 | @ 6 years | 23:59:59.99 | 23:59:59.99 - 23:59:59.99 | @ 34 years | 23:59:59.99 | 23:59:59.99 -(100 rows) - +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 SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract" FROM TIMETZ_TBL t, INTERVAL_TBL i ORDER BY 1,2; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/type_sanity.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/type_sanity.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/type_sanity.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/type_sanity.out 2023-05-12 03:31:04.555799795 +0300 @@ -148,10 +148,7 @@ FROM pg_type t WHERE t.typarray = proargtypes[array_length(proargtypes, 1)-1]) END != provariadic; - oid | provariadic | proargtypes ------+-------------+------------- -(0 rows) - +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 -- Check that all and only those functions with a variadic type have -- a variadic argument. SELECT oid::regprocedure, proargmodes, provariadic diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/create_index_spgist.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/create_index_spgist.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/create_index_spgist.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/create_index_spgist.out 2023-05-12 03:31:05.725799804 +0300 @@ -342,10 +342,7 @@ SELECT * FROM quad_point_tbl_ord_seq1 seq FULL JOIN quad_point_tbl_ord_idx1 idx ON seq.n = idx.n WHERE seq.dist IS DISTINCT FROM idx.dist; - n | dist | p | n | dist | p ----+------+---+---+------+--- -(0 rows) - +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 EXPLAIN (COSTS OFF) SELECT row_number() OVER (ORDER BY p <-> '0,0') n, p <-> '0,0' dist, p FROM quad_point_tbl WHERE p <@ box '(200,200,1000,1000)'; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/select.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/select.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/select.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/select.out 2023-05-12 03:31:06.009133139 +0300 @@ -930,14 +930,7 @@ (4 rows) select sillysrf(-1) order by 1; - sillysrf ----------- - -1 - 1 - 2 - 10 -(4 rows) - +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 drop function sillysrf(int); -- X = X isn't a no-op, it's effectively X IS NOT NULL assuming = is strict -- (see bug #5084) diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/inherit.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/inherit.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/inherit.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/inherit.out 2023-05-12 03:31:06.352466475 +0300 @@ -1458,23 +1458,7 @@ 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; - QUERY PLAN ------------------------------------------------------------------------- - 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) - +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 select * from matest0 order by 1-id; id | name ----+-------- diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/create_am.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/create_am.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/create_am.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/create_am.out 2023-05-12 03:31:06.082466473 +0300 @@ -203,17 +203,7 @@ WHERE pa.oid = pc.relam AND pa.amname = 'heap2' ORDER BY 3, 1, 2; - relkind | amname | relname ----------+--------+---------------------------------- - 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) - +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 -- 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 diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/select_distinct.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/select_distinct.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/select_distinct.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/select_distinct.out 2023-05-12 03:31:06.895799812 +0300 @@ -158,14 +158,7 @@ SET jit_above_cost=0; EXPLAIN (costs off) SELECT DISTINCT g%1000 FROM generate_series(0,9999) g; - QUERY PLAN ------------------------------------------------- - Unique - -> Sort - Sort Key: ((g % 1000)) - -> Function Scan on generate_series g -(4 rows) - +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 CREATE TABLE distinct_group_1 AS SELECT DISTINCT g%1000 FROM generate_series(0,9999) g; SET jit_above_cost TO DEFAULT; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/join.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/join.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/join.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/join.out 2023-05-12 03:31:07.149133148 +0300 @@ -663,901 +663,7 @@ SELECT * FROM J1_TBL CROSS JOIN J2_TBL a CROSS JOIN J2_TBL b; - i | j | t | i | k | i | k ----+---+-------+---+----+---+---- - 1 | 4 | one | 1 | -1 | 1 | -1 - 1 | 4 | one | 1 | -1 | 2 | 2 - 1 | 4 | one | 1 | -1 | 3 | -3 - 1 | 4 | one | 1 | -1 | 2 | 4 - 1 | 4 | one | 1 | -1 | 5 | -5 - 1 | 4 | one | 1 | -1 | 5 | -5 - 1 | 4 | one | 1 | -1 | 0 | - 1 | 4 | one | 1 | -1 | | - 1 | 4 | one | 1 | -1 | | 0 - 2 | 3 | two | 1 | -1 | 1 | -1 - 2 | 3 | two | 1 | -1 | 2 | 2 - 2 | 3 | two | 1 | -1 | 3 | -3 - 2 | 3 | two | 1 | -1 | 2 | 4 - 2 | 3 | two | 1 | -1 | 5 | -5 - 2 | 3 | two | 1 | -1 | 5 | -5 - 2 | 3 | two | 1 | -1 | 0 | - 2 | 3 | two | 1 | -1 | | - 2 | 3 | two | 1 | -1 | | 0 - 3 | 2 | three | 1 | -1 | 1 | -1 - 3 | 2 | three | 1 | -1 | 2 | 2 - 3 | 2 | three | 1 | -1 | 3 | -3 - 3 | 2 | three | 1 | -1 | 2 | 4 - 3 | 2 | three | 1 | -1 | 5 | -5 - 3 | 2 | three | 1 | -1 | 5 | -5 - 3 | 2 | three | 1 | -1 | 0 | - 3 | 2 | three | 1 | -1 | | - 3 | 2 | three | 1 | -1 | | 0 - 4 | 1 | four | 1 | -1 | 1 | -1 - 4 | 1 | four | 1 | -1 | 2 | 2 - 4 | 1 | four | 1 | -1 | 3 | -3 - 4 | 1 | four | 1 | -1 | 2 | 4 - 4 | 1 | four | 1 | -1 | 5 | -5 - 4 | 1 | four | 1 | -1 | 5 | -5 - 4 | 1 | four | 1 | -1 | 0 | - 4 | 1 | four | 1 | -1 | | - 4 | 1 | four | 1 | -1 | | 0 - 5 | 0 | five | 1 | -1 | 1 | -1 - 5 | 0 | five | 1 | -1 | 2 | 2 - 5 | 0 | five | 1 | -1 | 3 | -3 - 5 | 0 | five | 1 | -1 | 2 | 4 - 5 | 0 | five | 1 | -1 | 5 | -5 - 5 | 0 | five | 1 | -1 | 5 | -5 - 5 | 0 | five | 1 | -1 | 0 | - 5 | 0 | five | 1 | -1 | | - 5 | 0 | five | 1 | -1 | | 0 - 6 | 6 | six | 1 | -1 | 1 | -1 - 6 | 6 | six | 1 | -1 | 2 | 2 - 6 | 6 | six | 1 | -1 | 3 | -3 - 6 | 6 | six | 1 | -1 | 2 | 4 - 6 | 6 | six | 1 | -1 | 5 | -5 - 6 | 6 | six | 1 | -1 | 5 | -5 - 6 | 6 | six | 1 | -1 | 0 | - 6 | 6 | six | 1 | -1 | | - 6 | 6 | six | 1 | -1 | | 0 - 7 | 7 | seven | 1 | -1 | 1 | -1 - 7 | 7 | seven | 1 | -1 | 2 | 2 - 7 | 7 | seven | 1 | -1 | 3 | -3 - 7 | 7 | seven | 1 | -1 | 2 | 4 - 7 | 7 | seven | 1 | -1 | 5 | -5 - 7 | 7 | seven | 1 | -1 | 5 | -5 - 7 | 7 | seven | 1 | -1 | 0 | - 7 | 7 | seven | 1 | -1 | | - 7 | 7 | seven | 1 | -1 | | 0 - 8 | 8 | eight | 1 | -1 | 1 | -1 - 8 | 8 | eight | 1 | -1 | 2 | 2 - 8 | 8 | eight | 1 | -1 | 3 | -3 - 8 | 8 | eight | 1 | -1 | 2 | 4 - 8 | 8 | eight | 1 | -1 | 5 | -5 - 8 | 8 | eight | 1 | -1 | 5 | -5 - 8 | 8 | eight | 1 | -1 | 0 | - 8 | 8 | eight | 1 | -1 | | - 8 | 8 | eight | 1 | -1 | | 0 - 0 | | zero | 1 | -1 | 1 | -1 - 0 | | zero | 1 | -1 | 2 | 2 - 0 | | zero | 1 | -1 | 3 | -3 - 0 | | zero | 1 | -1 | 2 | 4 - 0 | | zero | 1 | -1 | 5 | -5 - 0 | | zero | 1 | -1 | 5 | -5 - 0 | | zero | 1 | -1 | 0 | - 0 | | zero | 1 | -1 | | - 0 | | zero | 1 | -1 | | 0 - | | null | 1 | -1 | 1 | -1 - | | null | 1 | -1 | 2 | 2 - | | null | 1 | -1 | 3 | -3 - | | null | 1 | -1 | 2 | 4 - | | null | 1 | -1 | 5 | -5 - | | null | 1 | -1 | 5 | -5 - | | null | 1 | -1 | 0 | - | | null | 1 | -1 | | - | | null | 1 | -1 | | 0 - | 0 | zero | 1 | -1 | 1 | -1 - | 0 | zero | 1 | -1 | 2 | 2 - | 0 | zero | 1 | -1 | 3 | -3 - | 0 | zero | 1 | -1 | 2 | 4 - | 0 | zero | 1 | -1 | 5 | -5 - | 0 | zero | 1 | -1 | 5 | -5 - | 0 | zero | 1 | -1 | 0 | - | 0 | zero | 1 | -1 | | - | 0 | zero | 1 | -1 | | 0 - 1 | 4 | one | 2 | 2 | 1 | -1 - 1 | 4 | one | 2 | 2 | 2 | 2 - 1 | 4 | one | 2 | 2 | 3 | -3 - 1 | 4 | one | 2 | 2 | 2 | 4 - 1 | 4 | one | 2 | 2 | 5 | -5 - 1 | 4 | one | 2 | 2 | 5 | -5 - 1 | 4 | one | 2 | 2 | 0 | - 1 | 4 | one | 2 | 2 | | - 1 | 4 | one | 2 | 2 | | 0 - 2 | 3 | two | 2 | 2 | 1 | -1 - 2 | 3 | two | 2 | 2 | 2 | 2 - 2 | 3 | two | 2 | 2 | 3 | -3 - 2 | 3 | two | 2 | 2 | 2 | 4 - 2 | 3 | two | 2 | 2 | 5 | -5 - 2 | 3 | two | 2 | 2 | 5 | -5 - 2 | 3 | two | 2 | 2 | 0 | - 2 | 3 | two | 2 | 2 | | - 2 | 3 | two | 2 | 2 | | 0 - 3 | 2 | three | 2 | 2 | 1 | -1 - 3 | 2 | three | 2 | 2 | 2 | 2 - 3 | 2 | three | 2 | 2 | 3 | -3 - 3 | 2 | three | 2 | 2 | 2 | 4 - 3 | 2 | three | 2 | 2 | 5 | -5 - 3 | 2 | three | 2 | 2 | 5 | -5 - 3 | 2 | three | 2 | 2 | 0 | - 3 | 2 | three | 2 | 2 | | - 3 | 2 | three | 2 | 2 | | 0 - 4 | 1 | four | 2 | 2 | 1 | -1 - 4 | 1 | four | 2 | 2 | 2 | 2 - 4 | 1 | four | 2 | 2 | 3 | -3 - 4 | 1 | four | 2 | 2 | 2 | 4 - 4 | 1 | four | 2 | 2 | 5 | -5 - 4 | 1 | four | 2 | 2 | 5 | -5 - 4 | 1 | four | 2 | 2 | 0 | - 4 | 1 | four | 2 | 2 | | - 4 | 1 | four | 2 | 2 | | 0 - 5 | 0 | five | 2 | 2 | 1 | -1 - 5 | 0 | five | 2 | 2 | 2 | 2 - 5 | 0 | five | 2 | 2 | 3 | -3 - 5 | 0 | five | 2 | 2 | 2 | 4 - 5 | 0 | five | 2 | 2 | 5 | -5 - 5 | 0 | five | 2 | 2 | 5 | -5 - 5 | 0 | five | 2 | 2 | 0 | - 5 | 0 | five | 2 | 2 | | - 5 | 0 | five | 2 | 2 | | 0 - 6 | 6 | six | 2 | 2 | 1 | -1 - 6 | 6 | six | 2 | 2 | 2 | 2 - 6 | 6 | six | 2 | 2 | 3 | -3 - 6 | 6 | six | 2 | 2 | 2 | 4 - 6 | 6 | six | 2 | 2 | 5 | -5 - 6 | 6 | six | 2 | 2 | 5 | -5 - 6 | 6 | six | 2 | 2 | 0 | - 6 | 6 | six | 2 | 2 | | - 6 | 6 | six | 2 | 2 | | 0 - 7 | 7 | seven | 2 | 2 | 1 | -1 - 7 | 7 | seven | 2 | 2 | 2 | 2 - 7 | 7 | seven | 2 | 2 | 3 | -3 - 7 | 7 | seven | 2 | 2 | 2 | 4 - 7 | 7 | seven | 2 | 2 | 5 | -5 - 7 | 7 | seven | 2 | 2 | 5 | -5 - 7 | 7 | seven | 2 | 2 | 0 | - 7 | 7 | seven | 2 | 2 | | - 7 | 7 | seven | 2 | 2 | | 0 - 8 | 8 | eight | 2 | 2 | 1 | -1 - 8 | 8 | eight | 2 | 2 | 2 | 2 - 8 | 8 | eight | 2 | 2 | 3 | -3 - 8 | 8 | eight | 2 | 2 | 2 | 4 - 8 | 8 | eight | 2 | 2 | 5 | -5 - 8 | 8 | eight | 2 | 2 | 5 | -5 - 8 | 8 | eight | 2 | 2 | 0 | - 8 | 8 | eight | 2 | 2 | | - 8 | 8 | eight | 2 | 2 | | 0 - 0 | | zero | 2 | 2 | 1 | -1 - 0 | | zero | 2 | 2 | 2 | 2 - 0 | | zero | 2 | 2 | 3 | -3 - 0 | | zero | 2 | 2 | 2 | 4 - 0 | | zero | 2 | 2 | 5 | -5 - 0 | | zero | 2 | 2 | 5 | -5 - 0 | | zero | 2 | 2 | 0 | - 0 | | zero | 2 | 2 | | - 0 | | zero | 2 | 2 | | 0 - | | null | 2 | 2 | 1 | -1 - | | null | 2 | 2 | 2 | 2 - | | null | 2 | 2 | 3 | -3 - | | null | 2 | 2 | 2 | 4 - | | null | 2 | 2 | 5 | -5 - | | null | 2 | 2 | 5 | -5 - | | null | 2 | 2 | 0 | - | | null | 2 | 2 | | - | | null | 2 | 2 | | 0 - | 0 | zero | 2 | 2 | 1 | -1 - | 0 | zero | 2 | 2 | 2 | 2 - | 0 | zero | 2 | 2 | 3 | -3 - | 0 | zero | 2 | 2 | 2 | 4 - | 0 | zero | 2 | 2 | 5 | -5 - | 0 | zero | 2 | 2 | 5 | -5 - | 0 | zero | 2 | 2 | 0 | - | 0 | zero | 2 | 2 | | - | 0 | zero | 2 | 2 | | 0 - 1 | 4 | one | 3 | -3 | 1 | -1 - 1 | 4 | one | 3 | -3 | 2 | 2 - 1 | 4 | one | 3 | -3 | 3 | -3 - 1 | 4 | one | 3 | -3 | 2 | 4 - 1 | 4 | one | 3 | -3 | 5 | -5 - 1 | 4 | one | 3 | -3 | 5 | -5 - 1 | 4 | one | 3 | -3 | 0 | - 1 | 4 | one | 3 | -3 | | - 1 | 4 | one | 3 | -3 | | 0 - 2 | 3 | two | 3 | -3 | 1 | -1 - 2 | 3 | two | 3 | -3 | 2 | 2 - 2 | 3 | two | 3 | -3 | 3 | -3 - 2 | 3 | two | 3 | -3 | 2 | 4 - 2 | 3 | two | 3 | -3 | 5 | -5 - 2 | 3 | two | 3 | -3 | 5 | -5 - 2 | 3 | two | 3 | -3 | 0 | - 2 | 3 | two | 3 | -3 | | - 2 | 3 | two | 3 | -3 | | 0 - 3 | 2 | three | 3 | -3 | 1 | -1 - 3 | 2 | three | 3 | -3 | 2 | 2 - 3 | 2 | three | 3 | -3 | 3 | -3 - 3 | 2 | three | 3 | -3 | 2 | 4 - 3 | 2 | three | 3 | -3 | 5 | -5 - 3 | 2 | three | 3 | -3 | 5 | -5 - 3 | 2 | three | 3 | -3 | 0 | - 3 | 2 | three | 3 | -3 | | - 3 | 2 | three | 3 | -3 | | 0 - 4 | 1 | four | 3 | -3 | 1 | -1 - 4 | 1 | four | 3 | -3 | 2 | 2 - 4 | 1 | four | 3 | -3 | 3 | -3 - 4 | 1 | four | 3 | -3 | 2 | 4 - 4 | 1 | four | 3 | -3 | 5 | -5 - 4 | 1 | four | 3 | -3 | 5 | -5 - 4 | 1 | four | 3 | -3 | 0 | - 4 | 1 | four | 3 | -3 | | - 4 | 1 | four | 3 | -3 | | 0 - 5 | 0 | five | 3 | -3 | 1 | -1 - 5 | 0 | five | 3 | -3 | 2 | 2 - 5 | 0 | five | 3 | -3 | 3 | -3 - 5 | 0 | five | 3 | -3 | 2 | 4 - 5 | 0 | five | 3 | -3 | 5 | -5 - 5 | 0 | five | 3 | -3 | 5 | -5 - 5 | 0 | five | 3 | -3 | 0 | - 5 | 0 | five | 3 | -3 | | - 5 | 0 | five | 3 | -3 | | 0 - 6 | 6 | six | 3 | -3 | 1 | -1 - 6 | 6 | six | 3 | -3 | 2 | 2 - 6 | 6 | six | 3 | -3 | 3 | -3 - 6 | 6 | six | 3 | -3 | 2 | 4 - 6 | 6 | six | 3 | -3 | 5 | -5 - 6 | 6 | six | 3 | -3 | 5 | -5 - 6 | 6 | six | 3 | -3 | 0 | - 6 | 6 | six | 3 | -3 | | - 6 | 6 | six | 3 | -3 | | 0 - 7 | 7 | seven | 3 | -3 | 1 | -1 - 7 | 7 | seven | 3 | -3 | 2 | 2 - 7 | 7 | seven | 3 | -3 | 3 | -3 - 7 | 7 | seven | 3 | -3 | 2 | 4 - 7 | 7 | seven | 3 | -3 | 5 | -5 - 7 | 7 | seven | 3 | -3 | 5 | -5 - 7 | 7 | seven | 3 | -3 | 0 | - 7 | 7 | seven | 3 | -3 | | - 7 | 7 | seven | 3 | -3 | | 0 - 8 | 8 | eight | 3 | -3 | 1 | -1 - 8 | 8 | eight | 3 | -3 | 2 | 2 - 8 | 8 | eight | 3 | -3 | 3 | -3 - 8 | 8 | eight | 3 | -3 | 2 | 4 - 8 | 8 | eight | 3 | -3 | 5 | -5 - 8 | 8 | eight | 3 | -3 | 5 | -5 - 8 | 8 | eight | 3 | -3 | 0 | - 8 | 8 | eight | 3 | -3 | | - 8 | 8 | eight | 3 | -3 | | 0 - 0 | | zero | 3 | -3 | 1 | -1 - 0 | | zero | 3 | -3 | 2 | 2 - 0 | | zero | 3 | -3 | 3 | -3 - 0 | | zero | 3 | -3 | 2 | 4 - 0 | | zero | 3 | -3 | 5 | -5 - 0 | | zero | 3 | -3 | 5 | -5 - 0 | | zero | 3 | -3 | 0 | - 0 | | zero | 3 | -3 | | - 0 | | zero | 3 | -3 | | 0 - | | null | 3 | -3 | 1 | -1 - | | null | 3 | -3 | 2 | 2 - | | null | 3 | -3 | 3 | -3 - | | null | 3 | -3 | 2 | 4 - | | null | 3 | -3 | 5 | -5 - | | null | 3 | -3 | 5 | -5 - | | null | 3 | -3 | 0 | - | | null | 3 | -3 | | - | | null | 3 | -3 | | 0 - | 0 | zero | 3 | -3 | 1 | -1 - | 0 | zero | 3 | -3 | 2 | 2 - | 0 | zero | 3 | -3 | 3 | -3 - | 0 | zero | 3 | -3 | 2 | 4 - | 0 | zero | 3 | -3 | 5 | -5 - | 0 | zero | 3 | -3 | 5 | -5 - | 0 | zero | 3 | -3 | 0 | - | 0 | zero | 3 | -3 | | - | 0 | zero | 3 | -3 | | 0 - 1 | 4 | one | 2 | 4 | 1 | -1 - 1 | 4 | one | 2 | 4 | 2 | 2 - 1 | 4 | one | 2 | 4 | 3 | -3 - 1 | 4 | one | 2 | 4 | 2 | 4 - 1 | 4 | one | 2 | 4 | 5 | -5 - 1 | 4 | one | 2 | 4 | 5 | -5 - 1 | 4 | one | 2 | 4 | 0 | - 1 | 4 | one | 2 | 4 | | - 1 | 4 | one | 2 | 4 | | 0 - 2 | 3 | two | 2 | 4 | 1 | -1 - 2 | 3 | two | 2 | 4 | 2 | 2 - 2 | 3 | two | 2 | 4 | 3 | -3 - 2 | 3 | two | 2 | 4 | 2 | 4 - 2 | 3 | two | 2 | 4 | 5 | -5 - 2 | 3 | two | 2 | 4 | 5 | -5 - 2 | 3 | two | 2 | 4 | 0 | - 2 | 3 | two | 2 | 4 | | - 2 | 3 | two | 2 | 4 | | 0 - 3 | 2 | three | 2 | 4 | 1 | -1 - 3 | 2 | three | 2 | 4 | 2 | 2 - 3 | 2 | three | 2 | 4 | 3 | -3 - 3 | 2 | three | 2 | 4 | 2 | 4 - 3 | 2 | three | 2 | 4 | 5 | -5 - 3 | 2 | three | 2 | 4 | 5 | -5 - 3 | 2 | three | 2 | 4 | 0 | - 3 | 2 | three | 2 | 4 | | - 3 | 2 | three | 2 | 4 | | 0 - 4 | 1 | four | 2 | 4 | 1 | -1 - 4 | 1 | four | 2 | 4 | 2 | 2 - 4 | 1 | four | 2 | 4 | 3 | -3 - 4 | 1 | four | 2 | 4 | 2 | 4 - 4 | 1 | four | 2 | 4 | 5 | -5 - 4 | 1 | four | 2 | 4 | 5 | -5 - 4 | 1 | four | 2 | 4 | 0 | - 4 | 1 | four | 2 | 4 | | - 4 | 1 | four | 2 | 4 | | 0 - 5 | 0 | five | 2 | 4 | 1 | -1 - 5 | 0 | five | 2 | 4 | 2 | 2 - 5 | 0 | five | 2 | 4 | 3 | -3 - 5 | 0 | five | 2 | 4 | 2 | 4 - 5 | 0 | five | 2 | 4 | 5 | -5 - 5 | 0 | five | 2 | 4 | 5 | -5 - 5 | 0 | five | 2 | 4 | 0 | - 5 | 0 | five | 2 | 4 | | - 5 | 0 | five | 2 | 4 | | 0 - 6 | 6 | six | 2 | 4 | 1 | -1 - 6 | 6 | six | 2 | 4 | 2 | 2 - 6 | 6 | six | 2 | 4 | 3 | -3 - 6 | 6 | six | 2 | 4 | 2 | 4 - 6 | 6 | six | 2 | 4 | 5 | -5 - 6 | 6 | six | 2 | 4 | 5 | -5 - 6 | 6 | six | 2 | 4 | 0 | - 6 | 6 | six | 2 | 4 | | - 6 | 6 | six | 2 | 4 | | 0 - 7 | 7 | seven | 2 | 4 | 1 | -1 - 7 | 7 | seven | 2 | 4 | 2 | 2 - 7 | 7 | seven | 2 | 4 | 3 | -3 - 7 | 7 | seven | 2 | 4 | 2 | 4 - 7 | 7 | seven | 2 | 4 | 5 | -5 - 7 | 7 | seven | 2 | 4 | 5 | -5 - 7 | 7 | seven | 2 | 4 | 0 | - 7 | 7 | seven | 2 | 4 | | - 7 | 7 | seven | 2 | 4 | | 0 - 8 | 8 | eight | 2 | 4 | 1 | -1 - 8 | 8 | eight | 2 | 4 | 2 | 2 - 8 | 8 | eight | 2 | 4 | 3 | -3 - 8 | 8 | eight | 2 | 4 | 2 | 4 - 8 | 8 | eight | 2 | 4 | 5 | -5 - 8 | 8 | eight | 2 | 4 | 5 | -5 - 8 | 8 | eight | 2 | 4 | 0 | - 8 | 8 | eight | 2 | 4 | | - 8 | 8 | eight | 2 | 4 | | 0 - 0 | | zero | 2 | 4 | 1 | -1 - 0 | | zero | 2 | 4 | 2 | 2 - 0 | | zero | 2 | 4 | 3 | -3 - 0 | | zero | 2 | 4 | 2 | 4 - 0 | | zero | 2 | 4 | 5 | -5 - 0 | | zero | 2 | 4 | 5 | -5 - 0 | | zero | 2 | 4 | 0 | - 0 | | zero | 2 | 4 | | - 0 | | zero | 2 | 4 | | 0 - | | null | 2 | 4 | 1 | -1 - | | null | 2 | 4 | 2 | 2 - | | null | 2 | 4 | 3 | -3 - | | null | 2 | 4 | 2 | 4 - | | null | 2 | 4 | 5 | -5 - | | null | 2 | 4 | 5 | -5 - | | null | 2 | 4 | 0 | - | | null | 2 | 4 | | - | | null | 2 | 4 | | 0 - | 0 | zero | 2 | 4 | 1 | -1 - | 0 | zero | 2 | 4 | 2 | 2 - | 0 | zero | 2 | 4 | 3 | -3 - | 0 | zero | 2 | 4 | 2 | 4 - | 0 | zero | 2 | 4 | 5 | -5 - | 0 | zero | 2 | 4 | 5 | -5 - | 0 | zero | 2 | 4 | 0 | - | 0 | zero | 2 | 4 | | - | 0 | zero | 2 | 4 | | 0 - 1 | 4 | one | 5 | -5 | 1 | -1 - 1 | 4 | one | 5 | -5 | 2 | 2 - 1 | 4 | one | 5 | -5 | 3 | -3 - 1 | 4 | one | 5 | -5 | 2 | 4 - 1 | 4 | one | 5 | -5 | 5 | -5 - 1 | 4 | one | 5 | -5 | 5 | -5 - 1 | 4 | one | 5 | -5 | 0 | - 1 | 4 | one | 5 | -5 | | - 1 | 4 | one | 5 | -5 | | 0 - 2 | 3 | two | 5 | -5 | 1 | -1 - 2 | 3 | two | 5 | -5 | 2 | 2 - 2 | 3 | two | 5 | -5 | 3 | -3 - 2 | 3 | two | 5 | -5 | 2 | 4 - 2 | 3 | two | 5 | -5 | 5 | -5 - 2 | 3 | two | 5 | -5 | 5 | -5 - 2 | 3 | two | 5 | -5 | 0 | - 2 | 3 | two | 5 | -5 | | - 2 | 3 | two | 5 | -5 | | 0 - 3 | 2 | three | 5 | -5 | 1 | -1 - 3 | 2 | three | 5 | -5 | 2 | 2 - 3 | 2 | three | 5 | -5 | 3 | -3 - 3 | 2 | three | 5 | -5 | 2 | 4 - 3 | 2 | three | 5 | -5 | 5 | -5 - 3 | 2 | three | 5 | -5 | 5 | -5 - 3 | 2 | three | 5 | -5 | 0 | - 3 | 2 | three | 5 | -5 | | - 3 | 2 | three | 5 | -5 | | 0 - 4 | 1 | four | 5 | -5 | 1 | -1 - 4 | 1 | four | 5 | -5 | 2 | 2 - 4 | 1 | four | 5 | -5 | 3 | -3 - 4 | 1 | four | 5 | -5 | 2 | 4 - 4 | 1 | four | 5 | -5 | 5 | -5 - 4 | 1 | four | 5 | -5 | 5 | -5 - 4 | 1 | four | 5 | -5 | 0 | - 4 | 1 | four | 5 | -5 | | - 4 | 1 | four | 5 | -5 | | 0 - 5 | 0 | five | 5 | -5 | 1 | -1 - 5 | 0 | five | 5 | -5 | 2 | 2 - 5 | 0 | five | 5 | -5 | 3 | -3 - 5 | 0 | five | 5 | -5 | 2 | 4 - 5 | 0 | five | 5 | -5 | 5 | -5 - 5 | 0 | five | 5 | -5 | 5 | -5 - 5 | 0 | five | 5 | -5 | 0 | - 5 | 0 | five | 5 | -5 | | - 5 | 0 | five | 5 | -5 | | 0 - 6 | 6 | six | 5 | -5 | 1 | -1 - 6 | 6 | six | 5 | -5 | 2 | 2 - 6 | 6 | six | 5 | -5 | 3 | -3 - 6 | 6 | six | 5 | -5 | 2 | 4 - 6 | 6 | six | 5 | -5 | 5 | -5 - 6 | 6 | six | 5 | -5 | 5 | -5 - 6 | 6 | six | 5 | -5 | 0 | - 6 | 6 | six | 5 | -5 | | - 6 | 6 | six | 5 | -5 | | 0 - 7 | 7 | seven | 5 | -5 | 1 | -1 - 7 | 7 | seven | 5 | -5 | 2 | 2 - 7 | 7 | seven | 5 | -5 | 3 | -3 - 7 | 7 | seven | 5 | -5 | 2 | 4 - 7 | 7 | seven | 5 | -5 | 5 | -5 - 7 | 7 | seven | 5 | -5 | 5 | -5 - 7 | 7 | seven | 5 | -5 | 0 | - 7 | 7 | seven | 5 | -5 | | - 7 | 7 | seven | 5 | -5 | | 0 - 8 | 8 | eight | 5 | -5 | 1 | -1 - 8 | 8 | eight | 5 | -5 | 2 | 2 - 8 | 8 | eight | 5 | -5 | 3 | -3 - 8 | 8 | eight | 5 | -5 | 2 | 4 - 8 | 8 | eight | 5 | -5 | 5 | -5 - 8 | 8 | eight | 5 | -5 | 5 | -5 - 8 | 8 | eight | 5 | -5 | 0 | - 8 | 8 | eight | 5 | -5 | | - 8 | 8 | eight | 5 | -5 | | 0 - 0 | | zero | 5 | -5 | 1 | -1 - 0 | | zero | 5 | -5 | 2 | 2 - 0 | | zero | 5 | -5 | 3 | -3 - 0 | | zero | 5 | -5 | 2 | 4 - 0 | | zero | 5 | -5 | 5 | -5 - 0 | | zero | 5 | -5 | 5 | -5 - 0 | | zero | 5 | -5 | 0 | - 0 | | zero | 5 | -5 | | - 0 | | zero | 5 | -5 | | 0 - | | null | 5 | -5 | 1 | -1 - | | null | 5 | -5 | 2 | 2 - | | null | 5 | -5 | 3 | -3 - | | null | 5 | -5 | 2 | 4 - | | null | 5 | -5 | 5 | -5 - | | null | 5 | -5 | 5 | -5 - | | null | 5 | -5 | 0 | - | | null | 5 | -5 | | - | | null | 5 | -5 | | 0 - | 0 | zero | 5 | -5 | 1 | -1 - | 0 | zero | 5 | -5 | 2 | 2 - | 0 | zero | 5 | -5 | 3 | -3 - | 0 | zero | 5 | -5 | 2 | 4 - | 0 | zero | 5 | -5 | 5 | -5 - | 0 | zero | 5 | -5 | 5 | -5 - | 0 | zero | 5 | -5 | 0 | - | 0 | zero | 5 | -5 | | - | 0 | zero | 5 | -5 | | 0 - 1 | 4 | one | 5 | -5 | 1 | -1 - 1 | 4 | one | 5 | -5 | 2 | 2 - 1 | 4 | one | 5 | -5 | 3 | -3 - 1 | 4 | one | 5 | -5 | 2 | 4 - 1 | 4 | one | 5 | -5 | 5 | -5 - 1 | 4 | one | 5 | -5 | 5 | -5 - 1 | 4 | one | 5 | -5 | 0 | - 1 | 4 | one | 5 | -5 | | - 1 | 4 | one | 5 | -5 | | 0 - 2 | 3 | two | 5 | -5 | 1 | -1 - 2 | 3 | two | 5 | -5 | 2 | 2 - 2 | 3 | two | 5 | -5 | 3 | -3 - 2 | 3 | two | 5 | -5 | 2 | 4 - 2 | 3 | two | 5 | -5 | 5 | -5 - 2 | 3 | two | 5 | -5 | 5 | -5 - 2 | 3 | two | 5 | -5 | 0 | - 2 | 3 | two | 5 | -5 | | - 2 | 3 | two | 5 | -5 | | 0 - 3 | 2 | three | 5 | -5 | 1 | -1 - 3 | 2 | three | 5 | -5 | 2 | 2 - 3 | 2 | three | 5 | -5 | 3 | -3 - 3 | 2 | three | 5 | -5 | 2 | 4 - 3 | 2 | three | 5 | -5 | 5 | -5 - 3 | 2 | three | 5 | -5 | 5 | -5 - 3 | 2 | three | 5 | -5 | 0 | - 3 | 2 | three | 5 | -5 | | - 3 | 2 | three | 5 | -5 | | 0 - 4 | 1 | four | 5 | -5 | 1 | -1 - 4 | 1 | four | 5 | -5 | 2 | 2 - 4 | 1 | four | 5 | -5 | 3 | -3 - 4 | 1 | four | 5 | -5 | 2 | 4 - 4 | 1 | four | 5 | -5 | 5 | -5 - 4 | 1 | four | 5 | -5 | 5 | -5 - 4 | 1 | four | 5 | -5 | 0 | - 4 | 1 | four | 5 | -5 | | - 4 | 1 | four | 5 | -5 | | 0 - 5 | 0 | five | 5 | -5 | 1 | -1 - 5 | 0 | five | 5 | -5 | 2 | 2 - 5 | 0 | five | 5 | -5 | 3 | -3 - 5 | 0 | five | 5 | -5 | 2 | 4 - 5 | 0 | five | 5 | -5 | 5 | -5 - 5 | 0 | five | 5 | -5 | 5 | -5 - 5 | 0 | five | 5 | -5 | 0 | - 5 | 0 | five | 5 | -5 | | - 5 | 0 | five | 5 | -5 | | 0 - 6 | 6 | six | 5 | -5 | 1 | -1 - 6 | 6 | six | 5 | -5 | 2 | 2 - 6 | 6 | six | 5 | -5 | 3 | -3 - 6 | 6 | six | 5 | -5 | 2 | 4 - 6 | 6 | six | 5 | -5 | 5 | -5 - 6 | 6 | six | 5 | -5 | 5 | -5 - 6 | 6 | six | 5 | -5 | 0 | - 6 | 6 | six | 5 | -5 | | - 6 | 6 | six | 5 | -5 | | 0 - 7 | 7 | seven | 5 | -5 | 1 | -1 - 7 | 7 | seven | 5 | -5 | 2 | 2 - 7 | 7 | seven | 5 | -5 | 3 | -3 - 7 | 7 | seven | 5 | -5 | 2 | 4 - 7 | 7 | seven | 5 | -5 | 5 | -5 - 7 | 7 | seven | 5 | -5 | 5 | -5 - 7 | 7 | seven | 5 | -5 | 0 | - 7 | 7 | seven | 5 | -5 | | - 7 | 7 | seven | 5 | -5 | | 0 - 8 | 8 | eight | 5 | -5 | 1 | -1 - 8 | 8 | eight | 5 | -5 | 2 | 2 - 8 | 8 | eight | 5 | -5 | 3 | -3 - 8 | 8 | eight | 5 | -5 | 2 | 4 - 8 | 8 | eight | 5 | -5 | 5 | -5 - 8 | 8 | eight | 5 | -5 | 5 | -5 - 8 | 8 | eight | 5 | -5 | 0 | - 8 | 8 | eight | 5 | -5 | | - 8 | 8 | eight | 5 | -5 | | 0 - 0 | | zero | 5 | -5 | 1 | -1 - 0 | | zero | 5 | -5 | 2 | 2 - 0 | | zero | 5 | -5 | 3 | -3 - 0 | | zero | 5 | -5 | 2 | 4 - 0 | | zero | 5 | -5 | 5 | -5 - 0 | | zero | 5 | -5 | 5 | -5 - 0 | | zero | 5 | -5 | 0 | - 0 | | zero | 5 | -5 | | - 0 | | zero | 5 | -5 | | 0 - | | null | 5 | -5 | 1 | -1 - | | null | 5 | -5 | 2 | 2 - | | null | 5 | -5 | 3 | -3 - | | null | 5 | -5 | 2 | 4 - | | null | 5 | -5 | 5 | -5 - | | null | 5 | -5 | 5 | -5 - | | null | 5 | -5 | 0 | - | | null | 5 | -5 | | - | | null | 5 | -5 | | 0 - | 0 | zero | 5 | -5 | 1 | -1 - | 0 | zero | 5 | -5 | 2 | 2 - | 0 | zero | 5 | -5 | 3 | -3 - | 0 | zero | 5 | -5 | 2 | 4 - | 0 | zero | 5 | -5 | 5 | -5 - | 0 | zero | 5 | -5 | 5 | -5 - | 0 | zero | 5 | -5 | 0 | - | 0 | zero | 5 | -5 | | - | 0 | zero | 5 | -5 | | 0 - 1 | 4 | one | 0 | | 1 | -1 - 1 | 4 | one | 0 | | 2 | 2 - 1 | 4 | one | 0 | | 3 | -3 - 1 | 4 | one | 0 | | 2 | 4 - 1 | 4 | one | 0 | | 5 | -5 - 1 | 4 | one | 0 | | 5 | -5 - 1 | 4 | one | 0 | | 0 | - 1 | 4 | one | 0 | | | - 1 | 4 | one | 0 | | | 0 - 2 | 3 | two | 0 | | 1 | -1 - 2 | 3 | two | 0 | | 2 | 2 - 2 | 3 | two | 0 | | 3 | -3 - 2 | 3 | two | 0 | | 2 | 4 - 2 | 3 | two | 0 | | 5 | -5 - 2 | 3 | two | 0 | | 5 | -5 - 2 | 3 | two | 0 | | 0 | - 2 | 3 | two | 0 | | | - 2 | 3 | two | 0 | | | 0 - 3 | 2 | three | 0 | | 1 | -1 - 3 | 2 | three | 0 | | 2 | 2 - 3 | 2 | three | 0 | | 3 | -3 - 3 | 2 | three | 0 | | 2 | 4 - 3 | 2 | three | 0 | | 5 | -5 - 3 | 2 | three | 0 | | 5 | -5 - 3 | 2 | three | 0 | | 0 | - 3 | 2 | three | 0 | | | - 3 | 2 | three | 0 | | | 0 - 4 | 1 | four | 0 | | 1 | -1 - 4 | 1 | four | 0 | | 2 | 2 - 4 | 1 | four | 0 | | 3 | -3 - 4 | 1 | four | 0 | | 2 | 4 - 4 | 1 | four | 0 | | 5 | -5 - 4 | 1 | four | 0 | | 5 | -5 - 4 | 1 | four | 0 | | 0 | - 4 | 1 | four | 0 | | | - 4 | 1 | four | 0 | | | 0 - 5 | 0 | five | 0 | | 1 | -1 - 5 | 0 | five | 0 | | 2 | 2 - 5 | 0 | five | 0 | | 3 | -3 - 5 | 0 | five | 0 | | 2 | 4 - 5 | 0 | five | 0 | | 5 | -5 - 5 | 0 | five | 0 | | 5 | -5 - 5 | 0 | five | 0 | | 0 | - 5 | 0 | five | 0 | | | - 5 | 0 | five | 0 | | | 0 - 6 | 6 | six | 0 | | 1 | -1 - 6 | 6 | six | 0 | | 2 | 2 - 6 | 6 | six | 0 | | 3 | -3 - 6 | 6 | six | 0 | | 2 | 4 - 6 | 6 | six | 0 | | 5 | -5 - 6 | 6 | six | 0 | | 5 | -5 - 6 | 6 | six | 0 | | 0 | - 6 | 6 | six | 0 | | | - 6 | 6 | six | 0 | | | 0 - 7 | 7 | seven | 0 | | 1 | -1 - 7 | 7 | seven | 0 | | 2 | 2 - 7 | 7 | seven | 0 | | 3 | -3 - 7 | 7 | seven | 0 | | 2 | 4 - 7 | 7 | seven | 0 | | 5 | -5 - 7 | 7 | seven | 0 | | 5 | -5 - 7 | 7 | seven | 0 | | 0 | - 7 | 7 | seven | 0 | | | - 7 | 7 | seven | 0 | | | 0 - 8 | 8 | eight | 0 | | 1 | -1 - 8 | 8 | eight | 0 | | 2 | 2 - 8 | 8 | eight | 0 | | 3 | -3 - 8 | 8 | eight | 0 | | 2 | 4 - 8 | 8 | eight | 0 | | 5 | -5 - 8 | 8 | eight | 0 | | 5 | -5 - 8 | 8 | eight | 0 | | 0 | - 8 | 8 | eight | 0 | | | - 8 | 8 | eight | 0 | | | 0 - 0 | | zero | 0 | | 1 | -1 - 0 | | zero | 0 | | 2 | 2 - 0 | | zero | 0 | | 3 | -3 - 0 | | zero | 0 | | 2 | 4 - 0 | | zero | 0 | | 5 | -5 - 0 | | zero | 0 | | 5 | -5 - 0 | | zero | 0 | | 0 | - 0 | | zero | 0 | | | - 0 | | zero | 0 | | | 0 - | | null | 0 | | 1 | -1 - | | null | 0 | | 2 | 2 - | | null | 0 | | 3 | -3 - | | null | 0 | | 2 | 4 - | | null | 0 | | 5 | -5 - | | null | 0 | | 5 | -5 - | | null | 0 | | 0 | - | | null | 0 | | | - | | null | 0 | | | 0 - | 0 | zero | 0 | | 1 | -1 - | 0 | zero | 0 | | 2 | 2 - | 0 | zero | 0 | | 3 | -3 - | 0 | zero | 0 | | 2 | 4 - | 0 | zero | 0 | | 5 | -5 - | 0 | zero | 0 | | 5 | -5 - | 0 | zero | 0 | | 0 | - | 0 | zero | 0 | | | - | 0 | zero | 0 | | | 0 - 1 | 4 | one | | | 1 | -1 - 1 | 4 | one | | | 2 | 2 - 1 | 4 | one | | | 3 | -3 - 1 | 4 | one | | | 2 | 4 - 1 | 4 | one | | | 5 | -5 - 1 | 4 | one | | | 5 | -5 - 1 | 4 | one | | | 0 | - 1 | 4 | one | | | | - 1 | 4 | one | | | | 0 - 2 | 3 | two | | | 1 | -1 - 2 | 3 | two | | | 2 | 2 - 2 | 3 | two | | | 3 | -3 - 2 | 3 | two | | | 2 | 4 - 2 | 3 | two | | | 5 | -5 - 2 | 3 | two | | | 5 | -5 - 2 | 3 | two | | | 0 | - 2 | 3 | two | | | | - 2 | 3 | two | | | | 0 - 3 | 2 | three | | | 1 | -1 - 3 | 2 | three | | | 2 | 2 - 3 | 2 | three | | | 3 | -3 - 3 | 2 | three | | | 2 | 4 - 3 | 2 | three | | | 5 | -5 - 3 | 2 | three | | | 5 | -5 - 3 | 2 | three | | | 0 | - 3 | 2 | three | | | | - 3 | 2 | three | | | | 0 - 4 | 1 | four | | | 1 | -1 - 4 | 1 | four | | | 2 | 2 - 4 | 1 | four | | | 3 | -3 - 4 | 1 | four | | | 2 | 4 - 4 | 1 | four | | | 5 | -5 - 4 | 1 | four | | | 5 | -5 - 4 | 1 | four | | | 0 | - 4 | 1 | four | | | | - 4 | 1 | four | | | | 0 - 5 | 0 | five | | | 1 | -1 - 5 | 0 | five | | | 2 | 2 - 5 | 0 | five | | | 3 | -3 - 5 | 0 | five | | | 2 | 4 - 5 | 0 | five | | | 5 | -5 - 5 | 0 | five | | | 5 | -5 - 5 | 0 | five | | | 0 | - 5 | 0 | five | | | | - 5 | 0 | five | | | | 0 - 6 | 6 | six | | | 1 | -1 - 6 | 6 | six | | | 2 | 2 - 6 | 6 | six | | | 3 | -3 - 6 | 6 | six | | | 2 | 4 - 6 | 6 | six | | | 5 | -5 - 6 | 6 | six | | | 5 | -5 - 6 | 6 | six | | | 0 | - 6 | 6 | six | | | | - 6 | 6 | six | | | | 0 - 7 | 7 | seven | | | 1 | -1 - 7 | 7 | seven | | | 2 | 2 - 7 | 7 | seven | | | 3 | -3 - 7 | 7 | seven | | | 2 | 4 - 7 | 7 | seven | | | 5 | -5 - 7 | 7 | seven | | | 5 | -5 - 7 | 7 | seven | | | 0 | - 7 | 7 | seven | | | | - 7 | 7 | seven | | | | 0 - 8 | 8 | eight | | | 1 | -1 - 8 | 8 | eight | | | 2 | 2 - 8 | 8 | eight | | | 3 | -3 - 8 | 8 | eight | | | 2 | 4 - 8 | 8 | eight | | | 5 | -5 - 8 | 8 | eight | | | 5 | -5 - 8 | 8 | eight | | | 0 | - 8 | 8 | eight | | | | - 8 | 8 | eight | | | | 0 - 0 | | zero | | | 1 | -1 - 0 | | zero | | | 2 | 2 - 0 | | zero | | | 3 | -3 - 0 | | zero | | | 2 | 4 - 0 | | zero | | | 5 | -5 - 0 | | zero | | | 5 | -5 - 0 | | zero | | | 0 | - 0 | | zero | | | | - 0 | | zero | | | | 0 - | | null | | | 1 | -1 - | | null | | | 2 | 2 - | | null | | | 3 | -3 - | | null | | | 2 | 4 - | | null | | | 5 | -5 - | | null | | | 5 | -5 - | | null | | | 0 | - | | null | | | | - | | null | | | | 0 - | 0 | zero | | | 1 | -1 - | 0 | zero | | | 2 | 2 - | 0 | zero | | | 3 | -3 - | 0 | zero | | | 2 | 4 - | 0 | zero | | | 5 | -5 - | 0 | zero | | | 5 | -5 - | 0 | zero | | | 0 | - | 0 | zero | | | | - | 0 | zero | | | | 0 - 1 | 4 | one | | 0 | 1 | -1 - 1 | 4 | one | | 0 | 2 | 2 - 1 | 4 | one | | 0 | 3 | -3 - 1 | 4 | one | | 0 | 2 | 4 - 1 | 4 | one | | 0 | 5 | -5 - 1 | 4 | one | | 0 | 5 | -5 - 1 | 4 | one | | 0 | 0 | - 1 | 4 | one | | 0 | | - 1 | 4 | one | | 0 | | 0 - 2 | 3 | two | | 0 | 1 | -1 - 2 | 3 | two | | 0 | 2 | 2 - 2 | 3 | two | | 0 | 3 | -3 - 2 | 3 | two | | 0 | 2 | 4 - 2 | 3 | two | | 0 | 5 | -5 - 2 | 3 | two | | 0 | 5 | -5 - 2 | 3 | two | | 0 | 0 | - 2 | 3 | two | | 0 | | - 2 | 3 | two | | 0 | | 0 - 3 | 2 | three | | 0 | 1 | -1 - 3 | 2 | three | | 0 | 2 | 2 - 3 | 2 | three | | 0 | 3 | -3 - 3 | 2 | three | | 0 | 2 | 4 - 3 | 2 | three | | 0 | 5 | -5 - 3 | 2 | three | | 0 | 5 | -5 - 3 | 2 | three | | 0 | 0 | - 3 | 2 | three | | 0 | | - 3 | 2 | three | | 0 | | 0 - 4 | 1 | four | | 0 | 1 | -1 - 4 | 1 | four | | 0 | 2 | 2 - 4 | 1 | four | | 0 | 3 | -3 - 4 | 1 | four | | 0 | 2 | 4 - 4 | 1 | four | | 0 | 5 | -5 - 4 | 1 | four | | 0 | 5 | -5 - 4 | 1 | four | | 0 | 0 | - 4 | 1 | four | | 0 | | - 4 | 1 | four | | 0 | | 0 - 5 | 0 | five | | 0 | 1 | -1 - 5 | 0 | five | | 0 | 2 | 2 - 5 | 0 | five | | 0 | 3 | -3 - 5 | 0 | five | | 0 | 2 | 4 - 5 | 0 | five | | 0 | 5 | -5 - 5 | 0 | five | | 0 | 5 | -5 - 5 | 0 | five | | 0 | 0 | - 5 | 0 | five | | 0 | | - 5 | 0 | five | | 0 | | 0 - 6 | 6 | six | | 0 | 1 | -1 - 6 | 6 | six | | 0 | 2 | 2 - 6 | 6 | six | | 0 | 3 | -3 - 6 | 6 | six | | 0 | 2 | 4 - 6 | 6 | six | | 0 | 5 | -5 - 6 | 6 | six | | 0 | 5 | -5 - 6 | 6 | six | | 0 | 0 | - 6 | 6 | six | | 0 | | - 6 | 6 | six | | 0 | | 0 - 7 | 7 | seven | | 0 | 1 | -1 - 7 | 7 | seven | | 0 | 2 | 2 - 7 | 7 | seven | | 0 | 3 | -3 - 7 | 7 | seven | | 0 | 2 | 4 - 7 | 7 | seven | | 0 | 5 | -5 - 7 | 7 | seven | | 0 | 5 | -5 - 7 | 7 | seven | | 0 | 0 | - 7 | 7 | seven | | 0 | | - 7 | 7 | seven | | 0 | | 0 - 8 | 8 | eight | | 0 | 1 | -1 - 8 | 8 | eight | | 0 | 2 | 2 - 8 | 8 | eight | | 0 | 3 | -3 - 8 | 8 | eight | | 0 | 2 | 4 - 8 | 8 | eight | | 0 | 5 | -5 - 8 | 8 | eight | | 0 | 5 | -5 - 8 | 8 | eight | | 0 | 0 | - 8 | 8 | eight | | 0 | | - 8 | 8 | eight | | 0 | | 0 - 0 | | zero | | 0 | 1 | -1 - 0 | | zero | | 0 | 2 | 2 - 0 | | zero | | 0 | 3 | -3 - 0 | | zero | | 0 | 2 | 4 - 0 | | zero | | 0 | 5 | -5 - 0 | | zero | | 0 | 5 | -5 - 0 | | zero | | 0 | 0 | - 0 | | zero | | 0 | | - 0 | | zero | | 0 | | 0 - | | null | | 0 | 1 | -1 - | | null | | 0 | 2 | 2 - | | null | | 0 | 3 | -3 - | | null | | 0 | 2 | 4 - | | null | | 0 | 5 | -5 - | | null | | 0 | 5 | -5 - | | null | | 0 | 0 | - | | null | | 0 | | - | | null | | 0 | | 0 - | 0 | zero | | 0 | 1 | -1 - | 0 | zero | | 0 | 2 | 2 - | 0 | zero | | 0 | 3 | -3 - | 0 | zero | | 0 | 2 | 4 - | 0 | zero | | 0 | 5 | -5 - | 0 | zero | | 0 | 5 | -5 - | 0 | zero | | 0 | 0 | - | 0 | zero | | 0 | | - | 0 | zero | | 0 | | 0 -(891 rows) - +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 -- -- -- Inner joins (equi-joins) diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/aggregates.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/aggregates.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/aggregates.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/aggregates.out 2023-05-12 03:31:07.149133148 +0300 @@ -2656,58 +2656,7 @@ group by unique1 having sum(fivethous) > 4975 order by sum(twothousand); - unique1 | count | sum ----------+-------+------ - 4976 | 1 | 976 - 4977 | 1 | 977 - 4978 | 1 | 978 - 4979 | 1 | 979 - 4980 | 1 | 980 - 4981 | 1 | 981 - 4982 | 1 | 982 - 4983 | 1 | 983 - 4984 | 1 | 984 - 4985 | 1 | 985 - 4986 | 1 | 986 - 4987 | 1 | 987 - 4988 | 1 | 988 - 4989 | 1 | 989 - 4990 | 1 | 990 - 4991 | 1 | 991 - 4992 | 1 | 992 - 4993 | 1 | 993 - 4994 | 1 | 994 - 4995 | 1 | 995 - 4996 | 1 | 996 - 4997 | 1 | 997 - 4998 | 1 | 998 - 4999 | 1 | 999 - 9976 | 1 | 1976 - 9977 | 1 | 1977 - 9978 | 1 | 1978 - 9979 | 1 | 1979 - 9980 | 1 | 1980 - 9981 | 1 | 1981 - 9982 | 1 | 1982 - 9983 | 1 | 1983 - 9984 | 1 | 1984 - 9985 | 1 | 1985 - 9986 | 1 | 1986 - 9987 | 1 | 1987 - 9988 | 1 | 1988 - 9989 | 1 | 1989 - 9990 | 1 | 1990 - 9991 | 1 | 1991 - 9992 | 1 | 1992 - 9993 | 1 | 1993 - 9994 | 1 | 1994 - 9995 | 1 | 1995 - 9996 | 1 | 1996 - 9997 | 1 | 1997 - 9998 | 1 | 1998 - 9999 | 1 | 1999 -(48 rows) - +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 set work_mem to default; set enable_sort to default; -- diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/btree_index.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/btree_index.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/btree_index.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/btree_index.out 2023-05-12 03:31:07.595799817 +0300 @@ -233,12 +233,7 @@ explain (costs off) select proname from pg_proc where proname ilike 'ri%foo' order by 1; - QUERY PLAN ------------------------------------------------------------------ - Index Only Scan using pg_proc_proname_args_nsp_index on pg_proc - Filter: (proname ~~* 'ri%foo'::text) -(2 rows) - +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 reset enable_seqscan; reset enable_indexscan; reset enable_bitmapscan; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/update.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/update.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/update.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/update.out 2023-05-12 03:31:07.135799814 +0300 @@ -434,6 +434,7 @@ 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" @@ -444,15 +445,17 @@ 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 diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/gin.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/gin.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/gin.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/gin.out 2023-05-12 03:31:08.372466490 +0300 @@ -185,20 +185,7 @@ 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; - query | return by index | removed by recheck | match --------------------------------------------+-----------------+--------------------+------- - 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) - +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 reset enable_seqscan; reset enable_bitmapscan; -- re-purpose t_gin_test_tbl to test scans involving posting trees diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/collate.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/collate.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/collate.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/collate.out 2023-05-12 03:31:07.945799820 +0300 @@ -623,8 +623,8 @@ CREATE TABLE collate_test22 (f2 text COLLATE "POSIX"); INSERT INTO collate_test22 VALUES ('foo'), ('bar'), ('baz'); ALTER TABLE collate_test22 ADD FOREIGN KEY (f2) REFERENCES collate_test20; -- fail -ERROR: insert or update on table "collate_test22" violates foreign key constraint "collate_test22_f2_fkey" -DETAIL: Key (f2)=(baz) is not present in table "collate_test20". +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: 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)" DELETE FROM collate_test22 WHERE f2 = 'baz'; ALTER TABLE collate_test22 ADD FOREIGN KEY (f2) REFERENCES collate_test20; RESET enable_seqscan; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/groupingsets.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/groupingsets.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/groupingsets.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/groupingsets.out 2023-05-12 03:31:08.029133154 +0300 @@ -305,11 +305,7 @@ -- empty input with joins tests some important code paths select t1.a, t2.b, sum(t1.v), count(*) from gstest_empty t1, gstest_empty t2 group by grouping sets ((t1.a,t2.b),()); - a | b | sum | count ----+---+-----+------- - | | | 0 -(1 row) - +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 -- simple joins, var resolution, GROUPING on join vars select t1.a, t2.b, grouping(t1.a, t2.b), sum(t1.v), max(t2.a) from gstest1 t1, gstest2 t2 diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/join_hash.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/join_hash.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/join_hash.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/join_hash.out 2023-05-12 03:31:08.585799825 +0300 @@ -569,29 +569,11 @@ 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; - QUERY PLAN ------------------------------------------------------------------------------------- - 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) - +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 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; - count -------- - 3 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select final > 1 as multibatch from hash_join_batches( $$ @@ -599,11 +581,7 @@ 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; $$); - multibatch ------------- - t -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback to settings; -- single-batch with rescan, parallel-oblivious savepoint settings; @@ -639,11 +617,8 @@ 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; - count -------- - 3 -(1 row) - +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 select final > 1 as multibatch from hash_join_batches( $$ @@ -651,11 +626,7 @@ 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; $$); - multibatch ------------- - f -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback to settings; -- multi-batch with rescan, parallel-aware savepoint settings; @@ -691,11 +662,8 @@ 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; - count -------- - 3 -(1 row) - +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 select final > 1 as multibatch from hash_join_batches( $$ @@ -703,11 +671,7 @@ 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; $$); - multibatch ------------- - t -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback to settings; -- single-batch with rescan, parallel-aware savepoint settings; @@ -743,11 +707,8 @@ 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; - count -------- - 3 -(1 row) - +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 select final > 1 as multibatch from hash_join_batches( $$ @@ -755,11 +716,7 @@ 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; $$); - multibatch ------------- - f -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback to settings; -- A full outer join where every record is matched. -- non-parallel diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/misc.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/misc.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/misc.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/misc.out 2023-05-12 03:31:09.252466497 +0300 @@ -188,14 +188,7 @@ -- SELECT DISTINCT hobbies_r.name, name(hobbies_r.equipment) FROM hobbies_r ORDER BY 1,2; - name | name --------------+--------------- - basketball | hightops - posthacking | advil - posthacking | peet's coffee - skywalking | guts -(4 rows) - +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 SELECT hobbies_r.name, (hobbies_r.equipment).name FROM hobbies_r; name | name -------------+--------------- diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/tidrangescan.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/tidrangescan.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/tidrangescan.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/tidrangescan.out 2023-05-12 03:31:09.195799829 +0300 @@ -35,6 +35,7 @@ -- page sizes. DELETE FROM tidrangescan WHERE substring(ctid::text FROM ',(\d+)\)')::integer > 10 OR substring(ctid::text FROM '\((\d+),')::integer > 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 VACUUM tidrangescan; -- range scans with upper bound EXPLAIN (COSTS OFF) @@ -58,7 +59,55 @@ (0,8) (0,9) (0,10) -(10 rows) + (0,11) + (0,12) + (0,13) + (0,14) + (0,15) + (0,16) + (0,17) + (0,18) + (0,19) + (0,20) + (0,21) + (0,22) + (0,23) + (0,24) + (0,25) + (0,26) + (0,27) + (0,28) + (0,29) + (0,30) + (0,31) + (0,32) + (0,33) + (0,34) + (0,35) + (0,36) + (0,37) + (0,38) + (0,39) + (0,40) + (0,41) + (0,42) + (0,43) + (0,44) + (0,45) + (0,46) + (0,47) + (0,48) + (0,49) + (0,50) + (0,51) + (0,52) + (0,53) + (0,54) + (0,55) + (0,56) + (0,57) + (0,58) +(58 rows) EXPLAIN (COSTS OFF) SELECT ctid FROM tidrangescan WHERE ctid <= '(1,5)'; @@ -81,12 +130,60 @@ (0,8) (0,9) (0,10) + (0,11) + (0,12) + (0,13) + (0,14) + (0,15) + (0,16) + (0,17) + (0,18) + (0,19) + (0,20) + (0,21) + (0,22) + (0,23) + (0,24) + (0,25) + (0,26) + (0,27) + (0,28) + (0,29) + (0,30) + (0,31) + (0,32) + (0,33) + (0,34) + (0,35) + (0,36) + (0,37) + (0,38) + (0,39) + (0,40) + (0,41) + (0,42) + (0,43) + (0,44) + (0,45) + (0,46) + (0,47) + (0,48) + (0,49) + (0,50) + (0,51) + (0,52) + (0,53) + (0,54) + (0,55) + (0,56) + (0,57) + (0,58) (1,1) (1,2) (1,3) (1,4) (1,5) -(15 rows) +(63 rows) EXPLAIN (COSTS OFF) SELECT ctid FROM tidrangescan WHERE ctid < '(0,0)'; @@ -115,7 +212,81 @@ -------- (2,9) (2,10) -(2 rows) + (2,11) + (2,12) + (2,13) + (2,14) + (2,15) + (2,16) + (2,17) + (2,18) + (2,19) + (2,20) + (2,21) + (2,22) + (2,23) + (2,24) + (2,25) + (2,26) + (2,27) + (2,28) + (2,29) + (2,30) + (2,31) + (2,32) + (2,33) + (2,34) + (2,35) + (2,36) + (2,37) + (2,38) + (2,39) + (2,40) + (2,41) + (2,42) + (2,43) + (2,44) + (2,45) + (2,46) + (2,47) + (2,48) + (2,49) + (2,50) + (2,51) + (2,52) + (2,53) + (2,54) + (2,55) + (2,56) + (2,57) + (2,58) + (3,1) + (3,2) + (3,3) + (3,4) + (3,5) + (3,6) + (3,7) + (3,8) + (3,9) + (3,10) + (3,11) + (3,12) + (3,13) + (3,14) + (3,15) + (3,16) + (3,17) + (3,18) + (3,19) + (3,20) + (3,21) + (3,22) + (3,23) + (3,24) + (3,25) + (3,26) +(76 rows) EXPLAIN (COSTS OFF) SELECT ctid FROM tidrangescan WHERE '(2,8)' < ctid; @@ -130,7 +301,81 @@ -------- (2,9) (2,10) -(2 rows) + (2,11) + (2,12) + (2,13) + (2,14) + (2,15) + (2,16) + (2,17) + (2,18) + (2,19) + (2,20) + (2,21) + (2,22) + (2,23) + (2,24) + (2,25) + (2,26) + (2,27) + (2,28) + (2,29) + (2,30) + (2,31) + (2,32) + (2,33) + (2,34) + (2,35) + (2,36) + (2,37) + (2,38) + (2,39) + (2,40) + (2,41) + (2,42) + (2,43) + (2,44) + (2,45) + (2,46) + (2,47) + (2,48) + (2,49) + (2,50) + (2,51) + (2,52) + (2,53) + (2,54) + (2,55) + (2,56) + (2,57) + (2,58) + (3,1) + (3,2) + (3,3) + (3,4) + (3,5) + (3,6) + (3,7) + (3,8) + (3,9) + (3,10) + (3,11) + (3,12) + (3,13) + (3,14) + (3,15) + (3,16) + (3,17) + (3,18) + (3,19) + (3,20) + (3,21) + (3,22) + (3,23) + (3,24) + (3,25) + (3,26) +(76 rows) EXPLAIN (COSTS OFF) SELECT ctid FROM tidrangescan WHERE ctid >= '(2,8)'; @@ -146,7 +391,81 @@ (2,8) (2,9) (2,10) -(3 rows) + (2,11) + (2,12) + (2,13) + (2,14) + (2,15) + (2,16) + (2,17) + (2,18) + (2,19) + (2,20) + (2,21) + (2,22) + (2,23) + (2,24) + (2,25) + (2,26) + (2,27) + (2,28) + (2,29) + (2,30) + (2,31) + (2,32) + (2,33) + (2,34) + (2,35) + (2,36) + (2,37) + (2,38) + (2,39) + (2,40) + (2,41) + (2,42) + (2,43) + (2,44) + (2,45) + (2,46) + (2,47) + (2,48) + (2,49) + (2,50) + (2,51) + (2,52) + (2,53) + (2,54) + (2,55) + (2,56) + (2,57) + (2,58) + (3,1) + (3,2) + (3,3) + (3,4) + (3,5) + (3,6) + (3,7) + (3,8) + (3,9) + (3,10) + (3,11) + (3,12) + (3,13) + (3,14) + (3,15) + (3,16) + (3,17) + (3,18) + (3,19) + (3,20) + (3,21) + (3,22) + (3,23) + (3,24) + (3,25) + (3,26) +(77 rows) EXPLAIN (COSTS OFF) SELECT ctid FROM tidrangescan WHERE ctid >= '(100,0)'; @@ -251,7 +570,55 @@ (0,8) | 8 (0,9) | 9 (0,10) | 10 -(10 rows) + (0,11) | 11 + (0,12) | 12 + (0,13) | 13 + (0,14) | 14 + (0,15) | 15 + (0,16) | 16 + (0,17) | 17 + (0,18) | 18 + (0,19) | 19 + (0,20) | 20 + (0,21) | 21 + (0,22) | 22 + (0,23) | 23 + (0,24) | 24 + (0,25) | 25 + (0,26) | 26 + (0,27) | 27 + (0,28) | 28 + (0,29) | 29 + (0,30) | 30 + (0,31) | 31 + (0,32) | 32 + (0,33) | 33 + (0,34) | 34 + (0,35) | 35 + (0,36) | 36 + (0,37) | 37 + (0,38) | 38 + (0,39) | 39 + (0,40) | 40 + (0,41) | 41 + (0,42) | 42 + (0,43) | 43 + (0,44) | 44 + (0,45) | 45 + (0,46) | 46 + (0,47) | 47 + (0,48) | 48 + (0,49) | 49 + (0,50) | 50 + (0,51) | 51 + (0,52) | 52 + (0,53) | 53 + (0,54) | 54 + (0,55) | 55 + (0,56) | 56 + (0,57) | 57 + (0,58) | 58 +(58 rows) -- cursors -- Ensure we get a TID Range scan without a Materialize node. @@ -292,7 +659,7 @@ FETCH LAST c; ctid -------- - (0,10) + (0,58) (1 row) COMMIT; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/incremental_sort.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/incremental_sort.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/incremental_sort.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/incremental_sort.out 2023-05-12 03:31:09.262466496 +0300 @@ -711,27 +711,9 @@ 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); - QUERY PLAN ------------------------------------------------- - 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) - +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 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); - a | b | a | b ----+---+---+--- - 1 | 1 | 1 | 1 - 2 | 2 | 2 | 2 -(2 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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'); diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/select_parallel.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/select_parallel.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/select_parallel.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/select_parallel.out 2023-05-12 03:31:10.445799839 +0300 @@ -137,431 +137,220 @@ explain (costs off) select (select max((select pa1.b from part_pa_test pa1 where pa1.a = pa2.a))) from part_pa_test pa2; - QUERY PLAN --------------------------------------------------------------- - 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) - +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 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'; - QUERY PLAN ---------------------------------------------------------- - Finalize Aggregate - -> Gather - Workers Planned: 4 - -> Partial Aggregate - -> Parallel Seq Scan on tenk1 - Filter: (stringu1 = 'GRAAAA'::name) -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 where stringu1 = 'GRAAAA'; - count -------- - 15 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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'; - QUERY PLAN ---------------------------------------------------------- - Finalize Aggregate - -> Gather - Workers Planned: 4 - -> Partial Aggregate - -> Parallel Seq Scan on tenk1 - Filter: (stringu1 = 'GRAAAA'::name) -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 where stringu1 = 'GRAAAA'; - count -------- - 15 -(1 row) - +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 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; - QUERY PLAN ---------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test parallel plan when group by expression is in target list. explain (costs off) select length(stringu1) from tenk1 group by length(stringu1); - QUERY PLAN ---------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select length(stringu1) from tenk1 group by length(stringu1); - length --------- - 6 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select stringu1, count(*) from tenk1 group by stringu1 order by stringu1; - QUERY PLAN ----------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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)); - QUERY PLAN -------------------------------------------------------------------- - HashAggregate - Group Key: sp_parallel_restricted(unique1) - -> Gather - Workers Planned: 4 - -> Parallel Index Only Scan using tenk1_unique1 on tenk1 -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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); - QUERY PLAN ----------------------------------------------- - Finalize Aggregate - -> Gather - Workers Planned: 4 - -> Partial Aggregate - -> Parallel Seq Scan on tenk1 - Filter: (hundred > 1) -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block execute tenk1_count(1); - count -------- - 9800 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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); - QUERY PLAN ------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 where (two, four) not in (select hundred, thousand from tenk2 where thousand > 100); - count -------- - 10000 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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); - QUERY PLAN ------------------------------------- - Seq Scan on tenk1 - Filter: (NOT (hashed SubPlan 1)) - SubPlan 1 - -> Seq Scan on tenk2 -(4 rows) - +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 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); - QUERY PLAN ------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 where tenk1.unique1 = (Select max(tenk2.unique1) from tenk2); - count -------- - 1 -(1 row) - +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 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; - QUERY PLAN --------------------------------------------------------------------- - Finalize Aggregate - -> Gather - Workers Planned: 4 - -> Partial Aggregate - -> Parallel Index Scan using tenk1_hundred on tenk1 - Index Cond: (hundred > 1) -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count((unique1)) from tenk1 where hundred > 1; - count -------- - 9800 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test parallel index-only scans. explain (costs off) select count(*) from tenk1 where thousand > 95; - QUERY PLAN --------------------------------------------------------------------------------- - Finalize Aggregate - -> Gather - Workers Planned: 4 - -> Partial Aggregate - -> Parallel Index Only Scan using tenk1_thous_tenthous on tenk1 - Index Cond: (thousand > 95) -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 where thousand > 95; - count -------- - 9040 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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; - QUERY PLAN --------------------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select * from (select count(unique1) from tenk1 where hundred > 10) ss right join (values (1),(2),(3)) v(x) on true; - count | x --------+--- - 8900 | 1 - 8900 | 2 - 8900 | 3 -(3 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select * from (select count(*) from tenk1 where thousand > 99) ss right join (values (1),(2),(3)) v(x) on true; - QUERY PLAN --------------------------------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select * from (select count(*) from tenk1 where thousand > 99) ss right join (values (1),(2),(3)) v(x) on true; - count | x --------+--- - 9000 | 1 - 9000 | 2 - 9000 | 3 -(3 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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; - QUERY PLAN ------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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; - count -------- - 1999 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block --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; - QUERY PLAN ------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1, tenk2 where tenk1.hundred > 1 and tenk2.thousand=0; - count -------- - 98000 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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; - count -------- - 99999 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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; - QUERY PLAN --------------------------------------------------------------------------- - 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) - +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 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 $$ @@ -578,99 +367,45 @@ end loop; end; $$; +ERROR: current transaction is aborted, commands ignored until end of transaction block select * from explain_parallel_sort_stats(); - explain_parallel_sort_stats --------------------------------------------------------------------------- - 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) - +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 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; - QUERY PLAN -------------------------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1, tenk2 where tenk1.unique1 = tenk2.unique1; - count -------- - 10000 -(1 row) - +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_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; - QUERY PLAN ----------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 group by twenty; - count -------- - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 -(20 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block --test expressions in targetlist are pushed down for gather merge create function sp_simple_func(var1 integer) returns integer as $$ @@ -678,279 +413,89 @@ 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; - QUERY PLAN ------------------------------------------------------ - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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; - QUERY PLAN ----------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*), generate_series(1,2) from tenk1 group by twenty; - count | generate_series --------+----------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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; - QUERY PLAN ----------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 group by twenty; - count -------- - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 -(20 rows) - +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 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; - QUERY PLAN ----------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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; - string4 | count | x ----------+-------+--- - 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) - +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_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; - QUERY PLAN -------------------------------------------------------------------------- - Finalize Aggregate - -> Gather - Workers Planned: 4 - -> Partial Aggregate - -> Parallel Index Only Scan using tenk1_unique1 on tenk1 -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select avg(unique1::int8) from tenk1; - avg ------------------------ - 4999.5000000000000000 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- gather merge test with a LIMIT explain (costs off) select fivethous from tenk1 order by fivethous limit 4; - QUERY PLAN ----------------------------------------------- - Limit - -> Gather Merge - Workers Planned: 4 - -> Sort - Sort Key: fivethous - -> Parallel Seq Scan on tenk1 -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select fivethous from tenk1 order by fivethous limit 4; - fivethous ------------ - 0 - 0 - 1 - 1 -(4 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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; - QUERY PLAN ----------------------------------------------- - Limit - -> Gather Merge - Workers Planned: 4 - -> Sort - Sort Key: string4 - -> Parallel Seq Scan on tenk1 -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select string4 from tenk1 order by string4 limit 5; - string4 ---------- - AAAAxx - AAAAxx - AAAAxx - AAAAxx - AAAAxx -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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; - QUERY PLAN ----------------------------------------------- - Limit - -> Gather Merge - Workers Planned: 4 - -> Sort - Sort Key: string4 - -> Parallel Seq Scan on tenk1 -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select string4 from tenk1 order by string4 limit 5; - string4 ---------- - AAAAxx - AAAAxx - AAAAxx - AAAAxx - AAAAxx -(5 rows) - +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 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; - QUERY PLAN ------------------------------------------------ - Gather - Workers Planned: 1 - Single Copy: true - -> Index Scan using tenk1_unique1 on tenk1 - Index Cond: (unique1 = 1) -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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 @@ -965,123 +510,79 @@ 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; - make_record -------------- - (1) - (1,2) - (1,2,3) - (1,2,3,4) - (1,2,3,4,5) -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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; -NOTICE: role "regress_parallel_worker" does not exist, skipping +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; - count -------- - 10000 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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); - QUERY PLAN ----------------------------------------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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); - QUERY PLAN ---------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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; - QUERY PLAN -------------------------------------------------------------- - Gather (actual rows=10000 loops=1) - Workers Planned: 4 - Workers Launched: 4 - -> Parallel Seq Scan on tenk1 (actual rows=2000 loops=5) -(4 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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: invalid input syntax for type smallint: "BAAAAAabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcd" -CONTEXT: parallel worker +ERROR: current transaction is aborted, commands ignored until end of transaction block 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; - QUERY PLAN ----------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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 = @@ -1090,89 +591,21 @@ SELECT unique1 FROM tenk1 WHERE fivethous = (SELECT unique2 FROM tenk1 WHERE fivethous = 1 LIMIT 1) ORDER BY 1; - QUERY PLAN --------------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test interaction with SRFs SELECT * FROM information_schema.foreign_data_wrapper_options ORDER BY 1, 2, 3; - foreign_data_wrapper_catalog | foreign_data_wrapper_name | option_name | option_value -------------------------------+---------------------------+-------------+-------------- -(0 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block EXPLAIN (VERBOSE, COSTS OFF) SELECT generate_series(1, two), array(select generate_series(1, two)) FROM tenk1 ORDER BY tenthous; - QUERY PLAN ----------------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- 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; - QUERY PLAN ------------------------------------------------------------------------------------------------------ - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test passing expanded-value representations to workers CREATE FUNCTION make_some_array(int,int) returns int[] as $$declare x int[]; @@ -1181,41 +614,24 @@ 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)); - QUERY PLAN ------------------------------------------------------------------- - Gather - Workers Planned: 3 - -> Parallel Seq Scan on fooarr - Filter: ((f1 = '1'::text) AND (f2 = '{1,2}'::integer[])) -(4 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block EXECUTE pstmt('1', make_some_array(1,2)); - f1 | f2 | f3 -----+-------+----- - 1 | {1,2} | one -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block 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; - QUERY PLAN -------------------------------------------------------------------- - 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) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/publication.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/publication.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/publication.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/publication.out 2023-05-12 03:31:10.909133176 +0300 @@ -1655,11 +1655,7 @@ -- Schema publication that does not include the schema that has the parent table CREATE PUBLICATION pub FOR TABLES IN SCHEMA sch2 WITH (PUBLISH_VIA_PARTITION_ROOT=1); SELECT * FROM pg_publication_tables; - pubname | schemaname | tablename | attnames | rowfilter ----------+------------+------------+----------+----------- - pub | sch2 | tbl1_part1 | {a} | -(1 row) - +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 DROP PUBLICATION pub; -- Table publication that does not include the parent table CREATE PUBLICATION pub FOR TABLE sch2.tbl1_part1 WITH (PUBLISH_VIA_PARTITION_ROOT=1); diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/tsearch.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/tsearch.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/tsearch.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/tsearch.out 2023-05-12 03:31:11.175799844 +0300 @@ -265,11 +265,7 @@ (1 row) SELECT count(*) FROM test_tsvector WHERE a @@ any ('{wr,qh}'); - count -------- - 158 -(1 row) - +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 SELECT count(*) FROM test_tsvector WHERE a @@ 'no_such_lexeme'; count ------- diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/rangefuncs.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/rangefuncs.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/rangefuncs.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/rangefuncs.out 2023-05-12 03:31:12.139133185 +0300 @@ -1404,18 +1404,7 @@ ) AS ss1 ON TRUE FULL JOIN generate_series(1, v1.r1) AS gs4 ON FALSE ) AS ss0 ON TRUE; - r1 | gs1 | gs2 | gs3 | gs4 -----+-----+-----+-----+----- - 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) - +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 DROP FUNCTION rngfunc_sql(int,int); DROP FUNCTION rngfunc_mat(int,int); DROP SEQUENCE rngfunc_rescan_seq1; diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/with.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/with.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/with.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/with.out 2023-05-12 03:31:12.115799851 +0300 @@ -496,42 +496,7 @@ select * from x) ) select * from q limit 32; - id | parent_department | name -----+-------------------+------ - 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) - +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 -- recursive term has sub-UNION WITH RECURSIVE t(i,j) AS ( VALUES (1,2) diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/partition_prune.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/partition_prune.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/partition_prune.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/partition_prune.out 2023-05-12 03:31:13.559133196 +0300 @@ -2774,25 +2774,7 @@ set enable_mergejoin = off; explain (analyze, costs off, summary off, timing off) select * from tbl1 join tprt on tbl1.col1 > tprt.col1; - QUERY PLAN --------------------------------------------------------------------------- - 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) - +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 explain (analyze, costs off, summary off, timing off) select * from tbl1 join tprt on tbl1.col1 = tprt.col1; QUERY PLAN diff -U3 /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/memoize.out /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/memoize.out --- /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/expected/memoize.out 2023-05-09 00:13:20.000000000 +0300 +++ /var/tmp/portage/dev-db/postgresql-15.3/work/postgresql-15.3/src/test/regress/results/memoize.out 2023-05-12 03:31:13.102466525 +0300 @@ -171,18 +171,8 @@ -- 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); - explain_memoize ----------------------------------------------------------------------------------- - 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) - +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 -- 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);