Eager loading not working in production mode

Rails
1

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

2

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.