aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/RUNNING_UNIT_TESTS.rdoc
diff options
context:
space:
mode:
authorRafael Sales <rafaelcds@gmail.com>2015-10-12 23:18:51 -0300
committerRafael Sales <rafaelcds@gmail.com>2015-10-22 04:22:57 -0300
commitc2d33c4abf01ec25b2d1528a7dae923aef5a30af (patch)
tree309b3035ad66d0e62467ceeecfd0d9d3061df10a /activerecord/RUNNING_UNIT_TESTS.rdoc
parentd8b076c90efac796e8664c6eada8d08afac4bea3 (diff)
downloadrails-c2d33c4abf01ec25b2d1528a7dae923aef5a30af.tar.gz
rails-c2d33c4abf01ec25b2d1528a7dae923aef5a30af.tar.bz2
rails-c2d33c4abf01ec25b2d1528a7dae923aef5a30af.zip
Fix generated projection fields in group by query
Closes #21922 Let `Book(id, author_id)`, `Photo(id, book_id, author_id)` and `Author(id)` Running `Book.group(:author_id).joins(:photos).count` will produce: * Rails 4.2 - conflicts `author_id` in both projection and group by: ```sql SELECT COUNT(*) AS count_all, author_id AS author_id FROM "books" INNER JOIN "photos" ON "photos"."book_id" = "books"."id" GROUP BY author_id ``` * Master (9d02a25) - conflicts `author_id` only in projection: ```sql SELECT COUNT(*) AS count_all, author_id AS author_id FROM "books" INNER JOIN "photos" ON "photos"."book_id" = "books"."id" GROUP BY "books"."author_id" ``` * With this fix: ```sql SELECT COUNT(*) AS count_all, "books"."author_id" AS books_author_id FROM "books" INNER JOIN "photos" ON "photos"."book_id" = "books"."id" GROUP BY "books"."author_id" ```
Diffstat (limited to 'activerecord/RUNNING_UNIT_TESTS.rdoc')
0 files changed, 0 insertions, 0 deletions