Keep standard INNER joins above possible OUTERs user/miker/reorder-standard-joins
authorMike Rylander <mrylander@gmail.com>
Thu, 12 Sep 2013 17:26:21 +0000 (13:26 -0400)
committerMike Rylander <mrylander@gmail.com>
Thu, 12 Sep 2013 17:26:21 +0000 (13:26 -0400)
commitda03ffb2beda16c0272dc0653648a9ae56d6b7ca
treeb00b07e03e5ee21f69443cd0968516db24538aad
parentdc7ec6cfb60d66150ad43d4157a63ea739667217
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>
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm