From 7286f0f4c8117e2210834070d30378ffb12dba23 Mon Sep 17 00:00:00 2001 From: Pratik Naik Date: Tue, 12 Jan 2010 21:40:38 +0530 Subject: Make sure not to use alias if it's same as the table name --- spec/arel/engines/sql/unit/relations/table_spec.rb | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'spec') diff --git a/spec/arel/engines/sql/unit/relations/table_spec.rb b/spec/arel/engines/sql/unit/relations/table_spec.rb index 977eb343e3..d8584ccaec 100644 --- a/spec/arel/engines/sql/unit/relations/table_spec.rb +++ b/spec/arel/engines/sql/unit/relations/table_spec.rb @@ -44,6 +44,25 @@ module Arel }) end end + + it "does not apply alias if it's same as the table name" do + sql = @relation.as(:users).to_sql + + adapter_is :mysql do + sql.should be_like(%Q{ + SELECT `users`.`id`, `users`.`name` + FROM `users` + }) + end + + adapter_is_not :mysql do + sql.should be_like(%Q{ + SELECT "users"."id", "users"."name" + FROM "users" + }) + end + end + end describe '#column_for' do -- cgit v1.2.3