Contents

# 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_table[:char1]
    comparison = connection.case_insensitive_comparison(attr, nil)
    assert_match(/lower/i, comparison.to_sql)

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

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

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

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
ibm_db-5.5.0-x86-mingw32	test/cases/adapters/postgresql/case_insensitive_test.rb
ibm_db-5.4.1-x86-mingw32	test/cases/adapters/postgresql/case_insensitive_test.rb
ibm_db-5.4.0-x86-mingw32	test/cases/adapters/postgresql/case_insensitive_test.rb
ibm_db-5.3.2-x86-mingw32	test/cases/adapters/postgresql/case_insensitive_test.rb