Changeset: fd8dec3d9d8e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fd8dec3d9d8e Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message:
Next subquery crash diffs (15 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 @@ -149,6 +149,11 @@ SELECT 1 FROM t0 LEFT OUTER JOIN LATERAL ON (VALUES (t0.c0)) = 1 ---- +query I nosort +SELECT 1 FROM t0, (SELECT 1 FROM (SELECT 1) y(y) LEFT JOIN (SELECT 1) x(x) ON 1 < any(SELECT y.y)) vx(vx) +WHERE CASE WHEN TRUE THEN 2 = ANY(VALUES (vx.vx)) WHEN FALSE THEN t0.c0 = t0.c0 END +---- + # Postgres doesn't give an error here, but we are confident it must statement error GDK reported error: mergejoin: more than one match SELECT 1 FROM t0 CROSS JOIN LATERAL (SELECT (VALUES (y.y), (y.y)) FROM (SELECT 1) y(y) WHERE t0.c0 = 2) x(x) _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
