diff options
author | Matthew Draper <matthew@trebex.net> | 2016-10-11 12:20:26 +1030 |
---|---|---|
committer | Matthew Draper <matthew@trebex.net> | 2016-10-11 12:23:15 +1030 |
commit | bc9dc418259f1db0f14ed895e8469b7839ef474b (patch) | |
tree | 8020fd7fe2e27ff94b28039ba47e8f2d076ee755 /activerecord/test/cases/adapters/postgresql | |
parent | 469dd36af14ec20197910fb5cd2fd47f7612ef09 (diff) | |
parent | 4c2f7ee36a623090d276ef811d959adb0ecff743 (diff) | |
download | rails-bc9dc418259f1db0f14ed895e8469b7839ef474b.tar.gz rails-bc9dc418259f1db0f14ed895e8469b7839ef474b.tar.bz2 rails-bc9dc418259f1db0f14ed895e8469b7839ef474b.zip |
Merge pull request #26208 from nanaya/pg-insensitive-text
Fix case insensitive check for text column in pg
Diffstat (limited to 'activerecord/test/cases/adapters/postgresql')
-rw-r--r-- | activerecord/test/cases/adapters/postgresql/case_insensitive_test.rb | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/activerecord/test/cases/adapters/postgresql/case_insensitive_test.rb b/activerecord/test/cases/adapters/postgresql/case_insensitive_test.rb new file mode 100644 index 0000000000..d04e55f5bf --- /dev/null +++ b/activerecord/test/cases/adapters/postgresql/case_insensitive_test.rb @@ -0,0 +1,26 @@ +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 |