This project is archived and is in readonly mode.

#271 ✓ resolved
Jan De Poorter

make count(:conditions => {}) work on has_many associations

Reported by Jan De Poorter | May 28th, 2008 @ 08:01 PM

When using conditions from a variable, it can sometimes be an empty hash (at least in my projects). When using it with count on a ActiveRecord::Base:

User.count :conditions => {}
# => 3

But when working on a has_many association, this happens:

>> User.first.certificates.count :conditions => {}
ActiveRecord::StatementInvalid: Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1: SELECT count(*) AS count_all FROM `certificates`     WHERE (`certificates`.user_id = 442758120 AND ()) 

a patch to fix this has been attached

Comments and changes to this ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

Tickets have moved to Github

The new ticket tracker is available at https://github.com/rails/rails/issues

Shared Ticket Bins

Attachments

Pages