Changeset: 181154b81a35 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/181154b81a35
Modified Files:
sql/backends/monet5/rel_bin.c
Branch: Dec2025
Log Message:
don't skip the deleted when using an hash index (as created for a primary or
unique key)
Solves issue #7783
diffs (23 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
@@ -2856,7 +2856,7 @@ rel2bin_hash_lookup(backend *be, sql_rel
return stmt_join(be, h, idx, 0, cmp_equal, 0,
semantics, false);
}
} else {
- return stmt_uselect(be, idx, h, cmp_equal, NULL, 0, semantics);
+ return stmt_uselect(be, idx, h, cmp_equal, left->cand, 0,
semantics);
}
}
@@ -4939,6 +4939,10 @@ rel2bin_select(backend *be, sql_rel *rel
sql_idx *i = p->value.pval;
int oldvtop = be->mb->vtop, oldstop = be->mb->stop;
+ if (sel) {
+ sub->cand = sel;
+ sel = NULL;
+ }
if (!(sel = rel2bin_hash_lookup(be, rel, sub, NULL, i,
en))) {
/* hash lookup cannot be used, clean leftover
mal statements */
clean_mal_statements(be, oldstop, oldvtop);
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
