summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJean-Philippe Lang <jp_lang@yahoo.fr>2014-12-14 16:30:36 +0000
committerJean-Philippe Lang <jp_lang@yahoo.fr>2014-12-14 16:30:36 +0000
commit261d9894312f9aa65cff944777fb5b1fa5dbdfde (patch)
tree973ac4c4d0646c27582712a44a75c14d973fde14
parent24ea9538225cca7504808883031b37564720b82f (diff)
downloadredmine-261d9894312f9aa65cff944777fb5b1fa5dbdfde.tar.gz
redmine-261d9894312f9aa65cff944777fb5b1fa5dbdfde.zip
SQLite does not support case insensitive match for non-ASCII characters (#18537).
git-svn-id: http://svn.redmine.org/redmine/trunk@13760 e93f8b46-1217-0410-a6f0-8f06a7374b81
-rw-r--r--test/unit/search_test.rb10
1 files changed, 9 insertions, 1 deletions
diff --git a/test/unit/search_test.rb b/test/unit/search_test.rb
index 255a192f7..7959851bc 100644
--- a/test/unit/search_test.rb
+++ b/test/unit/search_test.rb
@@ -142,13 +142,21 @@ class SearchTest < ActiveSupport::TestCase
assert_equal issue, r.first
end
+ def test_search_should_be_case_insensitive
+ issue = Issue.generate!(:subject => "AzerTY")
+
+ r = Issue.search_results('AZERty')
+ assert_include issue, r
+ end
+
def test_search_should_not_use_ruby_downcase
+ skip "SQLite does not support case insensitive match for non-ASCII characters" if sqlite?
issue1 = Issue.generate!(:subject => "Special chars: ÖÖ")
issue2 = Issue.generate!(:subject => "Special chars: Öö")
Issue.generate!(:subject => "Special chars: oo")
Issue.generate!(:subject => "Special chars: OO")
- r = Issue.search_results('%ÖÖ%')
+ r = Issue.search_results('ÖÖ')
assert_include issue1, r
assert_include issue2, r
assert_equal 2, r.size