Changeset: 706503fc2cd2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=706503fc2cd2
Modified Files:
sql/test/SQLancer/Tests/sqlancer10.test
Branch: default
Log Message:
Queries with wrong results
diffs (90 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer10.test
b/sql/test/SQLancer/Tests/sqlancer10.test
--- a/sql/test/SQLancer/Tests/sqlancer10.test
+++ b/sql/test/SQLancer/Tests/sqlancer10.test
@@ -403,3 +403,86 @@ TRUE
statement ok
ROLLBACK
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0" ("c0" INTEGER,"c1" BOOLEAN NOT NULL,"c3" CHARACTER LARGE
OBJECT,CONSTRAINT "t0_c1_pkey" PRIMARY KEY ("c1"))
+
+statement ok
+COPY 2 RECORDS INTO "t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0 false ""
+NULL true "A8TW"
+
+statement ok
+CREATE TABLE "t1" ("c1" BOOLEAN,"c3" BOOLEAN)
+
+statement ok
+COPY 18 RECORDS INTO "t1" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+false false
+false false
+NULL false
+true NULL
+true true
+false false
+false false
+true NULL
+true false
+false false
+false false
+NULL NULL
+NULL true
+NULL true
+NULL true
+NULL false
+NULL true
+NULL false
+
+statement ok
+CREATE TABLE "t2" ("c3" DECIMAL(18,3),"c2" TINYINT)
+
+statement ok
+COPY 15 RECORDS INTO "t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0.046 9
+0.046 9
+0.046 9
+0.046 9
+0.046 9
+0.046 9
+0.046 9
+0.046 9
+0.046 9
+NULL 0
+0.046 9
+0.046 9
+0.046 9
+0.046 9
+NULL 2
+
+query I rowsort
+SELECT 1 FROM t1 RIGHT OUTER JOIN (SELECT 2) AS sub0 ON least((SELECT true
WHERE FALSE), true) WHERE NOT EXISTS ((SELECT 'b' WHERE FALSE) UNION ALL
(SELECT 'a'))
+----
+
+
+query T rowsort
+SELECT ALL t1.c1 FROM t0, t1 RIGHT OUTER JOIN ((SELECT DISTINCT ((least(6,
529595761))-(least(4, 1032827696))), least(-859534381,
0.01807380825433357873777140412130393087863922119140625)
+FROM t0, t1 WHERE t0.c1 GROUP BY t1.c3) EXCEPT ALL (SELECT ALL - (COALESCE(2,
0.78330755, 0.6467953977457632230851913845981471240520477294921875, 1)), -
(0.24474563528854787) FROM t0, t1 WHERE t1.c3)) AS sub0 ON
+least(((SELECT ALL l2t0.c1 FROM t0 AS l2t0, t2 AS l2t2, t1 AS l2t1 WHERE
FALSE) UNION ALL (SELECT DISTINCT l2t0.c1 FROM t0 AS l2t0 WHERE l2t0.c1)),
(t1.c3) BETWEEN ASYMMETRIC (t1.c1) AND (t1.c1)) WHERE
+NOT EXISTS ((SELECT DISTINCT NULLIF('0.9825037007815074', 'sqR]&'), 20 WHERE
FALSE) UNION ALL (SELECT DISTINCT NULLIF(l1t0.c3, l1t0.c3), - (4) FROM t0 AS
l1t0 WHERE l1t0.c1))
+----
+
+
+query I rowsort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(NOT EXISTS ((SELECT
DISTINCT NULLIF('0.9825037007815074', 'sqR]&'), 20 WHERE FALSE) UNION ALL
(SELECT DISTINCT NULLIF(l1t0.c3, l1t0.c3), - (4) FROM
+t0 AS l1t0 WHERE l1t0.c1)) AS INT) as count FROM t0, t1 RIGHT OUTER JOIN
((SELECT DISTINCT ((least(6, 529595761))-(least(4, 1032827696))),
least(-859534381, 0.01807380825433357873777140412130393087863922119140625)
+FROM t0, t1 WHERE t0.c1 GROUP BY t1.c3) EXCEPT ALL (SELECT ALL - (COALESCE(2,
0.78330755, 0.6467953977457632230851913845981471240520477294921875, 1)), -
(0.24474563528854787) FROM t0, t1 WHERE t1.c3)) AS sub0
+ON least(((SELECT l2t0.c1 FROM t0 AS l2t0, t2 AS l2t2, t1 AS l2t1 WHERE FALSE)
UNION ALL (SELECT DISTINCT l2t0.c1 FROM t0 AS l2t0 WHERE l2t0.c1)), (t1.c3)
BETWEEN ASYMMETRIC (t1.c1) AND (t1.c1))) as res
+----
+0
+
+statement ok
+ROLLBACK
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
