Changeset: aab9ccf5a8c4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/aab9ccf5a8c4
Added Files:
sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
Modified Files:
sql/backends/monet5/sql_statement.c
sql/test/BugTracker-2025/Tests/All
Branch: default
Log Message:
add test for bug #7645 and fix, ie use anti flag not direct call to not_'filter'
diffs (34 lines):
diff --git a/sql/backends/monet5/sql_statement.c
b/sql/backends/monet5/sql_statement.c
--- a/sql/backends/monet5/sql_statement.c
+++ b/sql/backends/monet5/sql_statement.c
@@ -1637,6 +1637,10 @@ stmt_genselect(backend *be, stmt *lops,
} else {
node *n;
+ if (strncmp(op, "not_", 4) == 0) {
+ anti = !anti;
+ op += 4;
+ }
op = sa_strconcat(be->mvc->sa, op, selectRef);
q = newStmtArgs(mb, mod, convertMultiplexFcn(op), 9);
if (q == NULL)
diff --git a/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
b/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
@@ -0,0 +1,6 @@
+statement ok
+CREATE TABLE IF NOT EXISTS database0_t2(c2 STRING)
+
+query II
+SELECT * FROM database0_t2 JOIN (VALUES (INTERVAL '18115' MONTH)) ON ((
(database0_t2.c2 NOT LIKE CAST(INTERVAL '20039' MONTH AS STRING(909))) OR
(database0_t2.c2 LIKE database0_t2.c2) ))
+----
diff --git a/sql/test/BugTracker-2025/Tests/All
b/sql/test/BugTracker-2025/Tests/All
--- a/sql/test/BugTracker-2025/Tests/All
+++ b/sql/test/BugTracker-2025/Tests/All
@@ -13,4 +13,5 @@ 7634_join_with_subquery_crash
7635_name_propagation_missing
7636_antijoin_crash
7644_antijoin_crash
+7645_not_likeselect
7646_leftjoin_crash
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
