diff options
Diffstat (limited to 'src/test/regress/sql/merge.sql')
| -rw-r--r-- | src/test/regress/sql/merge.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/src/test/regress/sql/merge.sql b/src/test/regress/sql/merge.sql index 8815e0cc498..afeb212f3c8 100644 --- a/src/test/regress/sql/merge.sql +++ b/src/test/regress/sql/merge.sql @@ -878,7 +878,7 @@ BEGIN EXECUTE 'explain (analyze, timing off, summary off, costs off) ' || query LOOP - ln := regexp_replace(ln, 'Memory: \S*', 'Memory: xxx'); + ln := regexp_replace(ln, '(Memory( Usage)?|Buckets|Batches): \S*', '\1: xxx', 'g'); RETURN NEXT ln; END LOOP; END; @@ -920,6 +920,12 @@ WHEN MATCHED AND t.a >= 30 AND t.a <= 40 THEN WHEN NOT MATCHED AND s.a < 20 THEN INSERT VALUES (a, b)'); +-- nothing +SELECT explain_merge(' +MERGE INTO ex_mtarget t USING ex_msource s ON t.a = s.a AND t.a < -1000 +WHEN MATCHED AND t.a < 10 THEN + DO NOTHING'); + DROP TABLE ex_msource, ex_mtarget; DROP FUNCTION explain_merge(text); |