Changeset: 316df1303705 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/316df1303705
Modified Files:
sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320-Windows.test
sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.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-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-2021/Tests/plan-not-optimal-view.Bug-7140.test
sql/test/BugTracker/Tests/explain.SF-1739353.test
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test
Branch: properties
Log Message:
Approvals
diffs (truncated from 890 to 300 lines):
diff --git
a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320-Windows.test
b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320-Windows.test
--- a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320-Windows.test
+++ b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320-Windows.test
@@ -8,7 +8,7 @@ query T nosort
plan copy into cm_tmp from E'\\file1',E'\\file2'
----
insert(
-| table("sys"."cm_tmp") [ "cm_tmp"."i", "cm_tmp"."%TID%" NOT NULL UNIQUE ]
+| table("sys"."cm_tmp") [ "cm_tmp"."i" NOT NULL, "cm_tmp"."%TID%" NOT NULL
UNIQUE ]
| union (
| | project (
| | | table ("sys"."copyfrom"(table("cm_tmp"), varchar "|", varchar "\n",
varchar NULL, varchar "null", varchar "\\file1", bigint(19) "-1", bigint(19)
"0", int(9) "0", varchar NULL, int(9) "0", int(9) "1"),
@@ -25,7 +25,7 @@ query T nosort
plan copy into cm_tmp from E'a:\\file1','Z:/file2'
----
insert(
-| table("sys"."cm_tmp") [ "cm_tmp"."i", "cm_tmp"."%TID%" NOT NULL UNIQUE ]
+| table("sys"."cm_tmp") [ "cm_tmp"."i" NOT NULL, "cm_tmp"."%TID%" NOT NULL
UNIQUE ]
| union (
| | project (
| | | table ("sys"."copyfrom"(table("cm_tmp"), varchar "|", varchar "\n",
varchar NULL, varchar "null", varchar "a:\\file1", bigint(19) "-1", bigint(19)
"0", int(9) "0", varchar NULL, int(9) "0", int(9) "1"),
diff --git a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test
b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test
--- a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test
+++ b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test
@@ -5,7 +5,7 @@ query T nosort
plan copy into cm_tmp from '/file1','/file2'
----
insert(
-| table("sys"."cm_tmp") [ "cm_tmp"."i", "cm_tmp"."%TID%" NOT NULL UNIQUE ]
+| table("sys"."cm_tmp") [ "cm_tmp"."i" NOT NULL, "cm_tmp"."%TID%" NOT NULL
UNIQUE ]
| union (
| | project (
| | | table ("sys"."copyfrom"(table("cm_tmp"), varchar "|", varchar "\n",
varchar NULL, varchar "null", varchar "/file1", bigint(18) "-1", bigint(18)
"0", int(9) "0", varchar NULL, int(9) "0", int(9) "1"),
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
@@ -69,14 +69,14 @@ project (
| | | group by (
| | | | table("sys"."t2606a") [ "t2606a"."a" ]
| | | ) [ "t2606a"."a" ] [ "t2606a"."a" ]
-| | ) [ "t2606a"."a" as "%1"."a" ],
+| | ) [ "t2606a"."a" UNIQUE as "%1"."a" ],
| | project (
| | | group by (
| | | | table("sys"."t2606b") [ "t2606b"."a" ]
| | | ) [ "t2606b"."a" ] [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
select * from t2606a union select * from t2606b order by a
@@ -100,14 +100,14 @@ project (
| | | group by (
| | | | table("sys"."t2606a") [ "t2606a"."a" ]
| | | ) [ "t2606a"."a" ] [ "t2606a"."a" ]
-| | ) [ "t2606a"."a" as "%1"."a" ],
+| | ) [ "t2606a"."a" UNIQUE as "%1"."a" ],
| | project (
| | | group by (
| | | | table("sys"."t2606b") [ "t2606b"."a" ]
| | | ) [ "t2606b"."a" ] [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
( select * from t2606a union select * from t2606b ) order by a
@@ -131,14 +131,14 @@ project (
| | | group by (
| | | | table("sys"."t2606a") [ "t2606a"."a" ]
| | | ) [ "t2606a"."a" ] [ "t2606a"."a" ]
-| | ) [ "t2606a"."a" as "%1"."a" ],
+| | ) [ "t2606a"."a" UNIQUE as "%1"."a" ],
| | project (
| | | group by (
| | | | table("sys"."t2606b") [ "t2606b"."a" ]
| | | ) [ "t2606b"."a" ] [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
( select * from t2606a ) union ( select * from t2606b ) order by a
@@ -164,8 +164,8 @@ project (
| | project (
| | | table("sys"."t2606b") [ "t2606b"."a" ]
| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
select * from t2606a except select * from t2606b order by a
@@ -183,10 +183,10 @@ project (
| | | table("sys"."t2606a") [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table("sys"."t2606b") [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| | | table("sys"."t2606b") [ "t2606b"."a" UNIQUE ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
( select * from t2606a except select * from t2606b ) order by a
@@ -204,10 +204,10 @@ project (
| | | table("sys"."t2606a") [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table("sys"."t2606b") [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| | | table("sys"."t2606b") [ "t2606b"."a" UNIQUE ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
( select * from t2606a ) except ( select * from t2606b ) order by a
@@ -225,10 +225,10 @@ project (
| | | table("sys"."t2606a") [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table("sys"."t2606b") [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| | | table("sys"."t2606b") [ "t2606b"."a" UNIQUE ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
select * from t2606a intersect select * from t2606b order by a
@@ -246,10 +246,10 @@ project (
| | | table("sys"."t2606a") [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table("sys"."t2606b") [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| | | table("sys"."t2606b") [ "t2606b"."a" UNIQUE ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
( select * from t2606a intersect select * from t2606b ) order by a
@@ -267,10 +267,10 @@ project (
| | | table("sys"."t2606a") [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table("sys"."t2606b") [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "%5"."a" ]
-) [ "%5"."a" ] [ "%5"."a" ASC ]
+| | | table("sys"."t2606b") [ "t2606b"."a" UNIQUE ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "%5"."a" ]
+) [ "%5"."a" UNIQUE ] [ "%5"."a" ASC UNIQUE ]
query I rowsort
( select * from t2606a ) intersect ( select * from t2606b ) order by a
@@ -288,14 +288,14 @@ project (
| | | group by (
| | | | table("sys"."t2606a") [ "t2606a"."a" ]
| | | ) [ "t2606a"."a" ] [ "t2606a"."a" ]
-| | ) [ "t2606a"."a" as "%1"."a" ],
+| | ) [ "t2606a"."a" UNIQUE as "%1"."a" ],
| | project (
| | | group by (
-| | | | table("sys"."t2606b") [ "t2606b"."a" ]
-| | | ) [ "t2606b"."a" ] [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "t"."a" ]
-) [ "t"."a" ] [ "t"."a" ASC ]
+| | | | table("sys"."t2606b") [ "t2606b"."a" UNIQUE ]
+| | | ) [ "t2606b"."a" UNIQUE ] [ "t2606b"."a" UNIQUE ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "t"."a" ]
+) [ "t"."a" UNIQUE ] [ "t"."a" ASC UNIQUE ]
query I rowsort
select * from (select * from t2606a union select * from t2606b) as t
order by a
@@ -319,10 +319,10 @@ project (
| | | table("sys"."t2606a") [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table("sys"."t2606b") [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "t"."a" ]
-) [ "t"."a" ] [ "t"."a" ASC ]
+| | | table("sys"."t2606b") [ "t2606b"."a" UNIQUE ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "t"."a" ]
+) [ "t"."a" UNIQUE ] [ "t"."a" ASC UNIQUE ]
query I rowsort
select * from (select * from t2606a except select * from t2606b) as t
order by a
@@ -340,10 +340,10 @@ project (
| | | table("sys"."t2606a") [ "t2606a"."a" ]
| | ) [ "t2606a"."a" as "%1"."a" ],
| | project (
-| | | table("sys"."t2606b") [ "t2606b"."a" ]
-| | ) [ "t2606b"."a" as "%2"."a" ]
-| ) [ "%1"."a" as "t"."a" ]
-) [ "t"."a" ] [ "t"."a" ASC ]
+| | | table("sys"."t2606b") [ "t2606b"."a" UNIQUE ]
+| | ) [ "t2606b"."a" UNIQUE as "%2"."a" ]
+| ) [ "%1"."a" UNIQUE as "t"."a" ]
+) [ "t"."a" UNIQUE ] [ "t"."a" ASC UNIQUE ]
query I rowsort
select * from (select * from t2606a intersect select * from t2606b) as t
order by a
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" ]
-| ) [ "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)
"2"), tinyint(2) "2") as "f" ]
+| | table("sys"."dbg") [ "dbg"."a" UNIQUE, "dbg"."b" UNIQUE ]
+| ) [ "dbg"."a" as "d" ] [ "d", "sys"."min" no nil ("dbg"."b" UNIQUE) as
"%1"."%1" ]
+) [ "d" UNIQUE, "%1"."%1", "sys"."sql_mul"("sys"."sql_div"("%1"."%1",
tinyint(2) "2"), tinyint(2) "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 (
| group by (
-| | table("sys"."dbg") [ "dbg"."a", "dbg"."b" ]
-| ) [ "dbg"."a" as "d" ] [ "d", "sys"."min" no nil ("dbg"."b") as "%1"."%1" ]
-) [ "d", "%1"."%1" as "e", "sys"."sql_mul"("sys"."sql_div"("%1"."%1",
tinyint(2) "2"), tinyint(2) "2") as "f" ]
+| | table("sys"."dbg") [ "dbg"."a" UNIQUE, "dbg"."b" UNIQUE ]
+| ) [ "dbg"."a" as "d" ] [ "d", "sys"."min" no nil ("dbg"."b" UNIQUE) as
"%1"."%1" ]
+) [ "d" UNIQUE, "%1"."%1" as "e", "sys"."sql_mul"("sys"."sql_div"("%1"."%1",
tinyint(2) "2"), tinyint(2) "2") as "f" ]
statement ok
set optimizer = 'sequential_pipe'
diff --git a/sql/test/BugTracker-2013/Tests/rangejoin_optimizer.Bug-3411.test
b/sql/test/BugTracker-2013/Tests/rangejoin_optimizer.Bug-3411.test
--- a/sql/test/BugTracker-2013/Tests/rangejoin_optimizer.Bug-3411.test
+++ b/sql/test/BugTracker-2013/Tests/rangejoin_optimizer.Bug-3411.test
@@ -9,10 +9,10 @@ WHERE t2.a between t1.a and t1.b
----
project (
| join (
-| | table("sys"."t4311") [ "t4311"."a" as "t2"."a" ],
-| | table("sys"."t4311") [ "t4311"."a" as "t1"."a", "t4311"."b" as "t1"."b" ]
-| ) [ ("t1"."a") <= ("t2"."a") <= ("t1"."b") ]
-) [ "t2"."a" ]
+| | table("sys"."t4311") [ "t4311"."a" NOT NULL as "t2"."a" ],
+| | table("sys"."t4311") [ "t4311"."a" NOT NULL as "t1"."a", "t4311"."b" NOT
NULL as "t1"."b" ]
+| ) [ ("t1"."a" NOT NULL) <= ("t2"."a" NOT NULL) <= ("t1"."b" NOT NULL) ]
+) [ "t2"."a" NOT NULL ]
query T nosort
PLAN
@@ -23,10 +23,10 @@ AND t2.a <= t1.b
----
project (
| join (
-| | table("sys"."t4311") [ "t4311"."a" as "t2"."a" ],
-| | table("sys"."t4311") [ "t4311"."a" as "t1"."a", "t4311"."b" as "t1"."b" ]
-| ) [ ("t1"."a") <= ("t2"."a") <= ("t1"."b") ]
-) [ "t2"."a" ]
+| | table("sys"."t4311") [ "t4311"."a" NOT NULL as "t2"."a" ],
+| | table("sys"."t4311") [ "t4311"."a" NOT NULL as "t1"."a", "t4311"."b" NOT
NULL as "t1"."b" ]
+| ) [ ("t1"."a" NOT NULL) <= ("t2"."a" NOT NULL) <= ("t1"."b" NOT NULL) ]
+) [ "t2"."a" NOT NULL ]
query T nosort
PLAN
@@ -37,10 +37,10 @@ AND t1.b >= t2.a
----
project (
| join (
-| | table("sys"."t4311") [ "t4311"."a" as "t2"."a" ],
-| | table("sys"."t4311") [ "t4311"."a" as "t1"."a", "t4311"."b" as "t1"."b" ]
-| ) [ ("t1"."a") <= ("t2"."a") <= ("t1"."b") ]
-) [ "t2"."a" ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
