Changeset: 9481eab21f67 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9481eab21f67 Modified Files: monetdb5/optimizer/opt_commonTerms.c Branch: Dec2023 Log Message:
in commenterms handle both sql.tid and sql.binds, such that statements using those can be optimized away (when used multiple times) diffs (12 lines): diff --git a/monetdb5/optimizer/opt_commonTerms.c b/monetdb5/optimizer/opt_commonTerms.c --- a/monetdb5/optimizer/opt_commonTerms.c +++ b/monetdb5/optimizer/opt_commonTerms.c @@ -139,7 +139,7 @@ OPTcommonTermsImplementation(Client cntx } /* simple SQL bind operations need not be merged, they are cheap * and/or can be duplicated eliminated elsewhere cheaper */ - if (getModuleId(p) == sqlRef && getFunctionId(p) != tidRef) { + if (getModuleId(p) == sqlRef && (getFunctionId(p) != tidRef && getFunctionId(p) != bindRef)) { pushInstruction(mb, p); old[i] = NULL; continue; _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org