Changeset: 68c5d6630ca3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/68c5d6630ca3
Modified Files:
sql/test/rel-optimizers/Tests/merge-ors-multi-col-eq-to-cmp_in.test
Branch: default
Log Message:
Single-threaded we seem to have more information about the tables.
diffs (39 lines):
diff --git
a/sql/test/rel-optimizers/Tests/merge-ors-multi-col-eq-to-cmp_in.test
b/sql/test/rel-optimizers/Tests/merge-ors-multi-col-eq-to-cmp_in.test
--- a/sql/test/rel-optimizers/Tests/merge-ors-multi-col-eq-to-cmp_in.test
+++ b/sql/test/rel-optimizers/Tests/merge-ors-multi-col-eq-to-cmp_in.test
@@ -98,6 +98,7 @@ 3
60
600
+skipif threads=1
query T nosort
plan select * from b where (m = 40 and k > 0) or (m = 20 and k = 200) or (m =
60 and k = 600)
----
@@ -107,6 +108,16 @@ project (
| ) [ (( [ "b"."m", "b"."k" ]) in ( [ int(8) "20", int(11) "200" ], [ int(8)
"60", int(11) "600" ])) or (("b"."m") = (int(8) "40"), ("b"."k") > (int(11)
"0")) ]
) [ "b"."n", "b"."m", "b"."k" ]
+onlyif threads=1
+query T nosort
+plan select * from b where (m = 40 and k > 0) or (m = 20 and k = 200) or (m =
60 and k = 600)
+----
+project (
+| select (
+| | table("sys"."b") [ "b"."n", "b"."m", "b"."k" UNIQUE ]
+| ) [ (( [ "b"."m", "b"."k" UNIQUE ]) in ( [ int(8) "20", int(11) "200" ], [
int(8) "60", int(11) "600" ])) or (("b"."m") = (int(8) "40"), ("b"."k" UNIQUE)
> (int(11) "0")) ]
+) [ "b"."n", "b"."m", "b"."k" UNIQUE ]
+
query II rowsort
select m, k from b where (m = 40) or (m = 20 and k = 200) or (m = 0) or (m =
60 and k = 600) or (m = 180)
----
@@ -126,7 +137,7 @@ plan select m, k from b where (m = 40) o
----
project (
| select (
-| | table("sys"."b") [ "b"."m", "b"."k" ]
-| ) [ (("b"."m") in (int(8) "40", int(8) "0", int(8) "180")) or (( [ "b"."m",
"b"."k" ]) in ( [ int(8) "20", int(11) "200" ], [ int(8) "60", int(11) "600"
])) ]
-) [ "b"."m", "b"."k" ]
+| | table("sys"."b") [ "b"."m", "b"."k" UNIQUE ]
+| ) [ (("b"."m") in (int(8) "40", int(8) "0", int(8) "180")) or (( [ "b"."m",
"b"."k" UNIQUE ]) in ( [ int(8) "20", int(11) "200" ], [ int(8) "60", int(11)
"600" ])) ]
+) [ "b"."m", "b"."k" UNIQUE ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
