Opened 5 years ago
Last modified 4 years ago
#30841 closed Cleanup/optimization
Using isnull to a non-boolean value does not promote join — at Initial Version
| Reported by: | André Ericson | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | dev |
| Severity: | Normal | Keywords: | |
| Cc: | Triage Stage: | Ready for checkin | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Using isnull filter with a non-boolean value will not promote INNER JOIN to an OUTER JOIN leading to inconsistent behaviour.
I'm submitting a PR together with this ticket and will link it here.
Note:
See TracTickets
for help on using tickets.