From a040b1c0e68f7a5145a6decf6731be9c371fa24a Mon Sep 17 00:00:00 2001 From: Emilio Tagua Date: Wed, 23 Jun 2010 13:04:59 -0300 Subject: Don't use a subquery when there are joins. Use a required alias for the subquery. --- spec/engines/sql/unit/relations/take_spec.rb | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'spec/engines') 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 -- cgit v1.2.3