kazumasayasui / rails Goto Github PK

# frozen_string_literal: true

require "bundler/inline"

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

  git_source(:github) { |repo| "https://github.com/#{repo}.git" }

  # Activate the gem you are reporting the issue against.
  gem "activerecord", "~> 7.0.0"
  gem "sqlite3"
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 :foo_bar_baz_foo_bar_baz_foo_bar_baz_foo_bar_baz, force: true do |t|
    t.bigint :tenant_id, null: false
    t.bigint :evaluation_template_sheet_item_id, null: false
    t.bigint :evaluation_template_role_scene_restriction_id, null: false
    t.timestamps
  end
end

module Foo
  module Bar
    class Baz < ActiveRecord::Base
      self.table_name = 'foo_bar_baz_foo_bar_baz_foo_bar_baz_foo_bar_baz'
    end
  end
end

class BugTest < Minitest::Test
  # バグの内容
  def test_should_group_by_multiple_fields_on_short_name_table
    2.times do
      Foo::Bar::Baz.create!(
        tenant_id: 1,
        evaluation_template_role_scene_restriction_id: 1,
        evaluation_template_sheet_item_id: 2
      )
    end

    res = Foo::Bar::Baz.group(:evaluation_template_role_scene_restriction_id, :evaluation_template_sheet_item_id).having("count(*) >= 2").count

    # ここが期待通り動かない
    assert_equal({ [1, 2] => 2 }, res)
  end
end