Changeset: 6d67091e75a1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6d67091e75a1
Modified Files:
sql/test/out2in/Tests/out2in.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (104 lines):
diff --git a/sql/test/out2in/Tests/out2in.stable.out
b/sql/test/out2in/Tests/out2in.stable.out
--- a/sql/test/out2in/Tests/out2in.stable.out
+++ b/sql/test/out2in/Tests/out2in.stable.out
@@ -68,12 +68,12 @@ stdout of test 'out2in` in directory 'sq
% .plan # table_name
% rel # name
% clob # type
-% 41 # length
+% 45 # length
project (
| join (
-| | table(sys.foo) [ "foo"."i" ] COUNT ,
+| | table("sys"."foo") [ "foo"."i" ] COUNT ,
| | select (
-| | | table(sys.bar) [ "bar"."i" ] COUNT
+| | | table("sys"."bar") [ "bar"."i" ] COUNT
| | ) [ "bar"."i" ! * = int "NULL" ]
| ) [ "foo"."i" = "bar"."i" ]
) [ "foo"."i", "bar"."i" ]
@@ -81,12 +81,12 @@ project (
% .plan # table_name
% rel # name
% clob # type
-% 52 # length
+% 56 # length
project (
| join (
-| | table(sys.foo) [ "foo"."i" ] COUNT ,
+| | table("sys"."foo") [ "foo"."i" ] COUNT ,
| | select (
-| | | table(sys.bar) [ "bar"."i", "bar"."j" ] COUNT
+| | | table("sys"."bar") [ "bar"."i", "bar"."j" ] COUNT
| | ) [ "bar"."j" ! * = int "NULL" ]
| ) [ "foo"."i" = "bar"."i" ]
) [ "foo"."i", "bar"."i" ]
@@ -94,38 +94,38 @@ project (
% .plan # table_name
% rel # name
% clob # type
-% 173 # length
+% 185 # length
project (
| join (
| | select (
-| | | table(sys.foo) [ "foo"."i" ] COUNT
-| | ) [ (sys.sql_mul(tinyint "2", "foo"."i") > bigint "20") or
(sys.sql_mul("foo"."i", tinyint "2") > bigint "400", sys.sql_mul("foo"."i",
"foo"."i") = bigint["foo"."i"]) ],
-| | table(sys.bar) [ "bar"."i" ] COUNT
+| | | table("sys"."foo") [ "foo"."i" ] COUNT
+| | ) [ ("sys"."sql_mul"(tinyint "2", "foo"."i") > bigint "20") or
("sys"."sql_mul"("foo"."i", tinyint "2") > bigint "400",
"sys"."sql_mul"("foo"."i", "foo"."i") = bigint["foo"."i"]) ],
+| | table("sys"."bar") [ "bar"."i" ] COUNT
| ) [ "foo"."i" = "bar"."i" ]
) [ "foo"."i", "bar"."i" ]
#PLAN SELECT foo.i, bar.i FROM foo FULL OUTER JOIN bar ON foo.i = bar.i WHERE
(2*foo.i > 20 OR (400 < foo.i*2 AND foo.i*foo.i = foo.i));
% .plan # table_name
% rel # name
% clob # type
-% 173 # length
+% 185 # length
project (
| left outer join (
| | select (
-| | | table(sys.foo) [ "foo"."i" ] COUNT
-| | ) [ (sys.sql_mul(tinyint "2", "foo"."i") > bigint "20") or
(sys.sql_mul("foo"."i", tinyint "2") > bigint "400", sys.sql_mul("foo"."i",
"foo"."i") = bigint["foo"."i"]) ],
-| | table(sys.bar) [ "bar"."i" ] COUNT
+| | | table("sys"."foo") [ "foo"."i" ] COUNT
+| | ) [ ("sys"."sql_mul"(tinyint "2", "foo"."i") > bigint "20") or
("sys"."sql_mul"("foo"."i", tinyint "2") > bigint "400",
"sys"."sql_mul"("foo"."i", "foo"."i") = bigint["foo"."i"]) ],
+| | table("sys"."bar") [ "bar"."i" ] COUNT
| ) [ "foo"."i" = "bar"."i" ]
) [ "foo"."i", "bar"."i" ]
#PLAN SELECT foo.i, bar.i FROM foo FULL OUTER JOIN bar ON foo.i = bar.i WHERE
bar.j IS NOT NULL;
% .plan # table_name
% rel # name
% clob # type
-% 52 # length
+% 56 # length
project (
| right outer join (
-| | table(sys.foo) [ "foo"."i" ] COUNT ,
+| | table("sys"."foo") [ "foo"."i" ] COUNT ,
| | select (
-| | | table(sys.bar) [ "bar"."i", "bar"."j" ] COUNT
+| | | table("sys"."bar") [ "bar"."i", "bar"."j" ] COUNT
| | ) [ "bar"."j" ! * = int "NULL" ]
| ) [ "foo"."i" = "bar"."i" ]
) [ "foo"."i", "bar"."i" ]
@@ -133,14 +133,14 @@ project (
% .plan # table_name
% rel # name
% clob # type
-% 173 # length
+% 185 # length
project (
| join (
| | select (
-| | | table(sys.foo) [ "foo"."i" ] COUNT
-| | ) [ (sys.sql_mul(tinyint "2", "foo"."i") > bigint "20") or
(sys.sql_mul("foo"."i", tinyint "2") > bigint "400", sys.sql_mul("foo"."i",
"foo"."i") = bigint["foo"."i"]) ],
+| | | table("sys"."foo") [ "foo"."i" ] COUNT
+| | ) [ ("sys"."sql_mul"(tinyint "2", "foo"."i") > bigint "20") or
("sys"."sql_mul"("foo"."i", tinyint "2") > bigint "400",
"sys"."sql_mul"("foo"."i", "foo"."i") = bigint["foo"."i"]) ],
| | select (
-| | | table(sys.bar) [ "bar"."i", "bar"."j" ] COUNT
+| | | table("sys"."bar") [ "bar"."i", "bar"."j" ] COUNT
| | ) [ "bar"."j" ! * = int "NULL" ]
| ) [ "foo"."i" = "bar"."i" ]
) [ "foo"."i", "bar"."i" ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
