1Parsed test spec with 2 sessions 2 3starting permutation: s1_insert_p s1_insert_c s2_insert_c s1_select_p s1_select_c s2_select_p s2_select_c 4step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 5step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 6step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 7step s1_select_p: SELECT a FROM inh_parent; 8a 9- 101 112 123 134 14(4 rows) 15 16step s1_select_c: SELECT a FROM inh_temp_child_s1; 17a 18- 193 204 21(2 rows) 22 23step s2_select_p: SELECT a FROM inh_parent; 24a 25- 261 272 285 296 30(4 rows) 31 32step s2_select_c: SELECT a FROM inh_temp_child_s2; 33a 34- 355 366 37(2 rows) 38 39 40starting permutation: s1_insert_p s1_insert_c s2_insert_c s1_update_p s1_update_c s1_select_p s1_select_c s2_select_p s2_select_c 41step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 42step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 43step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 44step s1_update_p: UPDATE inh_parent SET a = 11 WHERE a = 1; 45step s1_update_c: UPDATE inh_parent SET a = 13 WHERE a IN (3, 5); 46step s1_select_p: SELECT a FROM inh_parent; 47 a 48-- 49 2 5011 51 4 5213 53(4 rows) 54 55step s1_select_c: SELECT a FROM inh_temp_child_s1; 56 a 57-- 58 4 5913 60(2 rows) 61 62step s2_select_p: SELECT a FROM inh_parent; 63 a 64-- 65 2 6611 67 5 68 6 69(4 rows) 70 71step s2_select_c: SELECT a FROM inh_temp_child_s2; 72a 73- 745 756 76(2 rows) 77 78 79starting permutation: s1_insert_p s1_insert_c s2_insert_c s2_update_c s1_select_p s1_select_c s2_select_p s2_select_c 80step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 81step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 82step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 83step s2_update_c: UPDATE inh_parent SET a = 15 WHERE a IN (3, 5); 84step s1_select_p: SELECT a FROM inh_parent; 85a 86- 871 882 893 904 91(4 rows) 92 93step s1_select_c: SELECT a FROM inh_temp_child_s1; 94a 95- 963 974 98(2 rows) 99 100step s2_select_p: SELECT a FROM inh_parent; 101 a 102-- 103 1 104 2 105 6 10615 107(4 rows) 108 109step s2_select_c: SELECT a FROM inh_temp_child_s2; 110 a 111-- 112 6 11315 114(2 rows) 115 116 117starting permutation: s1_insert_p s1_insert_c s2_insert_c s1_delete_p s1_delete_c s1_select_p s1_select_c s2_select_p s2_select_c 118step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 119step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 120step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 121step s1_delete_p: DELETE FROM inh_parent WHERE a = 2; 122step s1_delete_c: DELETE FROM inh_parent WHERE a IN (4, 6); 123step s1_select_p: SELECT a FROM inh_parent; 124a 125- 1261 1273 128(2 rows) 129 130step s1_select_c: SELECT a FROM inh_temp_child_s1; 131a 132- 1333 134(1 row) 135 136step s2_select_p: SELECT a FROM inh_parent; 137a 138- 1391 1405 1416 142(3 rows) 143 144step s2_select_c: SELECT a FROM inh_temp_child_s2; 145a 146- 1475 1486 149(2 rows) 150 151 152starting permutation: s1_insert_p s1_insert_c s2_insert_c s2_delete_c s1_select_p s1_select_c s2_select_p s2_select_c 153step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 154step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 155step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 156step s2_delete_c: DELETE FROM inh_parent WHERE a IN (4, 6); 157step s1_select_p: SELECT a FROM inh_parent; 158a 159- 1601 1612 1623 1634 164(4 rows) 165 166step s1_select_c: SELECT a FROM inh_temp_child_s1; 167a 168- 1693 1704 171(2 rows) 172 173step s2_select_p: SELECT a FROM inh_parent; 174a 175- 1761 1772 1785 179(3 rows) 180 181step s2_select_c: SELECT a FROM inh_temp_child_s2; 182a 183- 1845 185(1 row) 186 187 188starting 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 189step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 190step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 191step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 192step s1_truncate_p: TRUNCATE inh_parent; 193step s1_select_p: SELECT a FROM inh_parent; 194a 195- 196(0 rows) 197 198step s1_select_c: SELECT a FROM inh_temp_child_s1; 199a 200- 201(0 rows) 202 203step s2_select_p: SELECT a FROM inh_parent; 204a 205- 2065 2076 208(2 rows) 209 210step s2_select_c: SELECT a FROM inh_temp_child_s2; 211a 212- 2135 2146 215(2 rows) 216 217 218starting permutation: s1_insert_p s1_insert_c s2_insert_c s2_truncate_p s1_select_p s1_select_c s2_select_p s2_select_c 219step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 220step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 221step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 222step s2_truncate_p: TRUNCATE inh_parent; 223step s1_select_p: SELECT a FROM inh_parent; 224a 225- 2263 2274 228(2 rows) 229 230step s1_select_c: SELECT a FROM inh_temp_child_s1; 231a 232- 2333 2344 235(2 rows) 236 237step s2_select_p: SELECT a FROM inh_parent; 238a 239- 240(0 rows) 241 242step s2_select_c: SELECT a FROM inh_temp_child_s2; 243a 244- 245(0 rows) 246 247 248starting permutation: s1_insert_p s1_insert_c s2_insert_c s1_begin s1_truncate_p s2_select_p s1_commit 249step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 250step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 251step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 252step s1_begin: BEGIN; 253step s1_truncate_p: TRUNCATE inh_parent; 254step s2_select_p: SELECT a FROM inh_parent; <waiting ...> 255step s1_commit: COMMIT; 256step s2_select_p: <... completed> 257a 258- 2595 2606 261(2 rows) 262 263 264starting permutation: s1_insert_p s1_insert_c s2_insert_c s1_begin s1_truncate_p s2_select_c s1_commit 265step s1_insert_p: INSERT INTO inh_parent VALUES (1), (2); 266step s1_insert_c: INSERT INTO inh_temp_child_s1 VALUES (3), (4); 267step s2_insert_c: INSERT INTO inh_temp_child_s2 VALUES (5), (6); 268step s1_begin: BEGIN; 269step s1_truncate_p: TRUNCATE inh_parent; 270step s2_select_c: SELECT a FROM inh_temp_child_s2; 271a 272- 2735 2746 275(2 rows) 276 277step s1_commit: COMMIT; 278