Changeset: 5b7efbe5cde4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5b7efbe5cde4
Modified Files:
sql/test/SQLancer/Tests/SingleServer
sql/test/SQLancer/Tests/sqlancer01.sql
Branch: Jun2020
Log Message:
SQLancer query with wrong results. Also the raw_strings options is no longer
required, because the SQLancer Monet's backend always generates raw strings
from now on
diffs (52 lines):
diff --git a/sql/test/SQLancer/Tests/SingleServer
b/sql/test/SQLancer/Tests/SingleServer
--- a/sql/test/SQLancer/Tests/SingleServer
+++ b/sql/test/SQLancer/Tests/SingleServer
@@ -1,1 +0,0 @@
---set raw_strings=true
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
@@ -129,6 +129,43 @@ select 1 from v0 join t0 on (((substr('1
-- empty
ROLLBACK;
+START TRANSACTION; --Bug 6899
+CREATE TABLE "sys"."t0" (
+ "c0" DECIMAL(18,3),
+ "c1" DOUBLE
+);
+COPY 25 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.861 0.6056174268361689
+NULL 0.5542760880735715
+0.566 0.5542760880735715
+0.923 0.052316013908556114
+0.162 0.5542760880735715
+0.329 0.44073078327593473
+0.662 0.5255985140328766
+0.001 NULL
+0.736 NULL
+0.604 0.5394080603985286
+0.988 NULL
+0.232 0.23262100818671297
+0.041 -7.386201860458207e+20
+0.776 NULL
+0.805 NULL
+0.189 NULL
+0.493 NULL
+0.164 0.23262100818671297
+0.316 0.6870041098637464
+NULL 1.19449193e+09
+NULL 0.5798864736610635
+0.219 37
+0.924 0.8488059445245933
+0.413 0.6870041098637464
+0.234 0
+
+SELECT t0.c0 FROM t0 WHERE NOT (CAST((t0.c1) IS NULL AS BOOLEAN)) UNION ALL
SELECT t0.c0 FROM t0 WHERE NOT (NOT (CAST((t0.c1) IS NULL AS BOOLEAN))) UNION
ALL SELECT ALL t0.c0 FROM t0 WHERE (NOT (CAST((t0.c1) IS NULL AS BOOLEAN))) IS
NULL;
+SELECT count(*) FROM t0 WHERE (NOT (CAST((t0.c1) IS NULL AS BOOLEAN))) IS
NULL; --simplified
+ -- 0
+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
