You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: expected/insert_trigger.out
+7-7Lines changed: 7 additions & 7 deletions
Original file line number
Diff line number
Diff line change
@@ -7,15 +7,15 @@ create_range_partitions
7
7
step s1b: BEGIN;
8
8
step s1_insert_150: INSERT INTO range_rel SELECT generate_series(1, 150);
9
9
step s1r: ROLLBACK;
10
-
step s1_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.consrc;
10
+
step s1_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.oid;
11
11
consrc
12
12
13
13
((id >= 1) AND (id < 101))
14
14
((id >= 101) AND (id < 201))
15
15
step s2b: BEGIN;
16
16
step s2_insert_150: INSERT INTO range_rel SELECT generate_series(1, 150);
17
17
step s2c: COMMIT;
18
-
step s2_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.consrc;
18
+
step s2_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.oid;
19
19
consrc
20
20
21
21
((id >= 1) AND (id < 101))
@@ -28,15 +28,15 @@ create_range_partitions
28
28
step s1b: BEGIN;
29
29
step s1_insert_150: INSERT INTO range_rel SELECT generate_series(1, 150);
30
30
step s1r: ROLLBACK;
31
-
step s1_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.consrc;
31
+
step s1_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.oid;
32
32
consrc
33
33
34
34
((id >= 1) AND (id < 101))
35
35
((id >= 101) AND (id < 201))
36
36
step s2b: BEGIN;
37
37
step s2_insert_300: INSERT INTO range_rel SELECT generate_series(151, 300);
38
38
step s2c: COMMIT;
39
-
step s2_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.consrc;
39
+
step s2_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.oid;
40
40
consrc
41
41
42
42
((id >= 1) AND (id < 101))
@@ -50,7 +50,7 @@ create_range_partitions
50
50
step s1b: BEGIN;
51
51
step s1_insert_300: INSERT INTO range_rel SELECT generate_series(151, 300);
52
52
step s1r: ROLLBACK;
53
-
step s1_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.consrc;
53
+
step s1_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.oid;
54
54
consrc
55
55
56
56
((id >= 1) AND (id < 101))
@@ -59,7 +59,7 @@ consrc
59
59
step s2b: BEGIN;
60
60
step s2_insert_150: INSERT INTO range_rel SELECT generate_series(1, 150);
61
61
step s2c: COMMIT;
62
-
step s2_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.consrc;
62
+
step s2_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.oid;
63
63
consrc
64
64
65
65
((id >= 1) AND (id < 101))
@@ -76,7 +76,7 @@ step s2b: BEGIN;
76
76
step s2_insert_300: INSERT INTO range_rel SELECT generate_series(151, 300);
77
77
step s1r: ROLLBACK;
78
78
step s2r: ROLLBACK;
79
-
step s2_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.consrc;
79
+
step s2_show_partitions: SELECT c.consrc FROM pg_inherits i LEFT JOIN pg_constraint c ON c.conrelid = i.inhrelid AND c.consrc IS NOT NULL WHERE i.inhparent = 'range_rel'::regclass::oid ORDER BY c.oid;