Test case for https://github.com/rails/rails/issues/4564

select_and_joins.rb

unless File.exist?('Gemfile')
  File.write('Gemfile', <<-GEMFILE)
    source 'https://rubygems.org'
    gem 'rails', github: 'rails/rails'
    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 :people do |t|
    t.string :name

    t.timestamps
  end

  create_table :households do |t|
    t.string :name

    t.timestamps
  end

  create_table :household_people do |t|
    t.integer :person_id
    t.integer :household_id

    t.timestamps
  end
end

class Person < ActiveRecord::Base
  has_many :household_people
  has_many :households, through: :household_people
end

class HouseholdPerson < ActiveRecord::Base
  belongs_to :person
  belongs_to :household
end

class Household < ActiveRecord::Base
  has_many :household_people
  has_many :people, through: :household_people
end

class BugTest < Minitest::Test
  def test_select_with_joins
    person = Person.new(name: 'Test')
    person.save

    household = Household.new(name: 'Test Household')
    household.save

    person.households << household

    query = Person.select('people.*, households.id as household_id').
                   joins(:households).
                   where(name: 'Test').references(:households)

    assert_equal query[0].household_id, household.id
  end

  def test_select_with_includes
    person = Person.new(name: 'Test')
    person.save

    household = Household.new(name: 'Test Household')
    household.save

    person.households << household

    query = Person.includes(:households).
                   select('people.*, households.id as household_id').
                   where(name: 'Test').references(:households)

    assert_equal query[0].household_id, household.id
  end
end