Changeset: 08449002fda3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=08449002fda3 Modified Files: sql/backends/monet5/rel_bin.c sql/test/SQLancer/Tests/sqlancer01.stable.out Branch: Jun2020 Log Message:
Fix for SQLancer query, batcalc.between definition where the first argument is not a vector is missing. For Jun2020 we just create a const column as a workaround diffs (36 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c --- a/sql/backends/monet5/rel_bin.c +++ b/sql/backends/monet5/rel_bin.c @@ -1105,7 +1105,7 @@ exp_bin(backend *be, sql_exp *e, stmt *l r2 = stmt_project(be, sel, r2); sel = NULL; } - s = stmt_uselect2(be, l, r, r2, (comp_type)e->flag, sel, is_anti(e)); + s = stmt_uselect2(be, column(be, l), r, r2, (comp_type)e->flag, sel, is_anti(e)); } } else { /* value compare or select */ diff --git a/sql/test/SQLancer/Tests/sqlancer01.stable.out b/sql/test/SQLancer/Tests/sqlancer01.stable.out --- a/sql/test/SQLancer/Tests/sqlancer01.stable.out +++ b/sql/test/SQLancer/Tests/sqlancer01.stable.out @@ -441,6 +441,20 @@ stdout of test 'sqlancer01` in directory [ 594212101 ] [ 0.5981662672 ] #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) BETWEEN (replace('2', '2', '1')) AND (v0.c1); +% sys.v0 # table_name +% c0 # name +% double # type +% 24 # length +#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); +% sys.v0 # table_name +% c0 # name +% double # type +% 24 # length +#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