diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/isolation/expected/eval-plan-qual.out | 9 | ||||
| -rw-r--r-- | src/test/isolation/specs/eval-plan-qual.spec | 8 |
2 files changed, 17 insertions, 0 deletions
diff --git a/src/test/isolation/expected/eval-plan-qual.out b/src/test/isolation/expected/eval-plan-qual.out index 3d31d0f84e5..60eca44b4e3 100644 --- a/src/test/isolation/expected/eval-plan-qual.out +++ b/src/test/isolation/expected/eval-plan-qual.out @@ -1457,3 +1457,12 @@ step sysmerge2: step c1: COMMIT; step sysmerge2: <... completed> step c2: COMMIT; + +starting permutation: s1pp1 s2pp1 s2pp2 s2pp3 c1 c2 +step s1pp1: UPDATE another_parttbl SET b = b + 1 WHERE a = 1; +step s2pp1: SET plan_cache_mode TO force_generic_plan; +step s2pp2: PREPARE epd AS DELETE FROM another_parttbl WHERE a = $1; +step s2pp3: EXECUTE epd(1); <waiting ...> +step c1: COMMIT; +step s2pp3: <... completed> +step c2: COMMIT; diff --git a/src/test/isolation/specs/eval-plan-qual.spec b/src/test/isolation/specs/eval-plan-qual.spec index c6eee685586..64afffb1d83 100644 --- a/src/test/isolation/specs/eval-plan-qual.spec +++ b/src/test/isolation/specs/eval-plan-qual.spec @@ -204,6 +204,7 @@ step sys1 { UPDATE pg_class SET reltuples = 123 WHERE oid = 'accounts'::regclass; } +step s1pp1 { UPDATE another_parttbl SET b = b + 1 WHERE a = 1; } session s2 setup { BEGIN ISOLATION LEVEL READ COMMITTED; } @@ -312,6 +313,10 @@ step sysmerge2 { step c2 { COMMIT; } step r2 { ROLLBACK; } +step s2pp1 { SET plan_cache_mode TO force_generic_plan; } +step s2pp2 { PREPARE epd AS DELETE FROM another_parttbl WHERE a = $1; } +step s2pp3 { EXECUTE epd(1); } + session s3 setup { BEGIN ISOLATION LEVEL READ COMMITTED; } step read { SELECT * FROM accounts ORDER BY accountid; } @@ -415,3 +420,6 @@ permutation simplepartupdate_noroute complexpartupdate_doesnt_route c1 c2 read_p permutation sys1 sysupd2 c1 c2 permutation sys1 sysmerge2 c1 c2 + +# Exercise run-time partition pruning code in an EPQ recheck +permutation s1pp1 s2pp1 s2pp2 s2pp3 c1 c2 |