]> git.evergreen-ils.org Git - working/Evergreen.git/commit
projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 351a827) | patch
Keep standard INNER joins above possible OUTERs
authorMike Rylander <mrylander@gmail.com>
Thu, 12 Sep 2013 17:26:21 +0000 (13:26 -0400)
committerBen Shum <bshum@biblio.org>
Sat, 15 Feb 2014 00:38:35 +0000 (19:38 -0500)
commitb37a259ae51f6d8b0db097270c5e0f5ce8af91ba
treedf44382009b6a4705d88ad42416feade34c59435tree
parent351a8276712ddeb5c6f2d4cec1fe386fd6f5d841commit | diff
Keep standard INNER joins above possible OUTERs

We always join metabib.record_attr, and we always use an INNER join
to the core table, so keep that join first.  Likewise with the join
to biblio.record_entry.  Dynamic joins may be OUTER, though, and while
join reordering in Postgres is smart, let's not give it the chance to
fail.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Ben Shum <bshum@biblio.org>
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm diff | blob | history
Evergreen ILS