Changeset: 0fb5c0ae599d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0fb5c0ae599d
Modified Files:
sql/test/miscellaneous/Tests/simple_plans.test
Branch: Jul2021
Log Message:
Added test case
diffs (32 lines):
diff --git a/sql/test/miscellaneous/Tests/simple_plans.test
b/sql/test/miscellaneous/Tests/simple_plans.test
--- a/sql/test/miscellaneous/Tests/simple_plans.test
+++ b/sql/test/miscellaneous/Tests/simple_plans.test
@@ -539,6 +539,28 @@ 3
user.main
1
+query T nosort
+plan select x, y from (select a as b, a / 3 as c from t1 intersect all select
a as z, a / 5 as d from t2) x(x,y) where x > 2
+----
+project (
+| intersect (
+| | project (
+| | | project (
+| | | | select (
+| | | | | table("sys"."t1") [ "t1"."a" ] COUNT
+| | | | ) [ "t1"."a" > int "2" ]
+| | | ) [ "t1"."a" as "b", "sys"."sql_div"("t1"."a", tinyint "3") as "c" ]
+| | ) [ "b" as "x"."x", "c" as "x"."y" ],
+| | project (
+| | | project (
+| | | | select (
+| | | | | table("sys"."t2") [ "t2"."a" ] COUNT
+| | | | ) [ "t2"."a" > int "2" ]
+| | | ) [ "t2"."a" as "z", "sys"."sql_div"("t2"."a", tinyint "5") as "d" ]
+| | ) [ "z" as "x"."x", "d" as "x"."y" ]
+| ) [ "x"."x", "x"."y" ]
+) [ "x"."x", "x"."y" ]
+
statement ok
rollback
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
