Changeset: df2a8d872fc6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/df2a8d872fc6
Modified Files:
sql/test/SQLancer/Tests/sqlancer22.test
Branch: Jan2022
Log Message:
rewrite_outer2inner_union exploding plans. Looking into it
diffs (21 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer22.test
b/sql/test/SQLancer/Tests/sqlancer22.test
--- a/sql/test/SQLancer/Tests/sqlancer22.test
+++ b/sql/test/SQLancer/Tests/sqlancer22.test
@@ -228,3 +228,17 @@ 2
statement ok
ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+create table t0 (c0 int, CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"))
+
+statement ok rowcount 1
+MERGE INTO t0 USING (SELECT 1 FROM t0
+FULL OUTER JOIN (SELECT 1 FROM t0 AS w RIGHT OUTER JOIN (SELECT 1) AS z(z) ON
EXISTS (SELECT 1 WHERE w.c0 > 0)) AS y(y)
+ON y.y = y.y) AS x(x) ON TRUE WHEN NOT MATCHED THEN INSERT (c0) VALUES (1)
+
+statement ok
+ROLLBACK
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
