path: root/activerecord/test/cases/adapters/postgresql/case_insensitive_test.rb

# frozen_string_literal: true

require "cases/helper"

class PostgresqlCaseInsensitiveTest < ActiveRecord::PostgreSQLTestCase
  class Default < ActiveRecord::Base; end

  def test_case_insensitiveness
    connection = ActiveRecord::Base.connection

    attr = Default.arel_attribute(:char1)
    comparison = connection.case_insensitive_comparison(attr, nil)
    assert_match(/lower/i, comparison.to_sql)

    attr = Default.arel_attribute(:char2)
    comparison = connection.case_insensitive_comparison(attr, nil)
    assert_match(/lower/i, comparison.to_sql)

    attr = Default.arel_attribute(:char3)
    comparison = connection.case_insensitive_comparison(attr, nil)
    assert_match(/lower/i, comparison.to_sql)

    attr = Default.arel_attribute(:multiline_default)
    comparison = connection.case_insensitive_comparison(attr, nil)
    assert_match(/lower/i, comparison.to_sql)
  end
end