Joe Hannon

Ernie's patch fixes the issue. Has many through self joins are now working in the unit test, as well as my example schemata above. Ernie's patch also fixes a co...

Rather, this bug is present in rails 2.3.5 as well as edge (3.0.0beta3)

This but is present in rails 2.3.5 as well as edge (3.0.0beta3)

here's that patch for the unit test

I've attached a patch which adds a unit test to rails/activerecord/test/cases/associations/has_many_through_associations_test.rb:

  def test_has_many_associati...

Let's try that again with formatting

Here's a simpler schema with no STI:
db/schema.rb:

ActiveRecord::Schema.define(:version => 20100426070714) do

  create_ta...

Here's a simpler schema with no STI:

db/schema.rb:

ActiveRecord::Schema.define(:version => 20100426070714) do

create_table "employees", :force => true do |t|

t...

My naive hardcoded sql didn't work. :-(

I think I found the offending line. activerecord-2.3.5/lib/active_record/associations/has_many_through_association.rb, line 172, in HasManyThroughAssociation#co...

Using Rails 2.3.5

I have a has_many :through association where there is only one table. So the owner model, the through model, and the target model are all the ...