Changeset: 9eb951b718c3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9eb951b718c3
Modified Files:
sql/test/subquery/Tests/subquery6.sql
sql/test/subquery/Tests/subquery6.stable.out
Branch: Jun2020
Log Message:
Approved output
diffs (77 lines):
diff --git a/sql/test/subquery/Tests/subquery6.sql
b/sql/test/subquery/Tests/subquery6.sql
--- a/sql/test/subquery/Tests/subquery6.sql
+++ b/sql/test/subquery/Tests/subquery6.sql
@@ -87,6 +87,10 @@ SELECT (SELECT 1 FROM another_t t1 WHERE
-- NULL
-- NULL
+SELECT t1.colid FROM tbl_productsales t1 INNER JOIN tbl_productsales t2 ON
t1.product_category NOT LIKE t2.product_category ORDER BY t1.colid;
+
+SELECT t1.colid FROM tbl_productsales t1 INNER JOIN tbl_productsales t2 ON
t1.product_category NOT LIKE t2.product_name ORDER BY t1.colid;
+
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
DROP TABLE integers;
diff --git a/sql/test/subquery/Tests/subquery6.stable.out
b/sql/test/subquery/Tests/subquery6.stable.out
--- a/sql/test/subquery/Tests/subquery6.stable.out
+++ b/sql/test/subquery/Tests/subquery6.stable.out
@@ -33,14 +33,14 @@ stdout of test 'subquery6` in directory
% tinyint # type
% 1 # length
#SELECT (SELECT (SELECT SUM(col1)) IN (MAX(col2))) FROM another_t;
-% sys.%6 # table_name
-% %6 # name
+% sys.%5 # table_name
+% %5 # name
% boolean # type
% 5 # length
[ false ]
#SELECT (SELECT (SELECT SUM(col1)) IN (MAX(col2), '12')) FROM another_t;
-% sys.%7 # table_name
-% %7 # name
+% sys.%6 # table_name
+% %6 # name
% boolean # type
% 5 # length
[ false ]
@@ -107,6 +107,40 @@ stdout of test 'subquery6` in directory
[ NULL ]
[ NULL ]
[ NULL ]
+#SELECT t1.colid FROM tbl_productsales t1 INNER JOIN tbl_productsales t2 ON
t1.product_category NOT LIKE t2.product_category ORDER BY t1.colid;
+% sys.t1 # table_name
+% colid # name
+% int # type
+% 1 # length
+[ 1 ]
+[ 1 ]
+[ 2 ]
+[ 2 ]
+[ 3 ]
+[ 3 ]
+[ 4 ]
+[ 4 ]
+#SELECT t1.colid FROM tbl_productsales t1 INNER JOIN tbl_productsales t2 ON
t1.product_category NOT LIKE t2.product_name ORDER BY t1.colid;
+% sys.t1 # table_name
+% colid # name
+% int # type
+% 1 # length
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 2 ]
+[ 2 ]
+[ 2 ]
+[ 2 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 4 ]
+[ 4 ]
+[ 4 ]
+[ 4 ]
#DROP TABLE tbl_ProductSales;
#DROP TABLE another_T;
#DROP TABLE integers;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
