Changeset: f587bb85dcc2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f587bb85dcc2
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
Branch: Oct2020
Log Message:
SQLancer queries with wrong results. Enough bugs for now
diffs (21 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer07.sql
b/sql/test/SQLancer/Tests/sqlancer07.sql
--- a/sql/test/SQLancer/Tests/sqlancer07.sql
+++ b/sql/test/SQLancer/Tests/sqlancer07.sql
@@ -131,3 +131,17 @@ CREATE TABLE "t2" ("c0" DECIMAL(18,3),"c
SELECT (SELECT 1 FROM t1, t2, t0 JOIN (SELECT 1) AS sub0 ON (t1.c1) BETWEEN
(t2.c1) AND (t1.c1)) FROM t2, t0 CROSS JOIN t1;
-- empty
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" BIGINT NOT NULL,CONSTRAINT "t0_c0_pkey" PRIMARY KEY
("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"));
+INSERT INTO "t0" VALUES (0),(-1557127883),(-488477810);
+CREATE TABLE "t1" ("c0" BIGINT NOT NULL);
+INSERT INTO "t1" VALUES (1457011207),(98933083),(1259938486);
+CREATE TABLE "t2" ("c0" BIGINT NOT NULL,CONSTRAINT "t2_c0_pkey" PRIMARY KEY
("c0"));
+INSERT INTO "t2" VALUES (596983192), (-601428889), (1688368391);
+
+SELECT t1.c0 FROM t2, t0 CROSS JOIN t1 WHERE ((((t0.c0)%((SELECT DISTINCT
t0.c0 FROM t1, t0, t2 WHERE FALSE))))<=(t1.c0));
+ -- empty
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST(((((t0.c0)%((SELECT
DISTINCT t0.c0 FROM t1, t0, t2 WHERE FALSE))))<=(t1.c0)) AS INT) as count FROM
t2, t0 CROSS JOIN t1) as res;
+ -- NULL
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
