solved - turns out it was an oracle problem: the production database
had the id and foreign key fields defined as NUMBER instead of
INTEGER, which rails turns into floats.
the eager loading query is the same, but the sql rails issues to
eagerly populate the association collections ends up being like "where
group_id = 1.0", and so the query returns zero results. changing the
column types in oracle to INTEGER as they should have been fixes the
problem.
it was working properly in development mode since the dev database
already had the id and foreign key fields defined as INTEGER.
On Apr 26, 11:34 am, jemminger
<jemmin...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> i have an eager load query as such:
>
> @groups = ReviewQuestionGroup.find(:all,
> :conditions => ["review_category_id = ?",
@review.category.id],
> :order => ''review_question_groups.position,
> review_questions.position'',
> :include => :questions)
>
> in dev mode, this works fine... i get results like
> @groups[0].questions.length = 13. in production, i get length = 0 for
> all of the questions associations.
>
> rails is issuing the same SQL statement for both modes, and issuing
> that SQL statement manually against the prod database gives the proper
> results. no errors or exceptions are being thrown or logged that i
> can see.
>
> using rails 1.2.3, oracle 9i
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---