Changeset: 352cc4d1f07d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/352cc4d1f07d
Modified Files:
sql/server/rel_rel.c
sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
Branch: default
Log Message:
small change for improved handling of correlated queries
diffs (25 lines):
diff --git a/sql/server/rel_rel.c b/sql/server/rel_rel.c
--- a/sql/server/rel_rel.c
+++ b/sql/server/rel_rel.c
@@ -1515,9 +1515,7 @@ rel_push_select(mvc *sql, sql_rel *rel,
node *n;
sql_rel *lrel = NULL, *p = NULL;
- if (!l)
- return NULL;
- if (is_sql_or(f)) /* expression has no clear parent relation, so filter
current with it */
+ if (!l || is_sql_or(f)) /* expression has no clear parent relation, so
filter current with it */
return rel_select(sql->sa, rel, e);
for (n = l->h; n; n = n->next ) {
diff --git a/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
b/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
--- a/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
+++ b/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
@@ -1,6 +1,6 @@
statement ok
CREATE TABLE IF NOT EXISTS database0_t2(c2 STRING)
-query II
+query TI
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) ))
----
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
