Changeset: 7363d0f8b222 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7363d0f8b222
Modified Files:
sql/test/subquery/Tests/subquery6.sql
Branch: default
Log Message:
Starting the day with a breakfast crash. Looking into it
diffs (19 lines):
diff --git a/sql/test/subquery/Tests/subquery6.sql
b/sql/test/subquery/Tests/subquery6.sql
--- a/sql/test/subquery/Tests/subquery6.sql
+++ b/sql/test/subquery/Tests/subquery6.sql
@@ -231,6 +231,15 @@ select lag('bug') over (), lag('bug', 1)
select lead('bug') over (), lead('bug', 1) over (), lead('bug', 0) over (),
lead('bug', 1, 'oth') over (), lead('bug', 0, 'oth') over (), max(TotalSales)
from tbl_ProductSales;
-- NULL NULL bug oth bug 500
+select 1 = any(ColID), max(totalsales) from tbl_ProductSales;
+ -- error, cannot use non GROUP BY column 'ColID' in query results
without an aggregate function
+
+select 1 in (ColID), max(totalsales) from tbl_ProductSales;
+ -- error, cannot use non GROUP BY column 'ColID' in query results
without an aggregate function
+
+select 1 in (ColID, (select 1)), max(totalsales) from tbl_ProductSales;
+ -- error, cannot use non GROUP BY column 'ColID' in query results
without an aggregate function
+
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
DROP TABLE integers;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
