Changeset: 27c8efea0cbc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=27c8efea0cbc
Modified Files:
sql/test/subquery/Tests/subquery4.sql
Branch: default
Log Message:
merged
diffs (15 lines):
diff --git a/sql/test/subquery/Tests/subquery4.sql
b/sql/test/subquery/Tests/subquery4.sql
--- a/sql/test/subquery/Tests/subquery4.sql
+++ b/sql/test/subquery/Tests/subquery4.sql
@@ -97,6 +97,11 @@ SELECT i FROM integers WHERE (SELECT COU
-- 2
-- 3
+SELECT
+ (SELECT MAX(i2.i) FROM (SELECT MIN(i1.i)) AS i2(i))
+FROM integers i1;
+ -- 1
+
UPDATE another_T SET col1 = MIN(col1); --error, aggregates not allowed in
update set clause
UPDATE another_T SET col2 = 1 WHERE col1 = SUM(col2); --error, aggregates not
allowed in update set clause
UPDATE another_T SET col3 = (SELECT MAX(col5)); --error, aggregates not
allowed in update set clause
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
