Changeset: d4d2585ad829 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d4d2585ad829
Modified Files:
sql/test/subquery/Tests/subquery3.sql
Branch: default
Log Message:
Query with wrong error
diffs (15 lines):
diff --git a/sql/test/subquery/Tests/subquery3.sql
b/sql/test/subquery/Tests/subquery3.sql
--- a/sql/test/subquery/Tests/subquery3.sql
+++ b/sql/test/subquery/Tests/subquery3.sql
@@ -309,6 +309,11 @@ GROUP BY t1.col6;
-- 1
SELECT
+ SUM(SUM(t1.col7) * CAST (NOT t1.col1 IN (SELECT 1) AS INTEGER)) OVER ()
+FROM another_T t1
+GROUP BY t1.col7; --error, column "t1.col1" must appear in the GROUP BY clause
or be used in an aggregate function
+
+SELECT
SUM(CAST(SUM(t1.col6 * CAST (NOT t1.col1 IN (SELECT t2.col2 FROM another_T
t2 GROUP BY t2.col2) AS INTEGER)) < ANY (SELECT MAX(ColID + t1.col7 - t1.col2)
FROM tbl_ProductSales) AS INT)) OVER (PARTITION BY SUM(t1.col5) ORDER BY
(SELECT MIN(t1.col6 + t1.col5 - t2.col2) FROM another_T t2))
FROM another_T t1
GROUP BY t1.col7, t1.col6; --error, subquery uses ungrouped column "t1.col2"
from outer query
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
