Changeset: 5ced31a9c7d9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5ced31a9c7d9
Modified Files:
sql/test/SQLancer/Tests/sqlancer18.test
Branch: Jan2022
Log Message:
Subquery with wrong results
diffs (42 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer18.test
b/sql/test/SQLancer/Tests/sqlancer18.test
--- a/sql/test/SQLancer/Tests/sqlancer18.test
+++ b/sql/test/SQLancer/Tests/sqlancer18.test
@@ -601,6 +601,38 @@ select (case when false then v100.vc1 wh
False
False
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t2" ("c0" INT)
+
+statement ok
+create view v1(vc0) as (select 1 where false)
+
+statement ok
+create view v2(vc0) as (select true)
+
+query T nosort
+SELECT (SELECT 'a' FROM v1) <> ALL(SELECT 'b' FROM t2) FROM v2
+----
+True
+
+query I nosort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((SELECT 'a' FROM v1) <>
ALL((SELECT 'b' FROM t2) UNION (SELECT 'c' FROM v1)) AS INT)
+as count FROM v2) as res
+----
+1
+
+# this one is right
+query I nosort
+SELECT 1 FROM v2 WHERE (SELECT 'a' FROM v1) <> ALL((SELECT 'b' FROM t2) UNION
(SELECT 'c' FROM v1))
+----
+1
+
+statement ok
+ROLLBACK
+
query T nosort
SELECT ((SELECT 5) INTERSECT (SELECT 9)) = ALL(SELECT 4) >= TRUE
----
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
