Changeset: e3f914fe1060 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e3f914fe1060
Modified Files:
sql/server/rel_optimizer.c
sql/test/SQLancer/Tests/sqlancer23.test
Branch: default
Log Message:
Search on group by columns only if expression is a column
diffs (25 lines):
diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c
--- a/sql/server/rel_optimizer.c
+++ b/sql/server/rel_optimizer.c
@@ -1979,7 +1979,7 @@ exp_push_down_prj(mvc *sql, sql_exp *e,
return NULL;
}
/* possibly a groupby/project column is renamed */
- if (is_groupby(f->op) && !list_empty(f->r)) {
+ if (is_groupby(f->op) && !list_empty(f->r) && ne->type ==
e_column) {
sql_exp *gbe = NULL;
if (ne->l)
gbe = exps_bind_column2(f->r, ne->l, ne->r,
NULL);
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
@@ -52,5 +52,9 @@ SELECT ((SELECT y.y) EXCEPT ALL (SELECT
----
NULL
+query I nosort
+SELECT 2 FROM (SELECT FALSE GROUP BY 'a', FALSE) y(y) WHERE y.y
+----
+
statement ok
ROLLBACK
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
