On Oct 24, 2012, at 9:35 PM, dnathe4th wrote: > 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?
it de-duplicates on the whole row being returned, not just the first entity. Only when the row contains full entities. > > 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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 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/sqlalchemy?hl=en.
