Changeset: 2905ff404d94 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2905ff404d94
Modified Files:
sql/test/subquery/Tests/subquery5.sql
sql/test/subquery/Tests/subquery5.stable.out
Branch: Jun2020
Log Message:
No hugeint in the output
diffs (24 lines):
diff --git a/sql/test/subquery/Tests/subquery5.sql
b/sql/test/subquery/Tests/subquery5.sql
--- a/sql/test/subquery/Tests/subquery5.sql
+++ b/sql/test/subquery/Tests/subquery5.sql
@@ -266,7 +266,7 @@ HAVING (((SELECT MIN(i2.i + i1.i) FROM i
SELECT (VALUES (SUM(i1.i)),(AVG(i1.i)) INTERSECT VALUES(AVG(i1.i))) FROM
integers i1;
-- 2.0
-SELECT SUM(i1.i) FROM integers i1 HAVING (VALUES(SUM(i1.i)),(AVG(i1.i))
INTERSECT VALUES(AVG(i1.i))) > 0;
+SELECT CAST(SUM(i1.i) AS BIGINT) FROM integers i1 HAVING
(VALUES(SUM(i1.i)),(AVG(i1.i)) INTERSECT VALUES(AVG(i1.i))) > 0;
-- 6
SELECT MAX(i1.i) FROM integers i1 HAVING (VALUES((AVG(i1.i))) EXCEPT
VALUES(AVG(i1.i))) <> 0;
diff --git a/sql/test/subquery/Tests/subquery5.stable.out
b/sql/test/subquery/Tests/subquery5.stable.out
--- a/sql/test/subquery/Tests/subquery5.stable.out
+++ b/sql/test/subquery/Tests/subquery5.stable.out
@@ -290,7 +290,7 @@ stdout of test 'subquery5` in directory
#SELECT SUM(i1.i) FROM integers i1 HAVING (VALUES(SUM(i1.i)),(AVG(i1.i))
INTERSECT VALUES(AVG(i1.i))) > 0;
% .%1 # table_name
% %1 # name
-% hugeint # type
+% bigint # type
% 1 # length
[ 6 ]
#SELECT MAX(i1.i) FROM integers i1 HAVING (VALUES((AVG(i1.i))) EXCEPT
VALUES(AVG(i1.i))) <> 0;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
