MonetDB: Jul2021 - Query with wrong results. Maybe something wro...

[Pedro Ferreira]

Changeset: 91d421cb11a0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/91d421cb11a0
Modified Files:
        sql/test/SQLancer/Tests/sqlancer15.test
Branch: Jul2021
Log Message:

Query with wrong results. Maybe something wrong with casting from bit to int


diffs (126 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer15.test 
b/sql/test/SQLancer/Tests/sqlancer15.test
--- a/sql/test/SQLancer/Tests/sqlancer15.test
+++ b/sql/test/SQLancer/Tests/sqlancer15.test
@@ -277,3 +277,122 @@ 5
 
 statement ok
 ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0"("c0" INTERVAL MONTH NOT NULL,"c1" VARCHAR(32),"c2" UUID NOT 
NULL,"c4" DOUBLE PRECISION,CONSTRAINT "t0_c0_pkey" PRIMARY KEY 
("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"))
+
+statement ok
+CREATE TABLE "t2"("c0" INTERVAL MONTH,"c1" VARCHAR(32),"c2" UUID,"c4" BIGINT)
+
+statement ok rowcount 30
+COPY 30 RECORDS INTO "t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+NULL   NULL    NULL    5
+NULL   NULL    9fb1ebc7-5c9a-dabd-042d-5064ff9cf1dd    NULL
+9      NULL    6f4ac015-cdd9-afdb-af35-fbeeae732624    5
+NULL   "^"     ed8bcd01-e547-d3c1-db18-db2bfef70dd4    NULL
+NULL   "0.8715628341541751"    dbab81e0-ed0f-6e46-1f7d-783faa5d82c1    NULL
+NULL   ""      b6063d03-7f3b-3f5c-988f-d48c7682fb15    NULL
+NULL   NULL    c426906d-be9f-de95-e717-c035788495ff    NULL
+NULL   ""      NULL    NULL
+447562315      "H"     NULL    NULL
+NULL   NULL    NULL    -1249992320
+NULL   NULL    NULL    NULL
+NULL   NULL    NULL    6
+NULL   "Eu&d6^"       db08251d-81e6-e1a3-2b3a-faefbdb169bc    0
+NULL   NULL    103a870c-62bd-edbf-2901-e7cdcbcfb0ef    NULL
+NULL   NULL    bbceaf7c-4cbc-3bc5-26e8-d7c8bdcfd1c3    NULL
+NULL   NULL    af85b0fd-7804-fdd3-f0bb-ad9c2cfce2a5    3
+0      NULL    be7b374e-bdfe-ddd6-ccec-15eadcf6e31a    7
+7      NULL    0f8777ea-d8fb-c266-b9f5-7deffe29dfbf    0
+2      NULL    ec34a9f6-f179-8a15-beeb-1e7dbf1e7d9d    1
+NULL   NULL    ef1e4ad5-ac3a-b8fa-c0ad-f8a8c9a4d6ce    4
+3      NULL    1b7edee4-18d1-b6cf-5dc1-6f15a6db2d9d    157047355
+NULL   "\naVK" f8af6a8e-0464-1f2f-ffae-d92a10898ba6    1
+-896957269     "b"     c2137ac8-3ed8-3936-f08b-4b0ebd6aac3b    3
+5      NULL    NULL    NULL
+NULL   "C"     NULL    NULL
+NULL   ""      NULL    NULL
+NULL   "s"     NULL    NULL
+NULL   "0.24717874352374636"   NULL    NULL
+NULL   "0.3763977961825439"    NULL    NULL
+5      NULL    85df3b1d-ff3f-0a1d-2cba-dc37cabe66de    0
+
+query T rowsort
+SELECT t2.c0 FROM t2 WHERE '' <> ALL(SELECT '7' FROM t0 WHERE FALSE)
+----
+-896957269
+0
+2
+3
+447562315
+5
+5
+7
+9
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+
+query I rowsort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST('' <> ALL(SELECT '7' FROM 
t0 WHERE FALSE) AS INT) as count FROM t2) as res
+----
+30
+
+query I rowsort
+SELECT CAST((SELECT '1' WHERE TRUE) <> ALL(SELECT '7' FROM t0 WHERE FALSE) AS 
INT) FROM t2
+----
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+
+statement ok
+ROLLBACK
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list