Changeset: f75b07d8503f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f75b07d8503f
Modified Files:
sql/test/subquery/Tests/subquery5.sql
Branch: Jun2020
Log Message:
More fun
diffs (22 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
@@ -272,6 +272,18 @@ SELECT SUM(i1.i) FROM integers i1 HAVING
SELECT MAX(i1.i) FROM integers i1 HAVING (VALUES((AVG(i1.i))) EXCEPT
VALUES(AVG(i1.i))) <> 0;
--empty
+SELECT (VALUES(SUM(i1.i)) UNION VALUES(AVG(i1.i))) FROM integers i1;
+ --error, more than one row returned by a subquery used as an expression
+
+SELECT ((SELECT SUM(i1.i)) UNION ALL (SELECT AVG(i1.i))) FROM integers i1;
+ --error, more than one row returned by a subquery used as an expression
+
+SELECT ((SELECT i1.i NOT IN (SELECT i1.i)) UNION (SELECT SUM(i1.i) IN (SELECT
i1.i))) FROM integers i1;
+ --error, subquery uses ungrouped column "i1.i" from outer query
+
+SELECT (SELECT 6 EXCEPT (SELECT SUM(i1.i))) IN (SELECT 1) FROM integers i1; --
OPTmergetableImplementation: !ERROR: Mergetable bailout on group input reuse in
group statement
+ -- NULL
+
DROP FUNCTION evilfunction(INT);
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
