#62 ✓resolved
Scott Jacobsen

Invalid sql produced on single character keywords

Reported by Scott Jacobsen | March 4th, 2009 @ 07:21 PM

With the following parameters:


{"commit"=>"Search",
 "search"=>{"conditions"=>{"group"=>{"or_city_keywords"=>"b",
 "or_street_name_keywords"=>"b",
 "household_name_keywords"=>"b"},
 "user_id"=>1},
 "priority_order_by"=>"",
 "order_as"=>"",
 "per_page"=>"25",
 "priority_order_as"=>"",
 "order_by"=>""}}

Produces this sql:


SELECT count(`mytable`.id) AS count_id FROM `mytable` WHERE (() AND `mytable`.`user_id` = 1)

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Provides common named scopes and object based searching.

People watching this ticket

Pages