Add an #table_name method to Table and TableAlias, which always returns the actual table name, not the alias. Then fix ToSql#column_for to use this table name when checking whether the table exists (rather than before, where it was checking whether a table with the alias name exists, which was incorrect).

1 files changed, 9 insertions, 0 deletions

diff --git a/test/visitors/test_to_sql.rb b/test/visitors/test_to_sql.rb
index c8ad40e242..2d5549ca43 100644
--- a/test/visitors/test_to_sql.rb
+++ b/test/visitors/test_to_sql.rb
@@ -259,6 +259,15 @@ module Arel
           }
         end
       end
+
+      describe 'TableAlias' do
+        it "should use the underlying table for checking columns" do
+          test = Table.new(:users).alias('zomgusers')[:id].eq '3'
+          @visitor.accept(test).must_be_like %{
+            "zomgusers"."id" = 3
+          }
+        end
+      end
     end
   end
 end