I'm having a problem related to this as well. Is it possible for a join to get tripped up in the de-dup process or is that guaranteed to only occur for the mapper entity I query on? I am getting the de-duping if I query on the mapped entity, but if I query on the id of the entity I get the full number of rows I am expecting, as you indicated. However beyond that, even if I query on the distinct id's, I am getting back the full number of rows I expected, thus leading me to believe some other entity's primary key is getting de-duplicated. Is that possible?
On Monday, August 6, 2012 3:28:47 PM UTC-7, Michael Bayer wrote: > > the "uniquing" logic is only enabled when you query for mapped entities, > not individual columns, so from the Query the option would be to only query > for individual columns. > > Query could be modified to allow a disabling option, though I wonder why > exactly you'd need duplicate instances back. > > > On Aug 6, 2012, at 6:16 PM, kris wrote: > > Well.. I can certainly understand why it's needed, but in my case I > actually need to receive the two > duplicate instances. > Is there any way to remove this de-duplicate behavior or work around? > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/bGlkp8JDtBQJ. > To post to this group, send email to sqlal...@googlegroups.com<javascript:> > . > To unsubscribe from this group, send email to > sqlalchemy+...@googlegroups.com <javascript:>. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/4Y0C7p6oSk4J. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.