Empty array interpolates as NULL in where condition

Update: Used [''] as a workaround on sqlite. This doesn't seem to work on PostgreSQL.

Looks like both sqlite and PostgreSQL adapters (tested via heroku's console) both generate the NULL. PostgreSQL seems unhappy with the empty array though since it considers (id NOT IN ()) to be invalid.

@Mat Why do you think that

id NOT IN (NULL)

is incorrect?

For me everything works correct.

Originally I was expecting NOT IN () which at least under sqlite had the intended effect of giving me all records. But I'm pretty sure postgres didn't like that either. Right now I have an "if ids.empty?" in my model. But that seemed less than awesome.

Is there maybe a better way to do this using an arel condition that I missed?

@2kan, going further, does

IN (NULL)

Post.all(
  :joins      => "LEFT JOIN view_logs ON posts.id = view_logs.post_id",
  :conditions => { :view_logs => { :user_id => [1, 2, nil] }
}

view_logs.user_id IS NULL

... WHERE (view_logs.user_id IN (1, 2) OR view_logs.user_id IS NULL)

gucci watches