Search for strings containing leading whitespace is broken

[DCrow]

After #1115 ransack started removing whitespace from search queries.

It is now impossible to search for those kind of strings.
Some users in my project use names/label with leading spaces, so they depend on previous behavior.

Example

Person.ransack("name_start" => " Wilson").to_sql
# => "SELECT \"people\".* FROM \"people\" WHERE \"people\".\"name\" LIKE 'Wilson%' ORDER BY \"people\".\"id\" DESC"
# Expecting 
# => "SELECT \"people\".* FROM \"people\" WHERE \"people\".\"name\" LIKE ' Wilson%' ORDER BY \"people\".\"id\" DESC"

Maybe add some kind of option to turn off whitespace stripping?

[scarroll32]

@DCrow that is a good point, I think the best option would be strip as default but to have a way to opt-out.

[scarroll32]

This code could become something like:

    self.options = {
      :search_key => :q,
      :ignore_unknown_conditions => true,
      :hide_sort_order_indicators => false,
      :up_arrow => '▼'.freeze,
      :down_arrow => '▲'.freeze,
      :default_arrow => nil,
      :sanitize_scope_args => true,
      :postgres_fields_sort_option => nil,
      :strip_whitespace => true
    }

Which would give the ability to do:

Ransack.configure do |c|
  c.strip_whitespace = false
end

[DCrow]

Seems good to me. Opt-out also seems logical since there might be projects which already utilize whitespace stripping.

Also maybe add some notes about this change(which version started whitespace stripping, etc) and option in README?

[scarroll32]

Closed by #1214