#5698 select() ignored in subquery when querying with count() - Ruby on Rails

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

This project is archived and is in readonly mode.

#5698 ✓resolved

select() ignored in subquery when querying with count()

Reported by James | September 24th, 2010 @ 04:31 PM

Login.where(:date => Date.today).select("DISTINCT player_id").all

As expected, this produces the following query:

SELECT DISTINCT player_id FROM `logins` WHERE (`logins`.`date` = '2010-09-24')

The following uses .count instead of .all and ignores the select("DISTINCT..."):

Login.where(:date => Date.today).select("DISTINCT player_id").count

SELECT COUNT(*) AS count_id FROM (SELECT 1 FROM `logins` WHERE (`logins`.`date` = '2010-09-24')) AS subquery

You flagged this item as spam.
gnufied September 26th, 2010 @ 06:01 AM
- Assigned user set to “Aaron Patterson”
- Tag set to “arel activerecord bug rails3, verified”
Verified. The problem does exist (and returned value of count can be potentially wrong).

I am trying to get a patch, but in the meanwhile assigning to tenderlove.
You flagged this item as spam.
gnufied September 26th, 2010 @ 06:26 AM
Hmm, the problem seems to have been fixed on master (Both Arel and Rails). In which case, the fix should be backported to Rails-3.0 stable?
Aaron Patterson September 27th, 2010 @ 06:20 PM
- State changed from “new” to “resolved”
- Importance changed from “” to “Low”
This should be fixed with ARel 2.0, so the 3-0-stable branch should work now.