The Oracle adapter also requires some tweaks to make the case insensitive LIKE work.
# File lib/scoped_search/query_builder.rb, line 507 def sql_test(field, operator, value, lhs, &block) # :yields: finder_option_type, value if field.key_field yield(:parameter, lhs.sub(/^.*\./,'')) end if field.textual? && [:like, :unlike].include?(operator) yield(:parameter, (value !~ /^\%|\*/ && value !~ /\%|\*$/) ? "%#{value}%" : value.to_s.tr_s('%*', '%')) return "LOWER(#{field.to_sql(operator, &block)}) #{self.sql_operator(operator, field)} LOWER(?)" elsif field.temporal? return datetime_test(field, operator, value, &block) else yield(:parameter, value) return "#{field.to_sql(operator, &block)} #{self.sql_operator(operator, field)} ?" end end
Generated with the Darkfish Rdoc Generator 2.