Changeset: d0ad284c4e9e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d0ad284c4e9e Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message:
Queries not throwing cardinality errors diffs (20 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer23.test b/sql/test/SQLancer/Tests/sqlancer23.test --- a/sql/test/SQLancer/Tests/sqlancer23.test +++ b/sql/test/SQLancer/Tests/sqlancer23.test @@ -71,3 +71,16 @@ SELECT (SELECT (VALUES (x.x)) FROM (VALU statement ok ROLLBACK + +statement error GDK reported error: mergejoin: more than one match +SELECT 1 FROM (SELECT DISTINCT 3) vx(vx) WHERE 1 <> (VALUES (2), (vx.vx)) + +statement error GDK reported error: mergejoin: more than one match +SELECT 1 FROM (SELECT DISTINCT 3) vx(vx) WHERE 1 <> (SELECT 2 UNION ALL SELECT vx.vx) + +# these are right +statement error GDK reported error: mergejoin: more than one match +SELECT 1 FROM (SELECT 3) vx(vx) WHERE 1 <> (VALUES (2), (vx.vx)) + +statement error GDK reported error: mergejoin: more than one match +SELECT 1 FROM (SELECT 3) vx(vx) WHERE 1 <> (SELECT 2 UNION ALL SELECT vx.vx) _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
