Changeset: c8b8f3d66d6e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c8b8f3d66d6e
Added Files:
sql/test/SQLancer/Tests/sqlancer02.sql
Modified Files:
sql/test/SQLancer/Tests/All
Branch: Jun2020
Log Message:
SQLancer query with wrong results
diffs (31 lines):
diff --git a/sql/test/SQLancer/Tests/All b/sql/test/SQLancer/Tests/All
--- a/sql/test/SQLancer/Tests/All
+++ b/sql/test/SQLancer/Tests/All
@@ -1,1 +1,2 @@
sqlancer01
+sqlancer02
diff --git a/sql/test/SQLancer/Tests/sqlancer02.sql
b/sql/test/SQLancer/Tests/sqlancer02.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer02.sql
@@ -0,0 +1,20 @@
+START TRANSACTION; -- Bug 6909
+CREATE TABLE "sys"."t0" ("c0" BOOLEAN,"c1" DOUBLE PRECISION NOT NULL);
+COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+false 0.2059926383949241
+NULL 1.89755202e+09
+NULL 0.8514002985569765
+NULL 0.8565135463082767
+
+SELECT ALL t0.c0 FROM t0 WHERE (((0.654013919354451) BETWEEN SYMMETRIC (t0.c1)
AND ("length"(upper(''))))OR(t0.c0));
+ -- NULL
+ -- NULL
+ -- NULL
+SELECT ALL t0.c0 FROM t0 WHERE (((0.654013919354451) BETWEEN SYMMETRIC (t0.c1)
AND ("length"(upper(''))))OR(t0.c0)) UNION ALL
+SELECT ALL t0.c0 FROM t0 WHERE NOT ((((0.654013919354451) BETWEEN SYMMETRIC
(t0.c1) AND ("length"(upper(''))))OR(t0.c0))) UNION ALL
+SELECT t0.c0 FROM t0 WHERE ((((0.654013919354451) BETWEEN SYMMETRIC (t0.c1)
AND ("length"(upper(''))))OR(t0.c0))) IS NULL;
+ -- NULL
+ -- NULL
+ -- NULL
+ -- False
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
