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