sqlalchemy-tickets

[Sqlalchemy-tickets] =?utf-8?q?=5Bsqlalchemy=5D_=23126=3A_Oracle_use=5Fansi=3DFalse_and_many-t?= =?utf-8?q?o-many_relation_returns_all_rows?=

[sqlalchemy <mi...@zz...>]

IzEyNjogT3JhY2xlIHVzZV9hbnNpPUZhbHNlIGFuZCBtYW55LXRvLW1hbnkgcmVsYXRpb24gcmV0
dXJucyBhbGwgcm93cw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
Ky0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFJlcG9ydGVyOiAgYW5kcmlqYStz
cWxhbGNoZW15QGdtYWlsLmNvbSAgfCAgICAgICBPd25lcjogIHp6emVlaw0KICAgICBUeXBlOiAg
ZGVmZWN0ICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAgIFN0YXR1czogIG5ldyAgIA0KIFBy
aW9yaXR5OiAgbWFqb3IgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIE1pbGVzdG9uZTogICAg
ICAgIA0KQ29tcG9uZW50OiAgb3JhY2xlICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAgVmVy
c2lvbjogICAgICAgIA0KIEtleXdvcmRzOiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
fCAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpJZiB1c2VyX2Fuc2k9RmFsc2UgaXMgdXNlZCBpbiBP
cmFjbGUgZW5naW5lLCBtYW55LXRvLW1hbnkgcmVsYXRpb25zDQogZG9lc24ndCB3b3JrIHByb3Bl
cmx5Lg0KDQogSGVyZSBpcyB0aGUgc2xpZ3RobHkgbW9kaWZpZWQgdGVzdCBjb2RlIGZyb20NCiBb
aHR0cDovL3d3dy5zcWxhbGNoZW15Lm9yZy9kb2NzL2RhdGFtYXBwaW5nLm15dCNkYXRhbWFwcGlu
Z19tYW55dG9tYW55XQ0KDQoNCiB7e3sNCiBmcm9tIHNxbGFsY2hlbXkgaW1wb3J0ICoNCg0KIGVu
Z2luZSA9DQogY3JlYXRlX2VuZ2luZSgnb3JhY2xlOi8vdXNlcj10ZXN0JnBhc3N3b3JkPXRlc3Qn
LHVzZV9hbnNpPUZhbHNlLGVjaG89MCkNCg0KDQogYXJ0aWNsZXMgPSBUYWJsZSgnYXJ0aWNsZXMn
LCBlbmdpbmUsDQogICAgIENvbHVtbignYXJ0aWNsZV9pZCcsIEludGVnZXIsIFNlcXVlbmNlKCdh
cnRpY2xlc19zZXEnKSxwcmltYXJ5X2tleSA9DQogVHJ1ZSksDQogICAgIENvbHVtbignaGVhZGxp
bmUnLCBTdHJpbmcoMTUwKSwga2V5PSdoZWFkbGluZScpLA0KICAgICBDb2x1bW4oJ2JvZHknLCBU
RVhULCBrZXk9J2JvZHknKSwNCiApDQoNCiBrZXl3b3JkcyA9IFRhYmxlKCdrZXl3b3JkcycsIGVu
Z2luZSwNCiAgICAgQ29sdW1uKCdrZXl3b3JkX2lkJywgSW50ZWdlciwgU2VxdWVuY2UoJ2tleXdv
cmRzX3NlcScpLCBwcmltYXJ5X2tleSA9DQogVHJ1ZSksDQogICAgIENvbHVtbigna2V5d29yZF9u
YW1lJywgU3RyaW5nKDUwKSkNCiApDQoNCiBpdGVta2V5d29yZHMgPSBUYWJsZSgnYXJ0aWNsZV9r
ZXl3b3JkcycsIGVuZ2luZSwNCiAgICAgQ29sdW1uKCdhcnRpY2xlX2lkJywgSW50ZWdlciwgRm9y
ZWlnbktleSgiYXJ0aWNsZXMuYXJ0aWNsZV9pZCIpKSwNCiAgICAgQ29sdW1uKCdrZXl3b3JkX2lk
JywgSW50ZWdlciwgRm9yZWlnbktleSgia2V5d29yZHMua2V5d29yZF9pZCIpKQ0KICkNCg0KDQog
IyBjbGFzcyBkZWZpbml0aW9ucw0KIGNsYXNzIEtleXdvcmQob2JqZWN0KToNCiAgICAgZGVmIF9f
aW5pdF9fKHNlbGYsIG5hbWUgPSBOb25lKToNCiAgICAgICAgIHNlbGYua2V5d29yZF9uYW1lID0g
bmFtZQ0KDQogY2xhc3MgQXJ0aWNsZShvYmplY3QpOg0KICAgICBwYXNzDQoNCiAjIGRlZmluZSBh
IG1hcHBlciB0aGF0IGRvZXMgbWFueS10by1tYW55IG9uIHRoZSAnaXRlbWtleXdvcmRzJyBhc3Nv
Y2lhdGlvbg0KICMgdGFibGUNCiBBcnRpY2xlLm1hcHBlciA9IG1hcHBlcihBcnRpY2xlLCBhcnRp
Y2xlcywgcHJvcGVydGllcyA9IGRpY3QoDQogICAgICAgICBrZXl3b3JkcyA9IHJlbGF0aW9uKG1h
cHBlcihLZXl3b3JkLCBrZXl3b3JkcyksIGl0ZW1rZXl3b3JkcywNCiBsYXp5PUZhbHNlKQ0KICAg
ICAgICAgKQ0KICAgICApDQoNCiBhcnRpY2xlID0gQXJ0aWNsZSgpDQogYXJ0aWNsZS5oZWFkbGlu
ZSA9ICdhIGhlYWRsaW5lJw0KIGFydGljbGUuYm9keSA9ICd0aGlzIGlzIHRoZSBib2R5Jw0KIGFy
dGljbGUua2V5d29yZHMuYXBwZW5kKEtleXdvcmQoJ3BvbGl0aWNzJykpDQogYXJ0aWNsZS5rZXl3
b3Jkcy5hcHBlbmQoS2V5d29yZCgnZW50ZXJ0YWlubWVudCcpKQ0KDQogb2JqZWN0c3RvcmUuY29t
bWl0KCkNCg0KIGFydGljbGUgPSBBcnRpY2xlKCkNCiBhcnRpY2xlLmhlYWRsaW5lID0gJ3NlY29u
ZCBoZWFkJw0KIGFydGljbGUuYm9keSA9ICdhbSBpIGEgdHdpbj8nDQogYXJ0aWNsZS5rZXl3b3Jk
cy5hcHBlbmQoS2V5d29yZCgnYml6emFyZScpKQ0KIGFydGljbGUua2V5d29yZHMuYXBwZW5kKEtl
eXdvcmQoJ2VudGVydGFpbm1lbnQnKSkNCg0KIG9iamVjdHN0b3JlLmNvbW1pdCgpDQoNCiBzID0g
QXJ0aWNsZS5tYXBwZXIuc2VsZWN0X2J5KGhlYWRsaW5lPSdhIGhlYWRsaW5lJykNCiBmb3IgayBp
biBzWzBdLmtleXdvcmRzOg0KICAgICBwcmludCBrLmtleXdvcmRfbmFtZQ0KDQogfX19DQoNCiBJ
dCBwcmludHMgYWxsIGtleXdvcmRzIGZyb20gdGhlIHRhYmxlLCBub3QganVzdCB0d28gb2YgdGhl
bS4NCg0KIEluc3BlY3Rpb24gb2YgU1FMIHN0YXRlbWVudHMgdGVsbHMgdGhhdCBvbmx5IG9uZSBq
b2luIGlzIGluIFdIRVJFDQogc3RhdGVtZW50IChvbiBrZXl3b3JkczphcnRpY2xlX2tleXdvcmRz
KSBidXQgIGFydGljbGVfa2V5d29yZHM6YXJ0aWNsZXMNCiByZWxhdGlvbiBpcyBtaXNzaW5nLg0K
DQotLSANClRpY2tldCBVUkw6IDxodHRwOi8vd3d3LnNxbGFsY2hlbXkub3JnL3RyYWMvdGlja2V0
LzEyNj4NCnNxbGFsY2hlbXkgPGh0dHA6Ly9leGFtcGxlLmNvbS8+DQpNeSBleGFtcGxlIHByb2pl
Y3Q=

[Sqlalchemy-tickets] =?utf-8?q?Re=3A_=5Bsqlalchemy=5D_=23126=3A_Oracle_use=5Fansi=3DFalse_and_?= =?utf-8?q?many-to-many_relation_returns_all_rows?=

[sqlalchemy <mi...@zz...>]

IzEyNjogT3JhY2xlIHVzZV9hbnNpPUZhbHNlIGFuZCBtYW55LXRvLW1hbnkgcmVsYXRpb24gcmV0
dXJucyBhbGwgcm93cw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICBSZXBvcnRlcjogIGFuZHJpamEr
c3FsYWxjaGVteUBnbWFpbC5jb20gIHwgICAgICAgT3duZXI6ICB6enplZWsNCiAgICAgIFR5cGU6
ICBkZWZlY3QgICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgU3RhdHVzOiAgbmV3ICAgDQog
IFByaW9yaXR5OiAgbWFqb3IgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIE1pbGVzdG9uZTog
ICAgICAgIA0KIENvbXBvbmVudDogIG9yYWNsZSAgICAgICAgICAgICAgICAgICAgICAgIHwgICAg
IFZlcnNpb246ICAgICAgICANClJlc29sdXRpb246ICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICB8ICAgIEtleXdvcmRzOiAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpDb21tZW50
IChieSB6enplZWspOg0KDQogb2ssIHVzZV9hbnNpPUZhbHNlIGhhcyBiYXNpY2FsbHkgbmV2ZXIg
YmVlbiBtYWludGFpbmVkIG9yIHRlc3RlZCBleGNlcHQNCiBmb3IgbWF5YmUgdGhlIGZpcnN0IHR3
byB3ZWVrcyBJIHdhcyB3cml0aW5nIFNRTCBjb25zdHJ1Y3Rpb24gY29kZSwgSSBhbQ0KIHN1cmUg
aXQgYnJlYWtzIGluIGEgemlsbGlvbiBkaWZmZXJlbnQgY29uZGl0aW9ucy4gIFRoaXMgaXMgYmVj
dWFzZSBJIGhhZA0KIHRoZSBub3Rpb24gdGhhdCBteSBvd24gZXhwZXJpZW5jZSB3aXRoIGFuIGFu
c2ktbm9uY29tcGxpYW50IE9yYWNsZSB3YXMNCiBzb21lIGFuZWNkb3RhbCBmaWdtZW50IG9mIG15
IHBhc3QsIGFuZCB0aGUgd2hvbGUgaWRlYSBvZiB1c2luZyB0aGUgKCspDQogb3BlcmF0b3Igd2Fz
IHNvbWV3aGF0IG9mIGEgbm92ZWx0eS4NCg0KIFRoZSBtZWNoYW5pY3Mgb2YgY29uc3RydWN0aW5n
IEpPSU5TIGhhcyBiZWNvbWUgYW4gZXh0cmVtZWx5IGNvbXBsZXggYmVhc3QNCiBzaW5jZSB0aGVu
IGFuZCBJIGhhdmVudCBsb29rZWQgaW50byBob3cgd2VsbCB0aGUgdXNlX2Fuc2k9RmFsc2UNCiB0
cmFuc2xhdGlvbiB0cmljayBjYW4gd29yayB3aXRoIGFsbCBvZiB0aG9zZSBjb25kaXRpb25zLiAg
SXQgbWlnaHQgYmUgdmVyeQ0KIGVhc3kgb3IgbWlnaHQgYmUgbW9yZSBuaWdodG1hcmlzaC4NCg0K
IHNvIHN1cHBvc2luZyB0aGF0IGl0cyBuaWdodG1hcmlzaCwgdW5kZXIgd2hhdCBjb25kaXRpb25z
IGRvZXMgT3JhY2xlIG5vdA0KIGtub3cgYWJvdXQgdGhlIEpPSU4ga2V5d29yZCA/ICBpcyB0aGF0
IGFsbCB2ZXJzaW9ucyBvZiBPcmFjbGUgcHJpb3IgdG8gOSwNCiBvciBpcyBpdCBjb25maWd1cmFi
bGUgPw0KDQotLSANClRpY2tldCBVUkw6IDxodHRwOi8vd3d3LnNxbGFsY2hlbXkub3JnL3RyYWMv
dGlja2V0LzEyNj4NCnNxbGFsY2hlbXkgPGh0dHA6Ly9leGFtcGxlLmNvbS8+DQpNeSBleGFtcGxl
IHByb2plY3Q=

[Sqlalchemy-tickets] =?utf-8?q?Re=3A_=5Bsqlalchemy=5D_=23126=3A_Oracle_use=5Fansi=3DFalse_and_?= =?utf-8?q?many-to-many_relation_returns_all_rows?=

[sqlalchemy <mi...@zz...>]

IzEyNjogT3JhY2xlIHVzZV9hbnNpPUZhbHNlIGFuZCBtYW55LXRvLW1hbnkgcmVsYXRpb24gcmV0
dXJucyBhbGwgcm93cw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICBSZXBvcnRlcjogIGFuZHJpamEr
c3FsYWxjaGVteUBnbWFpbC5jb20gIHwgICAgICAgT3duZXI6ICB6enplZWsNCiAgICAgIFR5cGU6
ICBkZWZlY3QgICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgU3RhdHVzOiAgbmV3ICAgDQog
IFByaW9yaXR5OiAgbWFqb3IgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIE1pbGVzdG9uZTog
ICAgICAgIA0KIENvbXBvbmVudDogIG9yYWNsZSAgICAgICAgICAgICAgICAgICAgICAgIHwgICAg
IFZlcnNpb246ICAgICAgICANClJlc29sdXRpb246ICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICB8ICAgIEtleXdvcmRzOiAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpDb21tZW50
IChieSBhbmRyaWphKToNCg0KIGFsbCBPcmFjbGUgdmVyc2lvbnMgcHJpb3IgdG8gOSB1c2UgdGhl
ICgrKSBzeW50YXggZm9yIG91dGVyIGpvaW4sIGFuZCB0aGF0DQogaXMgbm90IGFuIG9wdGlvbi4N
Cg0KLS0gDQpUaWNrZXQgVVJMOiA8aHR0cDovL3d3dy5zcWxhbGNoZW15Lm9yZy90cmFjL3RpY2tl
dC8xMjY+DQpzcWxhbGNoZW15IDxodHRwOi8vZXhhbXBsZS5jb20vPg0KTXkgZXhhbXBsZSBwcm9q
ZWN0

