Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit3a68105

Browse files
committed
Disable one more set of tests fromc884119.
Discussion:https://postgr.es/m/20191004222437.45qmglpto43pd3jb@alap3.anarazel.deBackpatch: 9.6-, just likec884119 and6e61d75
1 parent6e61d75 commit3a68105

File tree

2 files changed

+15
-177
lines changed

2 files changed

+15
-177
lines changed

‎src/test/isolation/expected/eval-plan-qual-trigger.out

Lines changed: 4 additions & 166 deletions
Original file line numberDiff line numberDiff line change
@@ -1888,172 +1888,6 @@ key data
18881888

18891889
key-c val-c-s1
18901890

1891-
starting permutation: s1_trig_rep_b_u s1_trig_rep_a_u s1_ins_a s1_ins_b s1_b_rc s2_b_rc s3_b_rc s1_upd_a_data s2_upd_a_data s3_upd_a_data s1_c s2_c s3_c s0_rep
1892-
step s1_trig_rep_b_u: CREATE TRIGGER rep_b_u BEFORE UPDATE ON trigtest FOR EACH ROW EXECUTE PROCEDURE trig_report();
1893-
step s1_trig_rep_a_u: CREATE TRIGGER rep_a_u AFTER UPDATE ON trigtest FOR EACH ROW EXECUTE PROCEDURE trig_report();
1894-
step s1_ins_a: INSERT INTO trigtest VALUES ('key-a', 'val-a-s1') RETURNING *;
1895-
key data
1896-
1897-
key-a val-a-s1
1898-
step s1_ins_b: INSERT INTO trigtest VALUES ('key-b', 'val-b-s1') RETURNING *;
1899-
key data
1900-
1901-
key-b val-b-s1
1902-
step s1_b_rc: BEGIN ISOLATION LEVEL READ COMMITTED; SELECT 1;
1903-
?column?
1904-
1905-
1
1906-
step s2_b_rc: BEGIN ISOLATION LEVEL READ COMMITTED; SELECT 1;
1907-
?column?
1908-
1909-
1
1910-
step s3_b_rc: BEGIN ISOLATION LEVEL READ COMMITTED; SELECT 1;
1911-
?column?
1912-
1913-
1
1914-
s1: NOTICE: upd: text key-a = text key-a: t
1915-
s1: NOTICE: upk: text val-a-s1 <> text mismatch: t
1916-
s1: NOTICE: trigger: name rep_b_u; when: BEFORE; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1) new: (key-a,val-a-s1-ups1)
1917-
s1: NOTICE: upd: text key-b = text key-a: f
1918-
s1: NOTICE: trigger: name rep_a_u; when: AFTER; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1) new: (key-a,val-a-s1-ups1)
1919-
step s1_upd_a_data:
1920-
UPDATE trigtest SET data = data || '-ups1'
1921-
WHERE
1922-
noisy_oper('upd', key, '=', 'key-a') AND
1923-
noisy_oper('upk', data, '<>', 'mismatch')
1924-
RETURNING *;
1925-
1926-
key data
1927-
1928-
key-a val-a-s1-ups1
1929-
s2: NOTICE: upd: text key-a = text key-a: t
1930-
s2: NOTICE: upk: text val-a-s1 <> text mismatch: t
1931-
step s2_upd_a_data:
1932-
UPDATE trigtest SET data = data || '-ups2'
1933-
WHERE
1934-
noisy_oper('upd', key, '=', 'key-a') AND
1935-
noisy_oper('upk', data, '<>', 'mismatch')
1936-
RETURNING *;
1937-
<waiting ...>
1938-
s3: NOTICE: upd: text key-a = text key-a: t
1939-
s3: NOTICE: upk: text val-a-s1 <> text mismatch: t
1940-
step s3_upd_a_data:
1941-
UPDATE trigtest SET data = data || '-ups3'
1942-
WHERE
1943-
noisy_oper('upd', key, '=', 'key-a') AND
1944-
noisy_oper('upk', data, '<>', 'mismatch')
1945-
RETURNING *;
1946-
<waiting ...>
1947-
step s1_c: COMMIT;
1948-
s2: NOTICE: upd: text key-a = text key-a: t
1949-
s2: NOTICE: upk: text val-a-s1-ups1 <> text mismatch: t
1950-
s2: NOTICE: trigger: name rep_b_u; when: BEFORE; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1-ups1) new: (key-a,val-a-s1-ups1-ups2)
1951-
s2: NOTICE: upd: text key-b = text key-a: f
1952-
s2: NOTICE: trigger: name rep_a_u; when: AFTER; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1-ups1) new: (key-a,val-a-s1-ups1-ups2)
1953-
step s2_upd_a_data: <... completed>
1954-
key data
1955-
1956-
key-a val-a-s1-ups1-ups2
1957-
step s2_c: COMMIT;
1958-
s3: NOTICE: upd: text key-a = text key-a: t
1959-
s3: NOTICE: upk: text val-a-s1-ups1-ups2 <> text mismatch: t
1960-
s3: NOTICE: trigger: name rep_b_u; when: BEFORE; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1-ups1-ups2) new: (key-a,val-a-s1-ups1-ups2-ups3)
1961-
s3: NOTICE: upd: text key-b = text key-a: f
1962-
s3: NOTICE: trigger: name rep_a_u; when: AFTER; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1-ups1-ups2) new: (key-a,val-a-s1-ups1-ups2-ups3)
1963-
step s3_upd_a_data: <... completed>
1964-
key data
1965-
1966-
key-a val-a-s1-ups1-ups2-ups3
1967-
step s3_c: COMMIT;
1968-
step s0_rep: SELECT * FROM trigtest ORDER BY key, data
1969-
key data
1970-
1971-
key-a val-a-s1-ups1-ups2-ups3
1972-
key-b val-b-s1
1973-
1974-
starting permutation: s1_trig_rep_b_u s1_trig_rep_a_u s1_ins_a s1_ins_b s1_b_rc s2_b_rc s3_b_rc s1_upd_a_data s2_upd_a_data s3_upd_a_data s1_c s2_r s3_c s0_rep
1975-
step s1_trig_rep_b_u: CREATE TRIGGER rep_b_u BEFORE UPDATE ON trigtest FOR EACH ROW EXECUTE PROCEDURE trig_report();
1976-
step s1_trig_rep_a_u: CREATE TRIGGER rep_a_u AFTER UPDATE ON trigtest FOR EACH ROW EXECUTE PROCEDURE trig_report();
1977-
step s1_ins_a: INSERT INTO trigtest VALUES ('key-a', 'val-a-s1') RETURNING *;
1978-
key data
1979-
1980-
key-a val-a-s1
1981-
step s1_ins_b: INSERT INTO trigtest VALUES ('key-b', 'val-b-s1') RETURNING *;
1982-
key data
1983-
1984-
key-b val-b-s1
1985-
step s1_b_rc: BEGIN ISOLATION LEVEL READ COMMITTED; SELECT 1;
1986-
?column?
1987-
1988-
1
1989-
step s2_b_rc: BEGIN ISOLATION LEVEL READ COMMITTED; SELECT 1;
1990-
?column?
1991-
1992-
1
1993-
step s3_b_rc: BEGIN ISOLATION LEVEL READ COMMITTED; SELECT 1;
1994-
?column?
1995-
1996-
1
1997-
s1: NOTICE: upd: text key-a = text key-a: t
1998-
s1: NOTICE: upk: text val-a-s1 <> text mismatch: t
1999-
s1: NOTICE: trigger: name rep_b_u; when: BEFORE; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1) new: (key-a,val-a-s1-ups1)
2000-
s1: NOTICE: upd: text key-b = text key-a: f
2001-
s1: NOTICE: trigger: name rep_a_u; when: AFTER; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1) new: (key-a,val-a-s1-ups1)
2002-
step s1_upd_a_data:
2003-
UPDATE trigtest SET data = data || '-ups1'
2004-
WHERE
2005-
noisy_oper('upd', key, '=', 'key-a') AND
2006-
noisy_oper('upk', data, '<>', 'mismatch')
2007-
RETURNING *;
2008-
2009-
key data
2010-
2011-
key-a val-a-s1-ups1
2012-
s2: NOTICE: upd: text key-a = text key-a: t
2013-
s2: NOTICE: upk: text val-a-s1 <> text mismatch: t
2014-
step s2_upd_a_data:
2015-
UPDATE trigtest SET data = data || '-ups2'
2016-
WHERE
2017-
noisy_oper('upd', key, '=', 'key-a') AND
2018-
noisy_oper('upk', data, '<>', 'mismatch')
2019-
RETURNING *;
2020-
<waiting ...>
2021-
s3: NOTICE: upd: text key-a = text key-a: t
2022-
s3: NOTICE: upk: text val-a-s1 <> text mismatch: t
2023-
step s3_upd_a_data:
2024-
UPDATE trigtest SET data = data || '-ups3'
2025-
WHERE
2026-
noisy_oper('upd', key, '=', 'key-a') AND
2027-
noisy_oper('upk', data, '<>', 'mismatch')
2028-
RETURNING *;
2029-
<waiting ...>
2030-
step s1_c: COMMIT;
2031-
s2: NOTICE: upd: text key-a = text key-a: t
2032-
s2: NOTICE: upk: text val-a-s1-ups1 <> text mismatch: t
2033-
s2: NOTICE: trigger: name rep_b_u; when: BEFORE; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1-ups1) new: (key-a,val-a-s1-ups1-ups2)
2034-
s2: NOTICE: upd: text key-b = text key-a: f
2035-
s2: NOTICE: trigger: name rep_a_u; when: AFTER; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1-ups1) new: (key-a,val-a-s1-ups1-ups2)
2036-
step s2_upd_a_data: <... completed>
2037-
key data
2038-
2039-
key-a val-a-s1-ups1-ups2
2040-
step s2_r: ROLLBACK;
2041-
s3: NOTICE: upd: text key-a = text key-a: t
2042-
s3: NOTICE: upk: text val-a-s1-ups1 <> text mismatch: t
2043-
s3: NOTICE: trigger: name rep_b_u; when: BEFORE; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1-ups1) new: (key-a,val-a-s1-ups1-ups3)
2044-
s3: NOTICE: upd: text key-b = text key-a: f
2045-
s3: NOTICE: trigger: name rep_a_u; when: AFTER; lev: ROWs; op: UPDATE; old: (key-a,val-a-s1-ups1) new: (key-a,val-a-s1-ups1-ups3)
2046-
step s3_upd_a_data: <... completed>
2047-
key data
2048-
2049-
key-a val-a-s1-ups1-ups3
2050-
step s3_c: COMMIT;
2051-
step s0_rep: SELECT * FROM trigtest ORDER BY key, data
2052-
key data
2053-
2054-
key-a val-a-s1-ups1-ups3
2055-
key-b val-b-s1
2056-
20571891
starting permutation: s1_trig_rep_b_i s1_trig_rep_b_d s1_trig_rep_b_u s1_trig_rep_a_i s1_trig_rep_a_d s1_trig_rep_a_u s1_ins_b s1_b_rc s2_b_rc s1_ins_a s1_upd_b_data s2_upd_b_data s1_del_b s1_upd_a_tob s1_c s2_c s0_rep
20581892
step s1_trig_rep_b_i: CREATE TRIGGER rep_b_i BEFORE INSERT ON trigtest FOR EACH ROW EXECUTE PROCEDURE trig_report();
20591893
step s1_trig_rep_b_d: CREATE TRIGGER rep_b_d BEFORE DELETE ON trigtest FOR EACH ROW EXECUTE PROCEDURE trig_report();
@@ -2368,5 +2202,9 @@ key data
23682202

