diff options
| author | Emilio Tagua <miloops@gmail.com> | 2010-06-23 13:04:59 -0300 |
|---|---|---|
| committer | Emilio Tagua <miloops@gmail.com> | 2010-06-23 13:04:59 -0300 |
| commit | a040b1c0e68f7a5145a6decf6731be9c371fa24a (patch) | |
| tree | 9c861e8fbf434c1b0938c3aaa40b32aff51d65cc /spec/engines/sql | |
| parent | 71e92992e66f461acaabc3ac2f3ec6480167962e (diff) | |
| download | rails-a040b1c0e68f7a5145a6decf6731be9c371fa24a.tar.gz rails-a040b1c0e68f7a5145a6decf6731be9c371fa24a.tar.bz2 rails-a040b1c0e68f7a5145a6decf6731be9c371fa24a.zip | |
Don't use a subquery when there are joins. Use a required alias for the subquery.
Diffstat (limited to 'spec/engines/sql')
| -rw-r--r-- | spec/engines/sql/unit/relations/take_spec.rb | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/spec/engines/sql/unit/relations/take_spec.rb b/spec/engines/sql/unit/relations/take_spec.rb index 1e0d3e3cfe..ad46190f7e 100644 --- a/spec/engines/sql/unit/relations/take_spec.rb +++ b/spec/engines/sql/unit/relations/take_spec.rb @@ -58,15 +58,15 @@ module Arel adapter_is :mysql do sql.should be_like(%Q{ - SELECT COUNT(`users`.`id`) AS count_id - FROM (SELECT 1 FROM `users` LIMIT 4) + SELECT COUNT(*) AS count_id + FROM (SELECT 1 FROM `users` LIMIT 4) AS subquery }) end adapter_is_not :mysql, :oracle do sql.should be_like(%Q{ - SELECT COUNT("users"."id") AS count_id - FROM (SELECT 1 FROM "users" LIMIT 4) + SELECT COUNT(*) AS count_id + FROM (SELECT 1 FROM "users" LIMIT 4) AS subquery }) end end |