Changeset: e745682c66a1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e745682c66a1
Modified Files:
sql/test/subquery/Tests/subquery4.sql
Branch: Jun2020
Log Message:
Query giving MAL error. I think we have to check for type coercion for the IN
elements in case of subqueries.
My routine everyday starts by writing random queries for 15 minutes, in order
to find bugs :)
diffs (13 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
@@ -189,6 +189,9 @@ SELECT i1.i, i2.i FROM integers i1, inte
-- 3 3
-- 3 NULL
+SELECT 1 IN ((SELECT MIN(col2)), (SELECT SUM(col4))) FROM another_t;
+ -- False
+
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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
