diff options
Diffstat (limited to 'test')
-rw-r--r-- | test/attributes/test_attribute.rb | 17 |
1 files changed, 10 insertions, 7 deletions
diff --git a/test/attributes/test_attribute.rb b/test/attributes/test_attribute.rb index 500f9385f8..6cfe9fbcbf 100644 --- a/test/attributes/test_attribute.rb +++ b/test/attributes/test_attribute.rb @@ -82,7 +82,7 @@ module Arel mgr = users.project(Arel.star).where(users[:karma].gt(avg)) mgr.to_sql.must_be_like %{ - SELECT * FROM "users" WHERE "users"."karma" > (SELECT AVG("users"."karma") FROM "users") + SELECT * FROM "users" WHERE "users"."karma" > (SELECT AVG("users"."karma") AS avg_id FROM "users") } end @@ -313,11 +313,12 @@ module Arel relation[:id].average.must_be_kind_of Nodes::Avg end - it 'should generate the proper SQL' do + # FIXME: backwards compat. Is this really necessary? + it 'should set the alias to "avg_id"' do relation = Table.new(:users) mgr = relation.project relation[:id].average mgr.to_sql.must_be_like %{ - SELECT AVG("users"."id") + SELECT AVG("users"."id") AS avg_id FROM "users" } end @@ -329,11 +330,12 @@ module Arel relation[:id].maximum.must_be_kind_of Nodes::Max end - it 'should generate the proper SQL' do + # FIXME: backwards compat. Is this really necessary? + it 'should set the alias to "max_id"' do relation = Table.new(:users) mgr = relation.project relation[:id].maximum mgr.to_sql.must_be_like %{ - SELECT MAX("users"."id") + SELECT MAX("users"."id") AS max_id FROM "users" } end @@ -352,11 +354,12 @@ module Arel relation[:id].sum.must_be_kind_of Nodes::Sum end - it 'should generate the proper SQL' do + # FIXME: backwards compat. Is this really necessary? + it 'should set the alias to "sum_id"' do relation = Table.new(:users) mgr = relation.project relation[:id].sum mgr.to_sql.must_be_like %{ - SELECT SUM("users"."id") + SELECT SUM("users"."id") AS sum_id FROM "users" } end |