using table_alias when :as is passed to the constructor

1 files changed, 9 insertions, 0 deletions

diff --git a/spec/arel/select_manager_spec.rb b/spec/arel/select_manager_spec.rb
index 86a4daee44..2ed1a851e5 100644
--- a/spec/arel/select_manager_spec.rb
+++ b/spec/arel/select_manager_spec.rb
@@ -49,6 +49,15 @@ module Arel
       end
     end
 
+    describe 'initialize' do
+      it 'uses alias in sql' do
+        table   = Table.new :users, :engine => Table.engine, :as => 'foo'
+        mgr = table.from table
+        mgr.skip 10
+        mgr.to_sql.should be_like %{ SELECT FROM "users" "foo" OFFSET 10 }
+      end
+    end
+
     describe 'skip' do
       it 'should add an offset' do
         table   = Table.new :users