diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/queryid.out /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/queryid.out --- /tmp/cirrus-ci-build/src/test/isolation/expected/queryid.out 2024-09-09 12:18:31.973939371 +0000 +++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/queryid.out 2024-09-09 12:22:22.205396044 +0000 @@ -1 +1,62 @@ Parsed test spec with 2 sessions + +starting permutation: s1_begin s1_trivial s2_get_qqid1 s2_check_res1 s1_prepare s2_get_qqid2 s2_check_res2 s2_cmp_r1r2 s2_resdrop s1_probe1 s2_get_qqid1 s2_check_res1 s1_probe2 s2_get_qqid2 s2_check_res2 s2_cmp_r1r2 +step s1_begin: SET compute_query_id = 'on'; +step s1_trivial: /* queryid test */ SELECT relname FROM pg_class WHERE oid < 1; +relname +------- +(0 rows) + +step s2_get_qqid1: SELECT query_id INTO res1 FROM pg_stat_activity WHERE query LIKE '/* queryid test */%'; +step s2_check_res1: SELECT query_id <> 0 FROM res1; +?column? +-------- +t +(1 row) + +step s1_prepare: /* queryid test */ PREPARE probe (int) AS SELECT * FROM test_queryid t1 JOIN test_queryid t2 USING (x) WHERE t1.x = $1 AND t2.x = 2; +step s2_get_qqid2: SELECT query_id INTO res2 FROM pg_stat_activity WHERE query LIKE '/* queryid test */%'; +step s2_check_res2: SELECT query_id <> 0 FROM res2; +?column? +-------- +t +(1 row) + +step s2_cmp_r1r2: SELECT (SELECT query_id FROM res1) <> (SELECT query_id FROM res2); +?column? +-------- +t +(1 row) + +step s2_resdrop: DROP TABLE IF EXISTS res1,res2; +step s1_probe1: /* queryid test */ EXECUTE probe(1); +x +- +(0 rows) + +step s2_get_qqid1: SELECT query_id INTO res1 FROM pg_stat_activity WHERE query LIKE '/* queryid test */%'; +step s2_check_res1: SELECT query_id <> 0 FROM res1; +?column? +-------- +t +(1 row) + +step s1_probe2: /* queryid test */ EXECUTE probe(2); +x +- +2 +(1 row) + +step s2_get_qqid2: SELECT query_id INTO res2 FROM pg_stat_activity WHERE query LIKE '/* queryid test */%'; +step s2_check_res2: SELECT query_id <> 0 FROM res2; +?column? +-------- +t +(1 row) + +step s2_cmp_r1r2: SELECT (SELECT query_id FROM res1) <> (SELECT query_id FROM res2); +?column? +-------- +t +(1 row) +