Changeset: a107affc434b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a107affc434b
Added Files:
sql/test/SQLancer/Tests/sqlancer22.test
Modified Files:
sql/test/SQLancer/Tests/All
sql/test/SQLancer/Tests/sqlancer18.test
Branch: Jan2022
Log Message:
Split failing queries into failing test
diffs (86 lines):
diff --git a/sql/test/SQLancer/Tests/All b/sql/test/SQLancer/Tests/All
--- a/sql/test/SQLancer/Tests/All
+++ b/sql/test/SQLancer/Tests/All
@@ -19,3 +19,4 @@ sqlancer18
sqlancer19
sqlancer20
KNOWNFAIL?sqlancer21
+KNOWNFAIL?sqlancer22
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,38 +601,6 @@ select (case when false then v100.vc1 wh
0
0
-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 I nosort
-SELECT (SELECT 'a' FROM v1) <> ALL(SELECT 'b' FROM t2) FROM v2
-----
-1
-
-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 I nosort
SELECT ((SELECT 5) INTERSECT (SELECT 9)) = ALL(SELECT 4) >= TRUE
----
diff --git a/sql/test/SQLancer/Tests/sqlancer22.test
b/sql/test/SQLancer/Tests/sqlancer22.test
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer22.test
@@ -0,0 +1,31 @@
+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 I nosort
+SELECT (SELECT 'a' FROM v1) <> ALL(SELECT 'b' FROM t2) FROM v2
+----
+1
+
+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
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
