This project is archived and is in readonly mode.

#4767 new
arash

Find ignore select when conditions & include are specfied

Reported by arash | June 4th, 2010 @ 05:24 PM

I expected that if I specify the :select option inside a find tag, it will always be respected; but apparently, if also specify conditions which rely on an 'included' model, it just does a select *:

?> Comment.first(:select => 'comments.*', :conditions => "users.first_name = 'Arash'", :include => :user) Comment Load Including Associations (0.9ms) SELECT comments.id AS t0_r0, comments.comment AS t0_r1, comments.owner_table AS t0_r2, comments.owner_id AS t0_r3, comments.user_id AS t0_r4, comments.status_id AS t0_r5, comments.deleted AS t0_r6, comments.created_at AS t0_r7, comments.updated_at AS t0_r8, users.id AS t1_r0, users.account_name AS t1_r1, users.first_name AS t1_r2, users.last_name AS t1_r3, users.email AS t1_r4, users.deleted AS t1_r8, users.created_at AS t1_r9, users.updated_at AS t1_r10 FROM comments LEFT OUTER JOIN users ON users.id = comments.user_id AND users.deleted = 0 WHERE (( users.first_name = 'Arash' ) AND comments.deleted = 0) LIMIT 1

The occurs in rails 2.3.4

Comments and changes to this ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>

People watching this ticket

Pages