Changeset: 772f27d4c245 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=772f27d4c245
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.sql
Branch: Jun2020
Log Message:
SQLancer query resulting in batcalc.between undefined
diffs (17 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
@@ -219,6 +219,13 @@ INSERT INTO "t0" VALUES (0.1015545478217
SELECT t0.c0 FROM t0 WHERE
CAST((0.3101399424332040855034620108199305832386016845703125) NOT IN
(0.6446234112932121007588648353703320026397705078125) AS BOOLEAN);
ROLLBACK;
+START TRANSACTION; --Bug 6902
+CREATE TABLE "t0" ("c0" DOUBLE PRECISION NOT NULL,"c1" VARCHAR(64));
+create view v0(c0, c1) as (select all t0.c0, r'epfNW⟚榢tptPbC{5{ZW}6,R' from
t0) with check option;
+SELECT v0.c0 FROM v0 WHERE (v0.c1) NOT BETWEEN SYMMETRIC
(replace(CAST(CAST(v0.c0 AS INT) AS STRING), v0.c1, replace(CAST(0.1 AS
STRING), v0.c1, v0.c1))) AND (v0.c1);
+ --empty
+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
