Changeset: c3c90c20d69a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c3c90c20d69a Modified Files: sql/test/BugTracker-2026/Tests/7967-optimize-in-select-distinct-queries.test Branch: Dec2025 Log Message:
Table lhs is not used by the queries. Removed it to simplify the script. diffs (43 lines): diff --git a/sql/test/BugTracker-2026/Tests/7967-optimize-in-select-distinct-queries.test b/sql/test/BugTracker-2026/Tests/7967-optimize-in-select-distinct-queries.test --- a/sql/test/BugTracker-2026/Tests/7967-optimize-in-select-distinct-queries.test +++ b/sql/test/BugTracker-2026/Tests/7967-optimize-in-select-distinct-queries.test @@ -5,20 +5,12 @@ statement ok INSERT INTO digits VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9) statement ok -CREATE TABLE lhs(id INTEGER PRIMARY KEY,v INTEGER) - -statement ok CREATE TABLE rhs(id INTEGER PRIMARY KEY,v INTEGER) statement ok CREATE TABLE probe(id INTEGER PRIMARY KEY,v INTEGER) statement ok -INSERT INTO lhs SELECT n,CASE WHEN MOD(n,97)=0 THEN NULL ELSE MOD(n,1000) END FROM - (SELECT a.d+b.d*10+c.d*100+d.d*1000+e.d*10000+1 n - FROM digits a,digits b,digits c,digits d,digits e) x - -statement ok INSERT INTO rhs SELECT n,CASE WHEN MOD(n,89)=0 THEN NULL ELSE MOD(n,700)+300 END FROM (SELECT a.d+b.d*10+c.d*100+d.d*1000+e.d*10000+1 n FROM digits a,digits b,digits c,digits d,digits e) x @@ -29,9 +21,6 @@ INSERT INTO probe SELECT n,CASE WHEN MOD FROM digits a,digits b,digits c,digits d,digits e) x statement ok -ANALYZE sys.lhs - -statement ok ANALYZE sys.rhs statement ok @@ -86,8 +75,5 @@ statement ok DROP TABLE IF EXISTS rhs statement ok -DROP TABLE IF EXISTS lhs - -statement ok DROP TABLE IF EXISTS digits _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
