Changeset: 0e4bfabdf4b2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0e4bfabdf4b2
Modified Files:
sql/test/rel-optimizers/Tests/isnull-isnotnull-equality-exp.test
Branch: default
Log Message:
Adds tests for isnull/isnotnull optimization cases
diffs (63 lines):
diff --git a/sql/test/rel-optimizers/Tests/isnull-isnotnull-equality-exp.test
b/sql/test/rel-optimizers/Tests/isnull-isnotnull-equality-exp.test
--- a/sql/test/rel-optimizers/Tests/isnull-isnotnull-equality-exp.test
+++ b/sql/test/rel-optimizers/Tests/isnull-isnotnull-equality-exp.test
@@ -68,3 +68,59 @@ project (
| ) [ ("foo"."n") * = (int(2) NULL) ]
) [ "foo"."n", "foo"."m" NOT NULL ]
+query IT rowsort
+select * from foo where sys.isnull(n) = true
+----
+NULL
+mighty null
+
+query IT rowsort
+select * from foo where sys.isnull(n) = false
+----
+1
+one
+2
+two
+
+query IT rowsort
+select * from foo where sys.isnull(n) != true
+----
+1
+one
+2
+two
+
+query IT rowsort
+select * from foo where sys.isnull(n) != false
+----
+NULL
+mighty null
+
+query IT rowsort
+select * from foo where sys.isnotnull(n) = true
+----
+1
+one
+2
+two
+
+query IT rowsort
+select * from foo where sys.isnotnull(n) = false
+----
+NULL
+mighty null
+
+query IT rowsort
+select * from foo where sys.isnotnull(n) != true
+----
+NULL
+mighty null
+
+query IT rowsort
+select * from foo where sys.isnotnull(n) != false
+----
+1
+one
+2
+two
+
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
