Changeset: ab13c8dcd917 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ab13c8dcd917
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.sql
Branch: Jun2020
Log Message:
SQLancer query with wrong results
diffs (16 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer01.sql
b/sql/test/SQLancer/Tests/sqlancer01.sql
--- a/sql/test/SQLancer/Tests/sqlancer01.sql
+++ b/sql/test/SQLancer/Tests/sqlancer01.sql
@@ -213,6 +213,12 @@ union all select all max(all cast(0.1852
select scale_down(-631218936, cast(0.41370374 as int)); --simplified
ROLLBACK;
+START TRANSACTION; --Bug 6901
+CREATE TABLE "t0" ("c0" DOUBLE PRECISION NOT NULL,"c1" VARCHAR(64));
+INSERT INTO "t0" VALUES (0.10155454782177964, 'FALSE'), (594212101, NULL),
(0.5981662672233894, NULL);
+SELECT t0.c0 FROM t0 WHERE
CAST((0.3101399424332040855034620108199305832386016845703125) NOT IN
(0.6446234112932121007588648353703320026397705078125) AS BOOLEAN);
+ROLLBACK;
+
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
DROP TABLE integers;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
