johnreilly (owner)

Revisions

gist: 33606 Download_button fork
public
Public Clone URL: git://gist.github.com/33606.git
Embed All Files: show embed
Text only #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Subqueries are handled differently in sqlite3 and mysql?
Rails generates the same SQL, databases return different results.
 
Using sqlite3:
----------------
 
>> Person.count
  SQL (0.2ms) SELECT count(*) AS count_all FROM "people"
=> 2
 
>> Person.all(:conditions => ['id NOT IN (?)', []])
  Person Load (0.9ms) SELECT * FROM "people" WHERE (id NOT IN (NULL))
=> [#<Person id: 1, ...>, #<Person id: 2, ...>]
 
 
 
Using mysql:
----------------
 
>> Person.count
  SQL (0.0ms) SELECT count(*) AS count_all FROM `people`
=> 2
 
>> Person.all(:conditions => ['id NOT IN (?)', []])
  Person Load (0.0ms) SELECT * FROM `people` WHERE (id NOT IN (NULL))
=> []