Table names seem to be disambiguated.

  - Code is a mess, about to undergo some refactoring

1 files changed, 10 insertions, 1 deletions

diff --git a/spec/arel/unit/relations/projection_spec.rb b/spec/arel/unit/relations/projection_spec.rb
index cd59d6c383..eedcf77952 100644
--- a/spec/arel/unit/relations/projection_spec.rb
+++ b/spec/arel/unit/relations/projection_spec.rb
@@ -47,7 +47,7 @@ module Arel
         
         it "manufactures sql with scalar selects" do
           Projection.new(@relation, @scalar_relation).to_sql.should be_like("
-            SELECT (SELECT `users`.`name` FROM `users`) FROM `users`
+            SELECT (SELECT `users`.`name` FROM `users`) AS `users` FROM `users`
           ")
         end
       end
@@ -59,6 +59,15 @@ module Arel
           ")
         end
       end
+      
+      describe 'when given an expression' do
+        it 'manufactures sql with expressions' do
+          @relation.project(@attribute.count).to_sql.should be_like("
+            SELECT COUNT(`users`.`id`)
+            FROM `users`
+          ")
+        end
+      end
     end
     
     describe Projection::Externalizable do