1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
# frozen_string_literal: true
require "cases/helper"
class PostgresqlCaseInsensitiveTest < ActiveRecord::PostgreSQLTestCase
class Default < ActiveRecord::Base; end
def test_case_insensitiveness
connection = ActiveRecord::Base.connection
table = Default.arel_table
column = Default.columns_hash["char1"]
comparison = connection.case_insensitive_comparison table, :char1, column, nil
assert_match(/lower/i, comparison.to_sql)
column = Default.columns_hash["char2"]
comparison = connection.case_insensitive_comparison table, :char2, column, nil
assert_match(/lower/i, comparison.to_sql)
column = Default.columns_hash["char3"]
comparison = connection.case_insensitive_comparison table, :char3, column, nil
assert_match(/lower/i, comparison.to_sql)
column = Default.columns_hash["multiline_default"]
comparison = connection.case_insensitive_comparison table, :multiline_default, column, nil
assert_match(/lower/i, comparison.to_sql)
end
end
|