[Rails] Re: In Rails 3.1 Model.count() ignores :include - no outer join in generated SQL

2011-09-08 Thread Dmitry Suzdalev
Just for the record (in case anyone would search for the same thing): See this thread for more info: http://goo.gl/30nQF -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/

[Rails] Re: In Rails 3.1 Model.count() ignores :include - no outer join in generated SQL

2011-09-06 Thread Dmitry Suzdalev
Well, I need the outer join to find if some fields of right table are null wrt left one... Good point about spelling joins clause, thank you! Will try that! :) But other than that - do you think this might be a bug I should report? :-) I'd be willing to do so... On Tuesday, September 6, 2011 10:

[Rails] Re: In Rails 3.1 Model.count() ignores :include - no outer join in generated SQL

2011-09-06 Thread Frederick Cheung
On Sep 6, 6:10 pm, Dmitry Suzdalev wrote: > Ah, I see. > Unfortunately I need exactly to call a count() method with left outer join > of another table If you want a join, why not use the :joins option ? (I think there's an option these days for that to do left joins, if not then you can alw

[Rails] Re: In Rails 3.1 Model.count() ignores :include - no outer join in generated SQL

2011-09-06 Thread Dmitry Suzdalev
Ah, I see. Unfortunately I need exactly to call a count() method with left outer join of another table -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonra

[Rails] Re: In Rails 3.1 Model.count() ignores :include - no outer join in generated SQL

2011-09-06 Thread Frederick Cheung
On Sep 6, 4:23 pm, Dmitry Suzdalev wrote: > On Tuesday, September 6, 2011 7:12:05 PM UTC+4, Frederick Cheung wrote: > > > From which version did you upgrade? > > Upgraded from 3.0.10. > Before upgrading I ran all of my tests to ensure they pass. > After upgrading got a couple of test failures re

[Rails] Re: In Rails 3.1 Model.count() ignores :include - no outer join in generated SQL

2011-09-06 Thread Dmitry Suzdalev
On Tuesday, September 6, 2011 7:12:05 PM UTC+4, Frederick Cheung wrote: > > From which version did you upgrade? > Upgraded from 3.0.10. Before upgrading I ran all of my tests to ensure they pass. After upgrading got a couple of test failures related to this issue... > Part of the problem with

[Rails] Re: In Rails 3.1 Model.count() ignores :include - no outer join in generated SQL

2011-09-06 Thread Frederick Cheung
On Sep 6, 3:51 pm, Dmitry Suzdalev wrote: > So guys, no ideas about this one? > Why Model.count is completely broken in 3.1 when using :include option? > (see my original mail for details) > >From which version did you upgrade? Part of the problem with include is that there has (for some years n

[Rails] Re: In Rails 3.1 Model.count() ignores :include - no outer join in generated SQL

2011-09-06 Thread Dmitry Suzdalev
So guys, no ideas about this one? Why Model.count is completely broken in 3.1 when using :include option? (see my original mail for details) I consider two possibilities: 1) there might be some new option which I need to enable (though strange that this was not announced) 2) this is some regressi