Changeset: 93584a430d9b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/93584a430d9b
Modified Files:
sql/backends/monet5/dict.c
sql/test/dict/Tests/dict04.test
Branch: default
Log Message:
Also don't forget for the <> case
diffs (29 lines):
diff --git a/sql/backends/monet5/dict.c b/sql/backends/monet5/dict.c
--- a/sql/backends/monet5/dict.c
+++ b/sql/backends/monet5/dict.c
@@ -735,7 +735,7 @@ DICTthetaselect(Client cntxt, MalBlkPtr
bn = BATthetaselect(lo, lc, &val, op);
} else
assert(0);
- if (bn && (op[0] == '<' || op[0] == '>') && (!lvi.nonil
|| lvi.nil)) { /* filter the NULL value out */
+ if (bn && (op[0] == '<' || op[0] == '>' || op[0] ==
'!') && (!lvi.nonil || lvi.nil)) { /* filter the NULL value out */
p = BUNfnd(lv, ATOMnilptr(lvi.type));
if (p != BUN_NONE) {
BAT *nbn = NULL;
diff --git a/sql/test/dict/Tests/dict04.test b/sql/test/dict/Tests/dict04.test
--- a/sql/test/dict/Tests/dict04.test
+++ b/sql/test/dict/Tests/dict04.test
@@ -296,6 +296,13 @@ query I nosort
SELECT 1 FROM t0 WHERE t0.c0 <> 1
----
+statement ok rowcount 1
+INSERT INTO t0 VALUES (1)
+
+query I nosort
+SELECT t0.c0 FROM t0 WHERE t0.c0 <> 1
+----
+
statement ok
DROP TABLE t0
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
