Changeset: f28b5baec23b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f28b5baec23b
Modified Files:
sql/server/rel_statistics.c
Branch: Sep2022
Log Message:
don't reorder select expressions which use an hash-idx (unique constraint)
diffs (12 lines):
diff --git a/sql/server/rel_statistics.c b/sql/server/rel_statistics.c
--- a/sql/server/rel_statistics.c
+++ b/sql/server/rel_statistics.c
@@ -1165,6 +1165,8 @@ rel_select_order(visitor *v, sql_rel *re
for (i = 0, n = rel->exps->h; n; i++, n = n->next) {
exps[i] = n->data;
+ if (find_prop(exps[i]->p, PROP_HASHCOL))
+ return rel;
scores[i] = score_se(v, rel, n->data);
}
GDKqsort(scores, exps, NULL, nexps, sizeof(int), sizeof(void
*), TYPE_int, true, true);
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
