Changeset: 1aaa7c03de27 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1aaa7c03de27
Modified Files:
sql/test/subquery/Tests/subquery3.sql
Branch: default
Log Message:
Queries with wrong results
diffs (32 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
@@ -206,6 +206,28 @@ HAVING (t1.col1 = ANY (SELECT MAX(ColID
-- 1
-- 1
+SELECT
+ col6,
+ col7,
+ NOT SUM(t1.col6) NOT IN (SELECT MAX(t2.col6) FROM another_T t2 GROUP BY
t1.col6 HAVING t1.col7 < MAX(t1.col6))
+FROM another_T t1
+GROUP BY t1.col7, t1.col6;
+ -- 6 7 False
+ -- 666 777 False
+ -- 6666 7777 False
+ -- 66 77 False
+
+SELECT
+ col6,
+ col7,
+ NOT SUM(t1.col6) NOT IN (SELECT MAX(t2.col6) FROM another_T t2 GROUP BY
t1.col6 HAVING t1.col7 < MAX(t2.col7 - t1.col6))
+FROM another_T t1
+GROUP BY t1.col7, t1.col6;
+ -- 6 7 False
+ -- 666 777 False
+ -- 6666 7777 False
+ -- 66 77 False
+
/* We shouldn't allow the following internal functions/procedures to be called
from regular queries */
--SELECT "identity"(col1) FROM another_T;
--SELECT "rowid"(col1) FROM another_T;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
