Changeset: fcf1e8e5d2e3 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fcf1e8e5d2e3
Modified Files:
sql/server/rel_select.c
Branch: Dec2016
Log Message:
make sure only one isnil is done for coalesce (other operators
really need an extra isnil check).
diffs (12 lines):
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -3577,7 +3577,7 @@ rel_case(mvc *sql, sql_rel **rel, int to
return NULL;
/* remove any null's in the condition */
- if (has_nil(cond)) {
+ if (has_nil(cond) && token != SQL_COALESCE) {
sql_exp *condnil = rel_unop_(sql, cond, NULL, "isnull",
card_value);
cond = rel_nop_(sql, condnil, exp_atom_bool(sql->sa,
0), cond, NULL, NULL, "ifthenelse", card_value);
}
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
