Subqueries are handled differently in sqlite3 and mysql? <\/div>
Rails generates the same SQL, databases return different results.<\/div>
<\/div>
Using sqlite3:<\/div>
----------------<\/div>
<\/div>
>> Person.count<\/div>
SQL (0.2ms) SELECT count(*) AS count_all FROM "people" <\/div>
=> 2<\/div>
<\/div>
>> Person.all(:conditions => ['id NOT IN (?)', []])<\/div>
Person Load (0.9ms) SELECT * FROM "people" WHERE (id NOT IN (NULL)) <\/div>
=> [#<Person id: 1, ...>, #<Person id: 2, ...>]<\/div>
<\/div>
<\/div>
<\/div>
Using mysql:<\/div>
----------------<\/div>
<\/div>
>> Person.count<\/div>
SQL (0.0ms) SELECT count(*) AS count_all FROM `people` <\/div>
=> 2<\/div>
<\/div>
>> Person.all(:conditions => ['id NOT IN (?)', []])<\/div>
Person Load (0.0ms) SELECT * FROM `people` WHERE (id NOT IN (NULL)) <\/div>
=> [] <\/div>
<\/div>
<\/div><\/pre><\/div>\n \n <\/div>\n\n