Changeset: 224ad1d1581b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/224ad1d1581b
Modified Files:
sql/server/rel_unnest.c
Branch: default
Log Message:
Another corner case I forgot, projections with ordering
diffs (13 lines):
diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c
--- a/sql/server/rel_unnest.c
+++ b/sql/server/rel_unnest.c
@@ -3121,7 +3121,8 @@ rewrite_exists(visitor *v, sql_rel *rel,
}
sq = exp_rel_get_rel(v->sql->sa, ie); /* get subquery */
- if (!is_project(sq->op) || (is_set(sq->op) &&
list_length(sq->exps) > 1)) /* number of expressions in set relations must
match the children */
+ /* number of expressions in set relations must match
the children */
+ if (!is_project(sq->op) || (is_set(sq->op) &&
list_length(sq->exps) > 1) || (is_simple_project(sq->op) && !list_empty(sq->r)))
sq = rel_project(v->sql->sa, sq,
rel_projections(v->sql, sq, NULL, 1, 1));
le = rel_reduce2one_exp(v->sql, sq);
le = exp_ref(v->sql, le);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
