Changeset: 898bfc3e4a32 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/898bfc3e4a32
Modified Files:
sql/test/rel-optimizers/Tests/isnull-isnotnull-equality-exp.test
Branch: default
Log Message:
Adds tests for isnull/isnotnull plans
diffs (125 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
@@ -74,6 +74,15 @@ select * from foo where sys.isnull(n) =
NULL
mighty null
+query T
+plan select * from foo where sys.isnull(n) = true
+----
+project (
+| select (
+| | table("sys"."foo") [ "foo"."n", "foo"."m" NOT NULL ]
+| ) [ ("foo"."n") * = (int(2) NULL) ]
+) [ "foo"."n", "foo"."m" NOT NULL ]
+
query IT rowsort
select * from foo where sys.isnull(n) = false
----
@@ -82,6 +91,15 @@ one
2
two
+query T
+plan select * from foo where sys.isnull(n) = false
+----
+project (
+| select (
+| | table("sys"."foo") [ "foo"."n", "foo"."m" NOT NULL ]
+| ) [ ("foo"."n") ! * = (int(2) NULL) ]
+) [ "foo"."n" NOT NULL, "foo"."m" NOT NULL ]
+
query IT rowsort
select * from foo where sys.isnull(n) != true
----
@@ -90,12 +108,30 @@ one
2
two
+query T
+plan select * from foo where sys.isnull(n) != true
+----
+project (
+| select (
+| | table("sys"."foo") [ "foo"."n", "foo"."m" NOT NULL ]
+| ) [ ("foo"."n") * != (int(2) NULL) ]
+) [ "foo"."n", "foo"."m" NOT NULL ]
+
query IT rowsort
select * from foo where sys.isnull(n) != false
----
NULL
mighty null
+query T
+plan select * from foo where sys.isnull(n) != false
+----
+project (
+| select (
+| | table("sys"."foo") [ "foo"."n", "foo"."m" NOT NULL ]
+| ) [ ("foo"."n") ! * != (int(2) NULL) ]
+) [ "foo"."n", "foo"."m" NOT NULL ]
+
query IT rowsort
select * from foo where sys.isnotnull(n) = true
----
@@ -104,18 +140,45 @@ one
2
two
+query T
+plan select * from foo where sys.isnotnull(n) = true
+----
+project (
+| select (
+| | table("sys"."foo") [ "foo"."n", "foo"."m" NOT NULL ]
+| ) [ ("foo"."n") ! * = (int(2) NULL) ]
+) [ "foo"."n" NOT NULL, "foo"."m" NOT NULL ]
+
query IT rowsort
select * from foo where sys.isnotnull(n) = false
----
NULL
mighty null
+query T
+plan select * from foo where sys.isnotnull(n) = false
+----
+project (
+| select (
+| | table("sys"."foo") [ "foo"."n", "foo"."m" NOT NULL ]
+| ) [ ("foo"."n") * = (int(2) NULL) ]
+) [ "foo"."n", "foo"."m" NOT NULL ]
+
query IT rowsort
select * from foo where sys.isnotnull(n) != true
----
NULL
mighty null
+query T
+plan select * from foo where sys.isnotnull(n) != true
+----
+project (
+| select (
+| | table("sys"."foo") [ "foo"."n", "foo"."m" NOT NULL ]
+| ) [ ("foo"."n") ! * != (int(2) NULL) ]
+) [ "foo"."n", "foo"."m" NOT NULL ]
+
query IT rowsort
select * from foo where sys.isnotnull(n) != false
----
@@ -124,3 +187,12 @@ one
2
two
+query T
+plan select * from foo where sys.isnotnull(n) != false
+----
+project (
+| select (
+| | table("sys"."foo") [ "foo"."n", "foo"."m" NOT NULL ]
+| ) [ ("foo"."n") * != (int(2) NULL) ]
+) [ "foo"."n", "foo"."m" NOT NULL ]
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
