Changeset: 292c83689e7f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/292c83689e7f Modified Files: sql/test/SQLancer/Tests/sqlancer23.test Branch: default Log Message:
Unnesting of table UDFs going badly 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 @@ -103,6 +103,11 @@ query I nosort SELECT 1 FROM (SELECT DISTINCT 1) y(y) WHERE EXISTS (SELECT 1 WHERE (SELECT y.y FROM t0 x) = 0) ---- +query I nosort +SELECT (SELECT 1 FROM generate_series((SELECT DISTINCT 1, x.c0 FROM t0 x WHERE t0.c0 = 0)) +JOIN LATERAL (SELECT DISTINCT 1) x(x) ON TRUE) FROM t0 +---- + statement ok ROLLBACK _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
