Changeset: 19bfdb4f2a78 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=19bfdb4f2a78
Modified Files:
sql/test/SQLancer/Tests/sqlancer11.sql
Branch: Oct2020
Log Message:
Next bug, not in operator broken?
diffs (20 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
@@ -88,3 +88,16 @@ SELECT FALSE BETWEEN t0.c3 = ANY(SELECT
-- True
-- True
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" BINARY LARGE OBJECT NOT NULL,CONSTRAINT
"t0_c0_pkey" PRIMARY KEY ("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"));
+INSERT INTO "sys"."t0" VALUES (BINARY LARGE OBJECT 'F4BECB7E'),(BINARY LARGE
OBJECT ''),(BINARY LARGE OBJECT 'E0'),(BINARY LARGE OBJECT 'B0'),(BINARY LARGE
OBJECT 'A0FA'),
+(BINARY LARGE OBJECT 'E67D3FC0'),(BINARY LARGE OBJECT 'A324'),(BINARY LARGE
OBJECT '49E0');
+CREATE TABLE "sys"."t1" ("c0" BINARY LARGE OBJECT);
+INSERT INTO "sys"."t1" VALUES (BINARY LARGE OBJECT ''), (BINARY LARGE OBJECT
'A0'), (BINARY LARGE OBJECT '');
+
+SELECT t0.c0 FROM t1, t0 WHERE 4 NOT IN (6, 1.7976931348623157E308, 0);
+ -- 24 blobs
+SELECT 4 NOT IN (6, 1.7976931348623157E308, 0) FROM t1, t0;
+ -- 24 true
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
