Changeset: 28e1135c9dbd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=28e1135c9dbd
Modified Files:
monetdb5/optimizer/opt_pushselect.c
sql/test/SQLancer/Tests/sqlancer09.stable.out
Branch: octbugs
Log Message:
disable push down of subselects as this is now done in the sql layer
diffs (33 lines):
diff --git a/monetdb5/optimizer/opt_pushselect.c
b/monetdb5/optimizer/opt_pushselect.c
--- a/monetdb5/optimizer/opt_pushselect.c
+++ b/monetdb5/optimizer/opt_pushselect.c
@@ -298,7 +298,7 @@ OPTpushselectImplementation(Client cntxt
}
}
- if (subselects.nr) {
+ if (0 && subselects.nr) {
if (newMalBlkStmt(mb, mb->ssize) <0 ) {
GDKfree(vars);
goto wrapup;
@@ -386,7 +386,7 @@ OPTpushselectImplementation(Client cntxt
actions++;
}
}
- /* Leftfetchjoins involving rewriten table ids need to
be flattend
+ /* Projections involving rewriten table ids need to be
flattend
* l = projection(t, c); => l = c;
* and
* l = projection(s, ntids); => l = s;
diff --git a/sql/test/SQLancer/Tests/sqlancer09.stable.out
b/sql/test/SQLancer/Tests/sqlancer09.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer09.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer09.stable.out
@@ -13,6 +13,8 @@ stdout of test 'sqlancer09` in directory
#ALTER TABLE t0 ALTER tc0 SET NOT NULL;
#INSERT INTO t0(tc0) VALUES(INTERVAL '-625288924' MONTH);
[ 1 ]
+#UPDATE t0 SET tc0 = (t0.tc0) WHERE TRUE;
+[ 1 ]
#DROP TABLE t0;
#CREATE TABLE t2(tc0 TINYINT);
#ALTER TABLE t2 ADD PRIMARY KEY(tc0);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
