aboutsummaryrefslogtreecommitdiffstats
path: root/test
diff options
context:
space:
mode:
authorAaron Patterson <aaron.patterson@gmail.com>2011-10-30 23:20:48 -0700
committerAaron Patterson <aaron.patterson@gmail.com>2011-10-30 23:20:48 -0700
commit411336b86712df79016c2a4f36fe4e943546a185 (patch)
treed98a23e364f0fa44f1bedb2fb0d09fb45a8011ae /test
parent8ab89f5200cdab1aa955e3217b5dd4089d50d63e (diff)
parent2680d6485ae79f7232f032e3209a371e17c76191 (diff)
downloadrails-411336b86712df79016c2a4f36fe4e943546a185.tar.gz
rails-411336b86712df79016c2a4f36fe4e943546a185.tar.bz2
rails-411336b86712df79016c2a4f36fe4e943546a185.zip
Merge pull request #90 from JoelJuliano/patch-1
Allow using non-table alias as a rhs relation name, fix for #84 and #59
Diffstat (limited to 'test')
-rw-r--r--test/test_select_manager.rb17
1 files changed, 17 insertions, 0 deletions
diff --git a/test/test_select_manager.rb b/test/test_select_manager.rb
index 7e9099d0d0..a00d1843ba 100644
--- a/test/test_select_manager.rb
+++ b/test/test_select_manager.rb
@@ -654,6 +654,23 @@ module Arel
}
end
+ it 'can have a non-table alias as relation name' do
+ users = Table.new :users
+ comments = Table.new :comments
+
+ counts = comments.from(comments).
+ group(comments[:user_id]).
+ project(
+ comments[:user_id].as("user_id"),
+ comments[:user_id].count.as("count")
+ ).as("counts")
+
+ joins = users.join(counts).on(counts[:user_id].eq(10))
+ joins.to_sql.must_be_like %{
+ SELECT FROM "users" INNER JOIN (SELECT "comments"."user_id" AS user_id, COUNT("comments"."user_id") AS count FROM "comments" GROUP BY "comments"."user_id") counts ON counts."user_id" = 10
+ }
+ end
+
it 'returns string join sql' do
table = Table.new :users
manager = Arel::SelectManager.new Table.engine