Skip to content

Instantly share code, notes, and snippets.

@rywall
Created December 4, 2014 01:52
Show Gist options
  • Save rywall/8854c36f104b2eb91bdb to your computer and use it in GitHub Desktop.
Save rywall/8854c36f104b2eb91bdb to your computer and use it in GitHub Desktop.
hm:t association with order clause that references join table cannot be eager loaded
unless File.exist?('Gemfile')
File.write('Gemfile', <<-GEMFILE)
source 'https://rubygems.org'
gem 'rails', github: 'rails/rails'
gem 'arel', github: 'rails/arel'
gem 'rack', github: 'rack/rack'
gem 'i18n', github: 'svenfuchs/i18n'
gem 'sqlite3'
GEMFILE
system 'bundle'
end
require 'bundler'
Bundler.setup(:default)
require 'active_record'
require 'minitest/autorun'
require 'logger'
# This connection will do for database-independent bug reports.
ActiveRecord::Base.establish_connection(adapter: 'sqlite3', database: ':memory:')
ActiveRecord::Base.logger = Logger.new(STDOUT)
ActiveRecord::Schema.define do
create_table :posts do |t|
end
create_table :comments do |t|
t.integer :post_id
t.integer :user_id
end
create_table :users do |t|
end
end
class Post < ActiveRecord::Base
has_many :comments
has_many :users, -> { order('comments.id ASC').references('comments') }, :through => :comments
end
class Comment < ActiveRecord::Base
belongs_to :post
belongs_to :user
end
class User < ActiveRecord::Base
end
class BugTest < Minitest::Test
def test_can_include_repliers
Post.create!(comments: [Comment.create!(user: User.create!)])
Post.includes(:users).to_a
end
end
@rywall
Copy link
Author

rywall commented Dec 4, 2014

Produces

ActiveRecord::StatementInvalid: SQLite3::SQLException: no such column: comments.id: SELECT "users".* FROM "users" WHERE "users"."id" IN (1) ORDER BY comments.id ASC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment