ActiveRecord/Postgresql composite primary keys breaks count query on includes+references about rails HOT 5 CLOSED

# frozen_string_literal: true

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"

  gem "rails", "~> 7.1.0"
  gem "sqlite3", "~> 1.4"
end

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 :item_types, force: true do |t|
    t.string :item_type_nm, null: false
  end

  create_table :items, primary_key: [:item_type_id, :other_field] do |t|
    t.string :other_field, null: false
    t.references :item_type
  end
end

class ItemType < ActiveRecord::Base
  has_many :items
end

class Item < ActiveRecord::Base
  self.primary_key = [:item_type_id, :other_field]
  belongs_to :item_type
end

class BugTest < Minitest::Test
  def test_count_with_references
    Item.where(item_type_nm: 'a').includes(:item_type).references(:item_type).count
  end
end