searchlogic
searchlogic copied to clipboard
Published
20 hours ago •
binarylogic
binarylogic
Using empty array with _any gives all results
This may entirely by my ignorance of searchlogic.
Giving an empty array to id_is_any() returns all rows. Seems like it should return 0 rows.
ruby-1.8.7-p330 :038 > current_account.groups.id_is_any( [ ] ).ascend_by_name.count
SQL (2.5ms) SELECT count(*) AS count_all FROM groups WHERE ((groups.account_id = 1))
=> 3834
_Using is works correctly.
ruby-1.8.7-p330 :040 > current_account.groups.id_is( [ ] ).ascend_by_name.count
SQL (0.5ms) SELECT count(*) AS count_all FROM groups WHERE ((groups.id IN (NULL)) AND (groups.account_id = 1))
=> 0
