[Rails] Re: :first and :all giving different first records

2009-03-31 Thread Ryan Waldron
Thank you! That was it. You're the man! :) I went ahead and jumped from MySQL 5.0.x to 5.1.32, so no doubt I will soon have new adventures to relate. On Tue, Mar 31, 2009 at 10:39 AM, Frederick Cheung < frederick.che...@gmail.com> wrote: > > On Mar 31, 4:20 pm, Danimal wrote: > > > > If it do

[Rails] Re: :first and :all giving different first records

2009-03-31 Thread Frederick Cheung
On Mar 31, 4:20 pm, Danimal wrote: > > If it doesn't work right in SQL, then you've ruled out Rails, and can > focus on what is screwed up with MySQL. > It's a mysql bug: see http://bugs.mysql.com/bug.php?id=37830 and http://lists.mysql.com/commits/49739 Fred > Best of luck! Post your respons

[Rails] Re: :first and :all giving different first records

2009-03-31 Thread Danimal
Ryan, I had something similar on Rails 2.2.2 recently. In my case, Object.first was returning nil but Object.all.first was working. I banged my head for a bit then decided it wasn't important to "solve" it at this time as the client just needed the project done, so I left it as Object.all.first,