Project

General

Profile

Defect #19273

Updated by Toshi MARUYAMA over 9 years ago

In acts_as_searchable.rb, I see the following code: 

 <pre><code class="ruby"> @ 
           def search_token_match_statement(column, value='?') 
             if Redmine::Database.postgresql? 
               if Redmine::Database.postgresql_unaccent? 
                 "unaccent(#{column}) ILIKE unaccent(#{value})" 
               else 
                 "#{column} ILIKE #{value}" 
               end 
             else 
               "#{column} LIKE #{value}" 
             end 
           end 
 </code></pre> @ 

 It seems that the last else statement should read something like @"LOWER(#{column}) LIKE #{value.lowercase}"@. I believe that's what Redmine pre-3 did.

Back