On Oct 24, 12:36 pm, Lars Christensen <[EMAIL PROTECTED]> wrote:
> I have this simple model with orders and products. Orders looks like
> this:
>
> class Order < ActiveRecord::Base
> has_many :orders_products, :foreign_key => :order_id
> has_many :products, :through => :orders_products
> has_many :priority_products, :through => :orders_products, :source
> => :product, :conditions => { "orders_products.priority" => true }
> end
>
> The :condition on :priority_products is cause problems for me. It
> worked fine in Rails 2.0.2, but breaks in Rails 2.1.1 when putting the
> relation in a :include clause:
>
> orders = Order.find(:all, :include => :priority_products)
This is a problem with 2.1's implementation of eager loading. You
should be able to force a fallback to the old code by adding something
like :conditions => "some trivial condition on the priority_products
or orders_products table")
Fred
>
> This result in PostgreSQL saying: missing FROM-clause entry for table
> "orders_products"
>
> for this malformed query:
>
> SELECT * FROM "products" WHERE ("products"."id" IN (1,2,3) AND
> ("orders_products"."priority" = 't'))
>
> Full working example:http://pastie.org/299592
>
> Is this something that should work, or am I making some mistake?
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
