Changeset: 1c03f60e1b53 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1c03f60e1b53
Modified Files:
sql/test/subquery/Tests/subquery6.sql
sql/test/subquery/Tests/subquery6.stable.out
Branch: Jun2020
Log Message:
Approved output and a small new bug (cardinality check done wrong)
diffs (64 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
@@ -63,12 +63,24 @@ SELECT ColID FROM tbl_ProductSales WHERE
-- 3
-- 4
-SELECT SUM((SELECT col1)) FROM another_t;
+SELECT CAST(SUM((SELECT col1)) AS BIGINT) FROM another_t;
-- 1234
-SELECT SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) FROM another_t;
+SELECT CAST(SUM((SELECT col1 + col2)) AS BIGINT) FROM another_t;
+ -- 3702
+
+SELECT CAST(SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) AS BIGINT) FROM
another_t;
-- 4
+SELECT CAST(SUM((SELECT (SELECT col1 + col2))) AS BIGINT) FROM another_t;
+ -- 3702
+
+SELECT CAST((SELECT SUM((SELECT col1))) AS BIGINT) FROM another_t;
+ -- 1234
+
+SELECT CAST((SELECT SUM((SELECT col1 + col2))) AS BIGINT) FROM another_t;
+ -- 3702
+
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
@@ -65,15 +65,27 @@ stdout of test 'subquery6` in directory
#SELECT SUM((SELECT col1)) FROM another_t;
% sys.%2 # table_name
% %2 # name
-% hugeint # type
+% bigint # type
% 4 # length
[ 1234 ]
-#SELECT SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) FROM another_t;
+#SELECT CAST(SUM((SELECT col1 + col2)) AS BIGINT) FROM another_t;
+% sys.%2 # table_name
+% %2 # name
+% bigint # type
+% 4 # length
+[ 3702 ]
+#SELECT CAST(SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) AS BIGINT) FROM
another_t;
% sys.%3 # table_name
% %3 # name
-% hugeint # type
+% bigint # type
% 1 # length
[ 4 ]
+#SELECT CAST(SUM((SELECT (SELECT col1 + col2))) AS BIGINT) FROM another_t;
+% sys.%2 # table_name
+% %2 # name
+% bigint # type
+% 4 # length
+[ 3702 ]
#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
