Changeset: a78f788ac036 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a78f788ac036
Modified Files:
        sql/test/subquery/Tests/correlated.sql
Branch: Nov2019
Log Message:

New bug, correlated subquery with aggregation in where clause outputting error


diffs (13 lines):

diff --git a/sql/test/subquery/Tests/correlated.sql 
b/sql/test/subquery/Tests/correlated.sql
--- a/sql/test/subquery/Tests/correlated.sql
+++ b/sql/test/subquery/Tests/correlated.sql
@@ -138,6 +138,9 @@ SELECT CAST((SELECT SUM(i1.i)) AS BIGINT
 -- subquery inside aggregation
 SELECT CAST(SUM(i) AS BIGINT), CAST(SUM((SELECT i FROM integers WHERE i=i1.i)) 
AS BIGINT) FROM integers i1; -- 6, 6
 SELECT CAST(SUM(i) AS BIGINT), CAST((SELECT SUM(i) FROM integers WHERE 
i>SUM(i1.i)) AS BIGINT) FROM integers i1; -- 6, NULL
+
+SELECT CAST((SELECT SUM(i) FROM integers WHERE i>SUM(i1.i)) AS BIGINT) FROM 
integers i1; -- NULL
+
 -- subquery with aggregation inside aggregation should fail
 SELECT SUM((SELECT SUM(i))) FROM integers; -- error
 -- aggregate with correlation in filter
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to