23692203
key-a val-a-s1-ups2
23702204
key-b val-b-s1
2205+
unused step name: s2_r
2206+
unused step name: s3_b_rc
2207+
unused step name: s3_c
23712208
unused step name: s3_del_a
23722209
unused step name: s3_r
2210+
unused step name: s3_upd_a_data

‎src/test/isolation/specs/eval-plan-qual-trigger.spec

Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -358,17 +358,17 @@ permutation "s1_trig_rep_b_d" "s1_trig_rep_a_d"
358358
"s0_rep"
359359

360360
### Verify EPQ with more than two participants works
361-
# s1 updates, s2 updates, s3 updates, s1 commits, s2 EPQ, s2 commits, s3 EPQ
362-
permutation"s1_trig_rep_b_u""s1_trig_rep_a_u"
363-
"s1_ins_a""s1_ins_b""s1_b_rc""s2_b_rc""s3_b_rc"
364-
"s1_upd_a_data""s2_upd_a_data""s3_upd_a_data""s1_c""s2_c""s3_c"
365-
"s0_rep"
366-
#s1 updates, s2 updates, s3 updates, s1 commits, s2 EPQ, s2 rolls back, s3 EPQ
367-
permutation"s1_trig_rep_b_u""s1_trig_rep_a_u"
368-
"s1_ins_a""s1_ins_b""s1_b_rc""s2_b_rc""s3_b_rc"
369-
"s1_upd_a_data""s2_upd_a_data""s3_upd_a_data""s1_c""s2_r""s3_c"
370-
"s0_rep"
371-
## XXX: Disable test, there is some potential for instability here that's not yet fully understood
361+
## XXX: Disable tests, there is some potential for instability here that's not yet fully understood
362+
## s1 updates, s2 updates, s3 updates, s1 commits, s2 EPQ, s2 commits, s3 EPQ
363+
#permutation "s1_trig_rep_b_u" "s1_trig_rep_a_u"
364+
# "s1_ins_a" "s1_ins_b" "s1_b_rc" "s2_b_rc" "s3_b_rc"
365+
# "s1_upd_a_data" "s2_upd_a_data" "s3_upd_a_data" "s1_c" "s2_c" "s3_c"
366+
# "s0_rep"
367+
## s1 updates, s2 updates, s3 updates, s1 commits, s2 EPQ, s2 rolls back, s3 EPQ
368+
#permutation "s1_trig_rep_b_u" "s1_trig_rep_a_u"
369+
# "s1_ins_a" "s1_ins_b" "s1_b_rc" "s2_b_rc" "s3_b_rc"
370+
# "s1_upd_a_data" "s2_upd_a_data" "s3_upd_a_data" "s1_c" "s2_r" "s3_c"
371+
# "s0_rep"
372372
## s1 updates, s3 updates, s2 upserts, s1 updates, s1 commits, s3 EPQ, s3 deletes, s3 commits, s2 inserts without EPQ recheck
373373
#permutation "s1_trig_rep_b_i" "s1_trig_rep_b_d" "s1_trig_rep_b_u" "s1_trig_rep_a_i" "s1_trig_rep_a_d" "s1_trig_rep_a_u"
374374
# "s1_ins_a" "s1_b_rc" "s2_b_rc" "s3_b_rc"

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp