[sqlalchemy] Re: Duplicate primary key while merging polymorphic relationship

2017-02-01 Thread Shane Carey
I resolved this issue, it was a misconfiguration of my 'polymorphic_on' On Wednesday, February 1, 2017 at 8:35:59 AM UTC-6, Shane Carey wrote: > > I took the SQL into mysql directly to see what may be going wrong, it > looks like the generated > > SELECT > thing.id AS thing_id, > thing.type_id

[sqlalchemy] Re: Duplicate primary key while merging polymorphic relationship

2017-02-01 Thread Shane Carey
I took the SQL into mysql directly to see what may be going wrong, it looks like the generated SELECT thing.id AS thing_id, thing.type_id AS thing_type_id, thing.txt AS thing_txt, (SELECT type.id FROM type WHERE type.id = thing.type_id) AS _sa_polymorphic_on, thing.stuff AS thing_stuff FROM