Changeset: cd786fafd3b2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cd786fafd3b2
Modified Files:
sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.test
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test
sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.test
sql/test/BugTracker-2013/Tests/rangejoin_optimizer.Bug-3411.test
sql/test/BugTracker-2015/Tests/crash.Bug-3736.test
sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.test
sql/test/BugTracker-2015/Tests/large_join.Bug-3809.test
sql/test/BugTracker-2015/Tests/quantile_function_resolution.Bug-3773.test
sql/test/BugTracker-2015/Tests/schema_view.Bug-3708.test
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.test
sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.test
sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.test
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.test
sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.test
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.test
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.test
sql/test/Tests/keys.test
sql/test/Tests/order_by_complex_exp.test
sql/test/Tests/truncate-statements-extra.test
sql/test/analytics/Tests/analytics00.test
sql/test/astro/Tests/astro.test
sql/test/merge-partitions/Tests/mergepart31.test
sql/test/mergetables/Tests/mergequery.test
sql/test/mergetables/Tests/part-elim.test
sql/test/miscellaneous/Tests/groupby_error.test
sql/test/miscellaneous/Tests/groupby_expressions.test
sql/test/miscellaneous/Tests/simple_plans.test
sql/test/out2in/Tests/out2in.test
Branch: default
Log Message:
Approved outputs in new format
diffs (truncated from 2820 to 300 lines):
diff --git
a/sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.test
b/sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.test
--- a/sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.test
+++ b/sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.test
@@ -43,7 +43,7 @@ PLAN select a,b from sorted group by a,b
----
project (
| group by (
-| | table(sys.sorted) [ "sorted"."a", "sorted"."b" ] COUNT
+| | table("sys"."sorted") [ "sorted"."a", "sorted"."b" ] COUNT
| ) [ "sorted"."a", "sorted"."b" ] [ "sorted"."a", "sorted"."b" ]
) [ "sorted"."a", "sorted"."b" ]
@@ -52,7 +52,7 @@ PLAN select a,b from sorted group by b,a
----
project (
| group by (
-| | table(sys.sorted) [ "sorted"."a", "sorted"."b" ] COUNT
+| | table("sys"."sorted") [ "sorted"."a", "sorted"."b" ] COUNT
| ) [ "sorted"."b", "sorted"."a" ] [ "sorted"."b", "sorted"."a" ]
) [ "sorted"."a", "sorted"."b" ]
diff --git
a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
--- a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
+++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
@@ -20,7 +20,7 @@ query T nosort
PLAN select * from oblo
----
project (
-| table(sys.oblo) [ "oblo"."a" ] COUNT
+| table("sys"."oblo") [ "oblo"."a" ] COUNT
) [ "oblo"."a" ]
query T nosort
@@ -28,7 +28,7 @@ query T nosort
----
project (
| top N (
-| | table(sys.oblo) [ "oblo"."a" ] COUNT
+| | table("sys"."oblo") [ "oblo"."a" ] COUNT
| ) [ bigint "NULL", bigint "2" ]
) [ "oblo"."a" ]
@@ -37,7 +37,7 @@ query T nosort
----
project (
| top N (
-| | table(sys.oblo) [ "oblo"."a" ] COUNT
+| | table("sys"."oblo") [ "oblo"."a" ] COUNT
| ) [ bigint "2" ]
) [ "oblo"."a" ]
@@ -46,7 +46,7 @@ query T nosort
----
project (
| top N (
-| | table(sys.oblo) [ "oblo"."a" ] COUNT
+| | table("sys"."oblo") [ "oblo"."a" ] COUNT
| ) [ bigint "1", bigint "2" ]
) [ "oblo"."a" ]
@@ -55,7 +55,7 @@ query T nosort
----
project (
| top N (
-| | table(sys.oblo) [ "oblo"."a" ] COUNT
+| | table("sys"."oblo") [ "oblo"."a" ] COUNT
| ) [ bigint "2", bigint "1" ]
) [ "oblo"."a" ]
@@ -63,7 +63,7 @@ query T nosort
PLAN select * from oblo ORDER BY a
----
project (
-| table(sys.oblo) [ "oblo"."a" ] COUNT
+| table("sys"."oblo") [ "oblo"."a" ] COUNT
) [ "oblo"."a" ] [ "oblo"."a" ASC ]
query T nosort
@@ -71,7 +71,7 @@ query T nosort
----
top N (
| project (
-| | table(sys.oblo) [ "oblo"."a" ] COUNT
+| | table("sys"."oblo") [ "oblo"."a" ] COUNT
| ) [ "oblo"."a" ] [ "oblo"."a" ASC ]
) [ bigint "NULL", bigint "2" ]
@@ -80,7 +80,7 @@ query T nosort
----
top N (
| project (
-| | table(sys.oblo) [ "oblo"."a" ] COUNT
+| | table("sys"."oblo") [ "oblo"."a" ] COUNT
| ) [ "oblo"."a" ] [ "oblo"."a" ASC ]
) [ bigint "2" ]
@@ -89,7 +89,7 @@ query T nosort
----
top N (
| project (
-| | table(sys.oblo) [ "oblo"."a" ] COUNT
+| | table("sys"."oblo") [ "oblo"."a" ] COUNT
| ) [ "oblo"."a" ] [ "oblo"."a" ASC ]
) [ bigint "2", bigint "1" ]
@@ -98,7 +98,7 @@ query T nosort
----
top N (
| project (
-| | table(sys.oblo) [ "oblo"."a" ] COUNT
+| | table("sys"."oblo") [ "oblo"."a" ] COUNT
| ) [ "oblo"."a" ] [ "oblo"."a" ASC ]
) [ bigint "1", bigint "2" ]
diff --git
a/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test
b/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test
---
a/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test
+++
b/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test
@@ -67,12 +67,12 @@ project (
| distinct union (
| | project (
| | | group by (
-| | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | | ) [ "t2606a"."a" ] [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
| | | group by (
-| | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | | ) [ "t2606b"."a" ] [ "t2606b"."a" ]
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
@@ -98,12 +98,12 @@ project (
| distinct union (
| | project (
| | | group by (
-| | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | | ) [ "t2606a"."a" ] [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
| | | group by (
-| | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | | ) [ "t2606b"."a" ] [ "t2606b"."a" ]
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
@@ -129,12 +129,12 @@ project (
| distinct union (
| | project (
| | | group by (
-| | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | | ) [ "t2606a"."a" ] [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
| | | group by (
-| | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | | ) [ "t2606b"."a" ] [ "t2606b"."a" ]
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
@@ -159,10 +159,10 @@ PLAN select * from t2606a except s
project (
| distinct except (
| | project (
-| | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
) [ "%5"."a" ] [ "%5"."a" ASC ]
@@ -180,10 +180,10 @@ PLAN ( select * from t2606a except s
project (
| distinct except (
| | project (
-| | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
) [ "%5"."a" ] [ "%5"."a" ASC ]
@@ -201,10 +201,10 @@ PLAN ( select * from t2606a ) except ( s
project (
| distinct except (
| | project (
-| | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
) [ "%5"."a" ] [ "%5"."a" ASC ]
@@ -222,10 +222,10 @@ PLAN select * from t2606a intersect
project (
| distinct intersect (
| | project (
-| | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
) [ "%5"."a" ] [ "%5"."a" ASC ]
@@ -243,10 +243,10 @@ PLAN ( select * from t2606a intersect
project (
| distinct intersect (
| | project (
-| | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
) [ "%5"."a" ] [ "%5"."a" ASC ]
@@ -264,10 +264,10 @@ PLAN ( select * from t2606a ) intersect
project (
| distinct intersect (
| | project (
-| | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "%5"."a" ]
) [ "%5"."a" ] [ "%5"."a" ASC ]
@@ -286,12 +286,12 @@ project (
| distinct union (
| | project (
| | | group by (
-| | | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | | ) [ "t2606a"."a" ] [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
| | | group by (
-| | | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | | ) [ "t2606b"."a" ] [ "t2606b"."a" ]
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "t"."a" ]
@@ -316,10 +316,10 @@ PLAN select * from (select * from t2606a
project (
| distinct except (
| | project (
-| | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "t"."a" ]
) [ "t"."a" ] [ "t"."a" ASC ]
@@ -337,10 +337,10 @@ PLAN select * from (select * from t2606a
project (
| distinct intersect (
| | project (
-| | | table(sys.t2606a) [ "t2606a"."a" ] COUNT
+| | | table("sys"."t2606a") [ "t2606a"."a" ] COUNT
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table(sys.t2606b) [ "t2606b"."a" ] COUNT
+| | | table("sys"."t2606b") [ "t2606b"."a" ] COUNT
| | ) [ "t2606b"."a" as "%2"."a" ]
| ) [ "%1"."a" as "t"."a" ]
) [ "t"."a" ] [ "t"."a" ASC ]
diff --git a/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.test
b/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.test
--- a/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.test
+++ b/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.test
@@ -13,9 +13,9 @@ SELECT a as d, MIN(b), (2 * (MIN(b) / (S
----
project (
| group by (
-| | table(sys.dbg) [ "dbg"."a", "dbg"."b" ] COUNT
-| ) [ "dbg"."a" as "d" ] [ "d", sys.min no nil ("dbg"."b") as "%1"."%1" ]
-) [ "d", "%1"."%1", sys.sql_mul(sys.sql_div("%1"."%1", tinyint "2" as
"%2"."%2"), tinyint "2") as "f" ]
+| | table("sys"."dbg") [ "dbg"."a", "dbg"."b" ] COUNT
+| ) [ "dbg"."a" as "d" ] [ "d", "sys"."min" no nil ("dbg"."b") as "%1"."%1" ]
+) [ "d", "%1"."%1", "sys"."sql_mul"("sys"."sql_div"("%1"."%1", tinyint "2" as
"%2"."%2"), tinyint "2") as "f" ]
statement ok
set optimizer = 'sequential_pipe'
@@ -48,9 +48,9 @@ SELECT a as d, MIN(b) as e, (2 * (MIN(b)
----
project (
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
