#6384 ActiveRecord 3.0.3 and 3-0-stable generate invalid SQL for has_many :through association with :conditions - Ruby on Rails

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

This project is archived and is in readonly mode.

#6384 ✓resolved

ActiveRecord 3.0.3 and 3-0-stable generate invalid SQL for has_many :through association with :conditions

Reported by Raimonds Simanovskis | February 7th, 2011 @ 04:47 PM

If has_many :through association has :conditions option then generated SQL is missing either join conditions or specified additional conditions from :conditions

See test case how to reproduce the issue and the generated results by different versions of ActiveRecord and Arel
https://gist.github.com/ca8d82d1dd70f73c51de

If ActiveRecord from Rails master branch and Arel master branch is used then correct SQL is generated. It would be good to fix this bug also in upcoming Rails 3.0.4 version (current version from 3-0-stable branch is producing invalid SQL).