Changeset: fd243efe8331 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fd243efe8331
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
Branch: octbugs
Log Message:
One more query with wrong results. Enough bugs for now
diffs (20 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
@@ -202,3 +202,16 @@ select sub0.c0 from (values (0.86), ((se
-- 0.86
-- 3.00
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" DOUBLE PRECISION,"c1" INT);
+CREATE TABLE "t1"("c1" INT);
+INSERT INTO "t1" VALUES (1);
+
+SELECT 1 FROM t0 WHERE (EXISTS (SELECT 1 WHERE FALSE)) IN ((SELECT FALSE)); --
rel_push_semijoin_down_or_up is causing the issue
+ -- empty
+SELECT t0.c0 FROM t0 WHERE (EXISTS (SELECT TRUE, 0.3, INTERVAL '5' MONTH, TIME
'16:59:58' WHERE FALSE)) IN ((SELECT DISTINCT FALSE FROM t1), (('0.9')NOT
ILIKE('')));
+ -- empty
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((EXISTS (SELECT ALL TRUE,
0.3, INTERVAL '5' MONTH, TIME '16:59:58' WHERE FALSE)) IN ((SELECT DISTINCT
FALSE FROM t1), (('0.9')NOT ILIKE(''))) AS INT) as count FROM t0) as res;
+ -- NULL
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
