Changeset: 383a6586aa76 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/383a6586aa76
Added Files:
sql/test/BugTracker-2025/Tests/7632-crash-leftjoin-exists.test
Modified Files:
sql/server/rel_unnest.c
sql/test/BugTracker-2025/Tests/All
Branch: Mar2025
Log Message:
Fixing bug #7632. Added test.
(grafted from 125b0d18c6beed11858e26086466f237cc0b9849)
diffs (37 lines):
diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c
--- a/sql/server/rel_unnest.c
+++ b/sql/server/rel_unnest.c
@@ -3696,7 +3696,6 @@ rewrite_exists(visitor *v, sql_rel *rel,
le = exp_ref(v->sql, a);
le->card = CARD_MULTI; /* mark as multi
value, the real attribute is introduced later */
append(join->attr, a);
- assert(is_project(rel->op) || depth);
if ((is_project(rel->op) || depth))
return le;
}
diff --git a/sql/test/BugTracker-2025/Tests/7632-crash-leftjoin-exists.test
b/sql/test/BugTracker-2025/Tests/7632-crash-leftjoin-exists.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2025/Tests/7632-crash-leftjoin-exists.test
@@ -0,0 +1,13 @@
+statement ok
+CREATE TABLE t0(c0 INT)
+
+query II
+SELECT * FROM t0 INNER JOIN (VALUES (1)) ON EXISTS (SELECT ALL * FROM t0)
+----
+
+query II
+SELECT * FROM t0 LEFT JOIN (VALUES (1)) ON EXISTS (SELECT ALL * FROM t0)
+----
+
+statement ok
+drop table t0
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
@@ -7,3 +7,4 @@ 7623_update_returning
7625_missing_temporary_view_types
7626_sum_max_const
HAVE_HGE?7637_str_to_decimal
+7632-crash-leftjoin-exists
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
