From 6c61ebb4d677f9bc5e1a669e7351c1226cbc9582 Mon Sep 17 00:00:00 2001 From: Nick Kallen Date: Thu, 1 May 2008 21:23:55 -0700 Subject: naming of aliased relations seemed to be solved; now aggregate relations are still broken --- spec/arel/unit/relations/join_spec.rb | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'spec') diff --git a/spec/arel/unit/relations/join_spec.rb b/spec/arel/unit/relations/join_spec.rb index f74bd32ef8..c08ff68f36 100644 --- a/spec/arel/unit/relations/join_spec.rb +++ b/spec/arel/unit/relations/join_spec.rb @@ -146,16 +146,18 @@ module Arel describe 'when joining the same relation to itself' do describe '#to_sql' do it '' do + relation2 = @relation1.alias + relation3 = @relation1.alias @relation1 \ - .join(@relation1.alias.join(@relation1.alias).on(@relation1[:id].eq(1))) \ - .on(@relation1[:id].eq(1)) \ + .join(relation2.join(relation3).on(relation2[:id].eq(relation3[:id]))) \ + .on(@relation1[:id].eq(relation2[:id])) \ .to_sql.should be_like(" SELECT `users`.`id`, `users`.`name`, `users_2`.`id`, `users_2`.`name`, `users_3`.`id`, `users_3`.`name` FROM `users` INNER JOIN `users` AS `users_2` - ON `users`.`id` = 1 + ON `users_2`.`id` = `users_3`.`id` INNER JOIN `users` AS `users_3` - ON `users`.`id` = 1 + ON `users_2`.`id` = `users_3`.`id` ") end -- cgit v1.2.3