Straight join in rails

Maybe someone will find this useful:

I have a relatively complex (My)SQL query that results from having many
many :conditions and :includes, and MySQL seems to apply a wrong join
order so I wanted to force an order using the STRAIGHT_JOIN statement,
but rails doesn’t really let you do it. Having to construct this query
manually (there are 4 joins) and still have a right format for eager
association loading wasn’t really an option.

I digged into ActiveRecord and modifying the JoinDependency class to
output "STRAIGHT_JOIN"s instead of "LEFT OUTER JOIN"s looked like too
much work too, so I decided to take a shorter route: intercept the
generated sql query, and replace SELECT with SELECT STRAIGHT_JOIN.

Here’s a monkey-patch (written against ActiveRecord 1.5.14) that
achieves this behaviour:

module ActiveRecord
class Base
class << self
VALID_FIND_OPTIONS << :straight_join
alias_method :orig_add_joins!, :add_joins!
def add_joins!(sql, options, scope = :auto)

So simply supply a :straight_join => true option to finder and it will
result in a SELECT STRAIGHT_JOIN … query.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs