Changeset: 7c144b6e2958 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7c144b6e2958
Modified Files:
sql/test/SQLancer/Tests/sqlancer11.sql
Branch: Oct2020
Log Message:
Next query with wrong results. I think a left outer join is missing
diffs (17 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer11.sql
b/sql/test/SQLancer/Tests/sqlancer11.sql
--- a/sql/test/SQLancer/Tests/sqlancer11.sql
+++ b/sql/test/SQLancer/Tests/sqlancer11.sql
@@ -101,3 +101,13 @@ SELECT t0.c0 FROM t1, t0 WHERE 4 NOT IN
SELECT 4 NOT IN (6, 1.7976931348623157E308, 0) FROM t1, t0;
-- 24 true
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t1" ("c1" TINYINT,"c2" CHAR(22),"c4" INTEGER);
+INSERT INTO "sys"."t1" VALUES (NULL, NULL, 0),(NULL, NULL, -391221783),(NULL,
NULL, -1107653660),(NULL, NULL, 0),(7, 'cTR'' Abp', 0),(7, 'cTR'' Abp', 1),(7,
'cTR'' Abp', -1);
+
+SELECT t1.c2 FROM t1 WHERE CASE 3 WHEN ((SELECT 0.48) INTERSECT DISTINCT
(SELECT -1.2)) THEN FALSE ELSE TRUE END;
+ -- 7 values
+SELECT CASE 3 WHEN ((SELECT 0.48) INTERSECT DISTINCT (SELECT -1.2)) THEN FALSE
ELSE TRUE END FROM t1;
+ -- 7 values
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