[Sqlalchemy-tickets] =?utf-8?q?Re=3A_=5Bsqlalchemy=5D_=23126=3A_Oracle_use=5Fansi=3DFalse_and_?= =?utf-8?q?many-to-many_relation_returns_all_rows?=

[sqlalchemy <mi...@zz...>]

IzEyNjogT3JhY2xlIHVzZV9hbnNpPUZhbHNlIGFuZCBtYW55LXRvLW1hbnkgcmVsYXRpb24gcmV0
dXJucyBhbGwgcm93cw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICBSZXBvcnRlcjogIGFuZHJpamEr
c3FsYWxjaGVteUBnbWFpbC5jb20gIHwgICAgICAgT3duZXI6ICB6enplZWsNCiAgICAgIFR5cGU6
ICBkZWZlY3QgICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgU3RhdHVzOiAgY2xvc2VkDQog
IFByaW9yaXR5OiAgbWFqb3IgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIE1pbGVzdG9uZTog
ICAgICAgIA0KIENvbXBvbmVudDogIG9yYWNsZSAgICAgICAgICAgICAgICAgICAgICAgIHwgICAg
IFZlcnNpb246ICAgICAgICANClJlc29sdXRpb246ICBmaXhlZCAgICAgICAgICAgICAgICAgICAg
ICAgICB8ICAgIEtleXdvcmRzOiAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpDaGFuZ2Vz
IChieSB6enplZWspOg0KDQogICogcmVzb2x1dGlvbjogID0+IGZpeGVkDQogICogc3RhdHVzOiAg
bmV3ID0+IGNsb3NlZA0KDQpDb21tZW50Og0KDQogZ29vZCBuZXdzLCBJIGdvdCBzb21lIGFkanVz
dG1lbnRzIHRvIHRoZSBKT0lOIG1vZGlmaWVyIGluIHRoZSBvcmFjbGUNCiBjb21waWxlciBhbmQg
bXVsdGktcGFydCBKT0lOcyBzZWVtIHRvIGJlIHdvcmtpbmcgbm93LiAgYWRkZWQgYSB0ZXN0IHRh
cmdldA0KICdvcmFjbGU4JyB0byB0aGUgdGVzdCBzdWl0ZSB0byBlbmFibGUgcnVubmluZyB0aHJ1
IGFsbCB0aGUgdGVzdHMgd2l0aA0KIHVzZV9hbnNpPUZhbHNlLiAgdGhlIG1hcHBlci5weSBhbmQg
b2JqZWN0c3RvcmUucHksIHdoaWNoIGFyZSB0aGUgcHJpbWFyeQ0KIGtpbGxlcnMgb2YgbWFwcGVy
IGxhenkgYW5kIGVhZ2VyIGxvYWRpbmcsIGJvdGggcGFzcyB3aXRoIG9yYWNsZTggbm93LCBzbw0K
IHlvdSBzaG91bGQgaGF2ZSBkZWNlbnQgcmVzdWx0cy4gIHNvIGkgd2lsbCBjbG9zZSB0aGlzIHRp
Y2tldCB3aGljaCB3YXMNCiBmaXhlZCBhY3Jvc3MgW2NoYW5nZXNldDoxMTg3XSwgW2NoYW5nZXNl
dDoxMTg4XSwgW2NoYW5nZXNldDoxMTg5XS4NCg0KIGl0cyB2ZXJ5IGxpa2VseSBvcmFjbGU4IHdp
bGwgaGF2ZSBtb3JlIGlzc3VlcyBzbyBvcGVuIG1vcmUgdGlja2V0cyBmb3INCiB0aGF0LCB0aGlz
IHRpY2tldCByZXByZXNlbnRzICJvcmFjbGU4L25vbi1hbnNpIHRvdGFsbHkgYnJva2VuIiB3aGlj
aCBpcw0KIHJlc29sdmVkIG5vdy4NCg0KLS0gDQpUaWNrZXQgVVJMOiA8aHR0cDovL3d3dy5zcWxh
bGNoZW15Lm9yZy90cmFjL3RpY2tldC8xMjY+DQpzcWxhbGNoZW15IDxodHRwOi8vZXhhbXBsZS5j
b20vPg0KTXkgZXhhbXBsZSBwcm9qZWN0