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
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
