Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Loading…

Using empty array with _any gives all results #148

Open
chadb opened this Issue · 0 comments

1 participant

@chadb

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.