Go to:
Gentoo Home
Documentation
Forums
Lists
Bugs
Planet
Store
Wiki
Get Gentoo!
Gentoo's Bugzilla – Attachment 861545 Details for
Bug 906172
dev-db/postgresql-15.3 test fails to load llvmjit.so
Home
|
New
–
[Ex]
|
Browse
|
Search
|
Privacy Policy
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
The differences that caused some tests to fail can be viewed in the file
postgresql-15.3__src__test__regress__regression.diffs (text/plain), 169.59 KB, created by
Aleksey
on 2023-05-12 01:10:26 UTC
(
hide
)
Description:
The differences that caused some tests to fail can be viewed in the file
Filename:
MIME Type:
Creator:
Aleksey
Created:
2023-05-12 01:10:26 UTC
Size:
169.59 KB
patch
obsolete
>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);
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=861545">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 906172
: 861545 |
861546
|
861547
