Rails 3.1 RC4 default_scope and count

rubyonrails-core
#1

I've run into an issue in Rails 3.1 RC4 where the count query is
failing because of a default_scope. The scope has an include and a
condition on the included association but count is dropping the
include. Here's what it looks like -

default_scope where('campaigns.inactive = ?',
false).order('funds.name').includes(:campaigns)

Rails 3.1 RC4 -

ruby-1.9.2-p180 :001 > Fund.count
[2011-06-12 14:35:43 | WARN | n/a | named_scope.rb:175:in
`valid_scope_name?']

Creating scope :all. Overwriting existing method Fund.all.

[2011-06-12 14:35:43 | DEBUG | n/a | log_subscriber.rb:105:in `debug']

   (0.4ms) SELECT COUNT(*) FROM "funds" WHERE (campaigns.inactive = 'f')

ActiveRecord::StatementInvalid: PGError: ERROR: missing FROM-clause
entry for table "campaigns"
LINE 1: SELECT COUNT(*) FROM "funds" WHERE (campaigns.inactive =
'f...

Rails 3.0.8 -

ruby-1.9.2-p180 :001 > Fund.count
=> 1

SQL (43.8ms) SELECT COUNT(DISTINCT "funds"."id") FROM "funds" LEFT
OUTER JOIN "campaigns" ON "campaigns"."fund_id" = "funds"."id" WHERE
(campaigns.inactive = 'f')

#2

Please could you file this as an issue on Github, with a full example of
the models you are using?

Jon

#3

Hi, I've always had problems when I used a "includes" in a default
scope with methods such as "count" or "built", try to remove the
"includes(:campaigns)", of course the ('campaigns.inactive = ?',
false) do not work.

You can use a specific scope like :actives, where('campaigns.inactive
= ?', false)

¿A better solution?