Changeset: 7c08d37c9cf7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7c08d37c9cf7
Modified Files:
sql/test/SQLancer/Tests/sqlancer11.test
Branch: default
Log Message:
Query with wrong results
diffs (101 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer11.test
b/sql/test/SQLancer/Tests/sqlancer11.test
--- a/sql/test/SQLancer/Tests/sqlancer11.test
+++ b/sql/test/SQLancer/Tests/sqlancer11.test
@@ -777,3 +777,97 @@ SELECT 1 FROM t0, t2 RIGHT OUTER JOIN (V
statement ok
ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0" ("c0" REAL,"c1" DOUBLE,"c4" CHARACTER LARGE
OBJECT,CONSTRAINT "t0_c1_unique" UNIQUE ("c1"))
+
+statement ok
+CREATE TABLE "t1" ("c2" BINARY LARGE OBJECT NOT NULL)
+
+statement ok
+INSERT INTO "t1" VALUES (BINARY LARGE OBJECT '7982'),(BINARY LARGE OBJECT
'7982'),(BINARY LARGE OBJECT '7982'),(BINARY LARGE OBJECT '7982'),(BINARY LARGE
OBJECT '7982'),
+(BINARY LARGE OBJECT '7982'),(BINARY LARGE OBJECT '7982'),(BINARY LARGE OBJECT
'7982'),(BINARY LARGE OBJECT '7982'),(BINARY LARGE OBJECT '7982'),(BINARY LARGE
OBJECT '7982'),
+(BINARY LARGE OBJECT '7982'),(BINARY LARGE OBJECT '7982'),(BINARY LARGE OBJECT
'7982'),(BINARY LARGE OBJECT '7982'),(BINARY LARGE OBJECT '7982'),(BINARY LARGE
OBJECT '7982'),
+(BINARY LARGE OBJECT '7982')
+
+statement ok
+CREATE TABLE "t2" ("c0" UUID NOT NULL,"c2" BIGINT,CONSTRAINT "t2_c0_pkey"
PRIMARY KEY ("c0"),CONSTRAINT "t2_c0_unique" UNIQUE ("c0"))
+
+statement ok
+INSERT INTO "t2" VALUES ('6b1b3e0e-655f-cbf3-bfa6-58cac0fdb5b7', -156155021)
+
+query T rowsort
+SELECT t1.c2 FROM t1, t2 RIGHT OUTER JOIN (VALUES (UUID
'131b9167-efFa-92FE-523A-5EF2Ca7963a8', 1)) AS sub0 ON false WHERE ((SELECT
DISTINCT 3 FROM t0 AS l2t0) EXCEPT ALL (SELECT 2 FROM t0 AS l2t0)) IS NULL;
+----
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+
+query T rowsort
+SELECT ((SELECT DISTINCT 3 FROM t0 AS l2t0) EXCEPT ALL (SELECT 2 FROM t0 AS
l2t0)) IS NULL FROM t1, t2 RIGHT OUTER JOIN (VALUES (UUID
'131b9167-efFa-92FE-523A-5EF2Ca7963a8', 1)) AS sub0 ON false;
+----
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+True
+
+query T rowsort
+SELECT t1.c2 FROM t1, t2 RIGHT OUTER JOIN (VALUES (UUID
'131b9167-efFa-92FE-523A-5EF2Ca7963a8', ((scale_down(4,
3))&(sql_max(1220354535, -236857972))))) AS sub0 ON ((((NOT
(FALSE))AND("isauuid"(r'*O'))))AND(((r'h')NOT LIKE(r'N'))))
+WHERE (((SELECT DISTINCT BLOB '' FROM t0 AS l2t0, t2 AS l2t2 WHERE TRUE)
EXCEPT ALL (SELECT BLOB 'afd907d0A0' FROM t0 AS l2t0 WHERE TRUE))) IS NULL
+----
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+7982
+
+query I rowsort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((SELECT DISTINCT BLOB ''
FROM t0 AS l2t0, t2 AS l2t2 WHERE TRUE) EXCEPT ALL (SELECT BLOB 'afd907d0A0'
FROM t0 AS l2t0 WHERE TRUE))) IS NULL AS INT) as count FROM t1, t2
+RIGHT OUTER JOIN (VALUES (UUID '131b9167-efFa-92FE-523A-5EF2Ca7963a8',
((scale_down(4, 3))&(sql_max(1220354535, -236857972))))) AS sub0 ON ((((NOT
(FALSE))AND("isauuid"(r'*O'))))AND(((r'h')NOT LIKE(r'N'))))) as res
+----
+18
+
+statement ok
+ROLLBACK
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
