Changeset: 5fca60cffd25 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5fca60cffd25
Modified Files:
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.test
Branch: reducedstack
Log Message:
approved output
diffs (12 lines):
diff --git
a/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.test
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.test
---
a/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.test
+++
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.test
@@ -185,7 +185,7 @@ top N (
| | | | ) [ ("a3"."t3pkcol" NOT NULL UNIQUE HASHCOL ) = ("table1"."t1cold113"
NOT NULL) ],
| | | | table("sys"."table12") [ "table12"."t12cola1" NOT NULL UNIQUE ]
| | | ) [ ("table12"."t12cola1" NOT NULL UNIQUE) = ("table1"."t1cola1" NOT
NULL) ]
-| | ) [ ((((((((((((((("table1"."t1cold1" NOT NULL) FILTER
"sys"."like"(varchar "%a%", varchar "", boolean(1) "true")) or
(("table1"."t1cola1" NOT NULL) FILTER "sys"."like"(varchar "%a%", varchar "",
boolean(1) "true"))) or (("table1"."t1colb1" NOT NULL) FILTER
"sys"."like"(varchar "%a%", varchar "", boolean(1) "true"))) or
(("table1"."t1cola11" NOT NULL) FILTER "sys"."like"(varchar "%business%",
varchar "", boolean(1) "true"))) or (("table1"."t1colc91" NOT NULL) >=
(timestamp(7) "2016-03-21 05:00:00.000000"))) or (("table1"."t1cola101" NOT
NULL) = (tinyint(1) "1"))) or (("table1"."t1cola12" NOT NULL) FILTER
"sys"."like"(varchar "%Vijay%", varchar "", boolean(1) "true"))) or
(("table2"."t2cola1") ! FILTER "sys"."like"(varchar "%gmail%", varchar "",
boolean(1) "true"), ("table2"."t2cola1") ! FILTER "sys"."like"(varchar
"%yahoo%", varchar "", boolean(1) "true"))) or (("table2"."t2cola1") FILTER
"sys"."like"(varchar "%efequitygroup.com%", varchar "", boolean(1) "true"))) or
(("table4".
"t4cola1") = (varchar "Customer"))) or (("table4"."t4cola2") ! * = (varchar
NULL))) or (("table2"."t2cola81") >= (date "2009-08-31"))) or
(((("table5"."t5cola1") = (varchar "BAT")) or (("table5"."t5cola2") FILTER
"sys"."like"(varchar "%AUSTRALIA%", varchar "", boolean(1) "true"))) or
(("table5"."t5cola2") FILTER "sys"."like"(varchar "%Monet%", varchar "",
boolean(1) "true"), ("table5"."t5cola3") = (varchar "Facebook"),
("table5"."t5cola5") = (varchar "new"), ("table5"."t5cola81") > (date
"2015-07-30")))) or (((("table10"."t10cola1") != (varchar "Completed"),
("table9"."t9cola1") = (varchar "Tasks"), ("table9"."t9cola91") >=
(timestamp(7) "2012-01-01 04:32:27.000000"), ("table10"."t10cola91") <=
(timestamp(7) "2013-01-01 04:32:27.000000")) or (("table9"."t9cola1") =
(varchar "Events"), (timestamp(7) "2012-01-01 04:32:27.000000") <=
("table11"."t11cola91") <= (timestamp(7) "2013-01-01 04:32:27.000000"))) or
(("table9"."t9cola1") = (varchar "Calls"), (timestamp(7) "2012-01-01 04:32:27.
000000") <= ("table10"."t10cola91") <= (timestamp(7) "2013-01-01
04:32:27.000000"))), ("table1"."t1cold111" NOT NULL) in (bigint(63)
"15842000014793046", bigint(63) "15842000017701488", bigint(63)
"15842000000024019", bigint(63) "15842000000074007", bigint(63)
"15842000009358096", bigint(63) "15842000010487625", bigint(63)
"15842000006731919", bigint(63) "15842000002590112", bigint(63)
"15842000000019001", bigint(63) "15842000014923682", bigint(63)
"15842000027547249")) or (("table12"."t12cola1") in (varchar[bigint(54)
"15842000280111951"] NOT NULL, varchar[bigint(54) "15842000280163015"] NOT
NULL)) ]
+| | ) [ ((("table1"."t1cold1" NOT NULL) FILTER "sys"."like"(varchar "%a%",
varchar "", boolean(1) "true")) or ((("table1"."t1cola1" NOT NULL) FILTER
"sys"."like"(varchar "%a%", varchar "", boolean(1) "true")) or
((("table1"."t1colb1" NOT NULL) FILTER "sys"."like"(varchar "%a%", varchar "",
boolean(1) "true")) or ((("table1"."t1cola11" NOT NULL) FILTER
"sys"."like"(varchar "%business%", varchar "", boolean(1) "true")) or
((("table1"."t1colc91" NOT NULL) >= (timestamp(7) "2016-03-21
05:00:00.000000")) or ((("table1"."t1cola101" NOT NULL) = (tinyint(1) "1")) or
((("table1"."t1cola12" NOT NULL) FILTER "sys"."like"(varchar "%Vijay%", varchar
"", boolean(1) "true")) or ((("table2"."t2cola1") FILTER
"sys"."not_like"(varchar "%gmail%", varchar "", boolean(1) "true"),
("table2"."t2cola1") FILTER "sys"."not_like"(varchar "%yahoo%", varchar "",
boolean(1) "true")) or ((("table2"."t2cola1") FILTER "sys"."like"(varchar
"%efequitygroup.com%", varchar "", boolean(1) "true")) or ((("table4"."t4cola
1") = (varchar "Customer")) or ((("table4"."t4cola2") ! * = (varchar NULL)) or
((("table2"."t2cola81") >= (date "2009-08-31")) or (((("table5"."t5cola1") =
(varchar "BAT")) or ((("table5"."t5cola2") FILTER "sys"."like"(varchar
"%AUSTRALIA%", varchar "", boolean(1) "true")) or (("table5"."t5cola2") FILTER
"sys"."like"(varchar "%Monet%", varchar "", boolean(1) "true"),
("table5"."t5cola3") = (varchar "Facebook"), ("table5"."t5cola5") = (varchar
"new"), ("table5"."t5cola81") > (date "2015-07-30")))) or
((("table10"."t10cola1") != (varchar "Completed"), ("table9"."t9cola1") =
(varchar "Tasks"), ("table9"."t9cola91") >= (timestamp(7) "2012-01-01
04:32:27.000000"), ("table10"."t10cola91") <= (timestamp(7) "2013-01-01
04:32:27.000000")) or ((("table9"."t9cola1") = (varchar "Events"),
("table11"."t11cola91") >= (timestamp(7) "2012-01-01 04:32:27.000000"),
("table11"."t11cola91") <= (timestamp(7) "2013-01-01 04:32:27.000000")) or
(("table9"."t9cola1") = (varchar "Calls"), ("table10"."t10cola
91") >= (timestamp(7) "2012-01-01 04:32:27.000000"), ("table10"."t10cola91")
<= (timestamp(7) "2013-01-01 04:32:27.000000")))))))))))))))),
("table1"."t1cold111" NOT NULL) in (bigint(63) "15842000014793046", bigint(63)
"15842000017701488", bigint(63) "15842000000024019", bigint(63)
"15842000000074007", bigint(63) "15842000009358096", bigint(63)
"15842000010487625", bigint(63) "15842000006731919", bigint(63)
"15842000002590112", bigint(63) "15842000000019001", bigint(63)
"15842000014923682", bigint(63) "15842000027547249")) or
(("table12"."t12cola1") in (varchar[bigint(54) "15842000280111951"] NOT NULL,
varchar[bigint(54) "15842000280163015"] NOT NULL)) ]
| ) [ "table1"."t1pkcol" NOT NULL HASHCOL , "table1"."t1cola82" NOT NULL,
"table2"."t2cola10", "table1"."t1cola1" NOT NULL, "table1"."t1cola91" NOT NULL,
"a1"."t3cola1" ] [ "table2"."t2cola82" NULLS LAST ]
) [ bigint(63) "10", bigint(63) "0" ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
