diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/inherit-temp.out /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/inherit-temp.out --- /tmp/cirrus-ci-build/src/test/isolation/expected/inherit-temp.out 2024-11-23 23:59:05.755920613 +0000 +++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/inherit-temp.out 2024-11-24 00:01:21.883045405 +0000 @@ -5,14 +5,7 @@ step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s1_select_p: SELECT a FROM inh_parent; -a -- -1 -2 -3 -4 -(4 rows) - +ERROR: cannot access temporary tables of other sessions step s1_select_c: SELECT a FROM inh_temp_child_s1; a - @@ -21,14 +14,7 @@ (2 rows) step s2_select_p: SELECT a FROM inh_parent; -a -- -1 -2 -5 -6 -(4 rows) - +ERROR: cannot access temporary tables of other sessions step s2_select_c: SELECT a FROM inh_temp_child_s2; a - @@ -42,32 +28,20 @@ step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s1_update_p: UPDATE inh_parent SET a = 11 WHERE a = 1; +ERROR: cannot access temporary tables of other sessions step s1_update_c: UPDATE inh_parent SET a = 13 WHERE a IN (3, 5); +ERROR: cannot access temporary tables of other sessions step s1_select_p: SELECT a FROM inh_parent; - a --- - 2 -11 - 4 -13 -(4 rows) - +ERROR: cannot access temporary tables of other sessions step s1_select_c: SELECT a FROM inh_temp_child_s1; - a --- - 4 -13 +a +- +3 +4 (2 rows) step s2_select_p: SELECT a FROM inh_parent; - a --- - 2 -11 - 5 - 6 -(4 rows) - +ERROR: cannot access temporary tables of other sessions step s2_select_c: SELECT a FROM inh_temp_child_s2; a - @@ -81,15 +55,9 @@ step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s2_update_c: UPDATE inh_parent SET a = 15 WHERE a IN (3, 5); +ERROR: cannot access temporary tables of other sessions step s1_select_p: SELECT a FROM inh_parent; -a -- -1 -2 -3 -4 -(4 rows) - +ERROR: cannot access temporary tables of other sessions step s1_select_c: SELECT a FROM inh_temp_child_s1; a - @@ -98,19 +66,12 @@ (2 rows) step s2_select_p: SELECT a FROM inh_parent; - a --- - 1 - 2 - 6 -15 -(4 rows) - +ERROR: cannot access temporary tables of other sessions step s2_select_c: SELECT a FROM inh_temp_child_s2; - a --- - 6 -15 +a +- +5 +6 (2 rows) @@ -119,28 +80,20 @@ step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s1_delete_p: DELETE FROM inh_parent WHERE a = 2; +ERROR: cannot access temporary tables of other sessions step s1_delete_c: DELETE FROM inh_parent WHERE a IN (4, 6); +ERROR: cannot access temporary tables of other sessions step s1_select_p: SELECT a FROM inh_parent; -a -- -1 -3 -(2 rows) - +ERROR: cannot access temporary tables of other sessions step s1_select_c: SELECT a FROM inh_temp_child_s1; a - 3 -(1 row) +4 +(2 rows) step s2_select_p: SELECT a FROM inh_parent; -a -- -1 -5 -6 -(3 rows) - +ERROR: cannot access temporary tables of other sessions step s2_select_c: SELECT a FROM inh_temp_child_s2; a - @@ -154,15 +107,9 @@ step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s2_delete_c: DELETE FROM inh_parent WHERE a IN (4, 6); +ERROR: cannot access temporary tables of other sessions step s1_select_p: SELECT a FROM inh_parent; -a -- -1 -2 -3 -4 -(4 rows) - +ERROR: cannot access temporary tables of other sessions step s1_select_c: SELECT a FROM inh_temp_child_s1; a - @@ -171,18 +118,13 @@ (2 rows) step s2_select_p: SELECT a FROM inh_parent; -a -- -1 -2 -5 -(3 rows) - +ERROR: cannot access temporary tables of other sessions step s2_select_c: SELECT a FROM inh_temp_child_s2; a - 5 -(1 row) +6 +(2 rows) starting permutation: s1_insert_p s1_insert_c s2_insert_c s1_truncate_p s1_select_p s1_select_c s2_select_p s2_select_c @@ -190,23 +132,18 @@ step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s1_truncate_p: TRUNCATE inh_parent; +ERROR: cannot access temporary tables of other sessions step s1_select_p: SELECT a FROM inh_parent; -a -- -(0 rows) - +ERROR: cannot access temporary tables of other sessions step s1_select_c: SELECT a FROM inh_temp_child_s1; a - -(0 rows) - -step s2_select_p: SELECT a FROM inh_parent; -a -- -5 -6 +3 +4 (2 rows) +step s2_select_p: SELECT a FROM inh_parent; +ERROR: cannot access temporary tables of other sessions step s2_select_c: SELECT a FROM inh_temp_child_s2; a - @@ -220,13 +157,9 @@ step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s2_truncate_p: TRUNCATE inh_parent; +ERROR: cannot access temporary tables of other sessions step s1_select_p: SELECT a FROM inh_parent; -a -- -3 -4 -(2 rows) - +ERROR: cannot access temporary tables of other sessions step s1_select_c: SELECT a FROM inh_temp_child_s1; a - @@ -235,14 +168,13 @@ (2 rows) step s2_select_p: SELECT a FROM inh_parent; -a -- -(0 rows) - +ERROR: cannot access temporary tables of other sessions step s2_select_c: SELECT a FROM inh_temp_child_s2; a - -(0 rows) +5 +6 +(2 rows) starting permutation: s1_insert_p s1_insert_c s2_insert_c s1_begin s1_truncate_p s2_select_p s1_commit @@ -251,15 +183,10 @@ step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s1_begin: BEGIN; step s1_truncate_p: TRUNCATE inh_parent; -step s2_select_p: SELECT a FROM inh_parent; +ERROR: cannot access temporary tables of other sessions +step s2_select_p: SELECT a FROM inh_parent; +ERROR: cannot access temporary tables of other sessions step s1_commit: COMMIT; -step s2_select_p: <... completed> -a -- -5 -6 -(2 rows) - starting permutation: s1_insert_p s1_insert_c s2_insert_c s1_begin s1_truncate_p s2_select_c s1_commit step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); @@ -267,6 +194,7 @@ step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); step s1_begin: BEGIN; step s1_truncate_p: TRUNCATE inh_parent; +ERROR: cannot access temporary tables of other sessions step s2_select_c: SELECT a FROM inh_temp_child_s2; a -