[Sqlalchemy-tickets] =?utf-8?q?=5Bsqlalchemy=5D_=23116=3A_subquery_correlation_a_little_too_ea?= =?utf-8?q?ger?=

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

IzExNjogc3VicXVlcnkgY29ycmVsYXRpb24gYSBsaXR0bGUgdG9vIGVhZ2VyDQotLS0tLS0tLS0t
LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tDQogUmVwb3J0ZXI6ICB6enplZWsgICAgfCAgICAgICBPd25lcjogIHp6emVlaw0K
ICAgICBUeXBlOiAgZGVmZWN0ICAgIHwgICAgICBTdGF0dXM6ICBuZXcgICANCiBQcmlvcml0eTog
IGNyaXRpY2FsICB8ICAgTWlsZXN0b25lOiAgICAgICAgDQpDb21wb25lbnQ6ICBzcWwgICAgICAg
fCAgICAgVmVyc2lvbjogICAgICAgIA0KIEtleXdvcmRzOiAgICAgICAgICAgIHwgIA0KLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLQ0Kc3VicXVlcmllcyBnZXQgdGhlaXIgRlJPTSdzIHlhbmtlZCBvdXQgZXZl
biB3aGVuIHRoZSBlbmNsb3NpbmcgcXVlcnkNCiBkb2VzbnQgcmVmZXJlbmNlIHRoYXQgdGFibGU6
DQoNCiB7e3sNCiBzdWJxID0gdXNlcnMuc2VsZWN0KG9yZGVyX2J5PVt1c2Vycy5jLnVzZXJuYW1l
XSwgbGltaXQ9MikuYWxpYXMoJ3VzZXJzJykNCg0KIHMgPSBzZWxlY3QoDQogICAgICAgICBbc3Vi
cS5jLnVzZXJuYW1lLCByb2xlcy5jLnJvbGVdLA0KICAgICAgICAgZnJvbV9vYmogPSBbDQogICAg
ICAgICAgICAgICAgIHN1YnEuam9pbihyb2xlcywgc3VicS5jLnVzZXJuYW1lPT1yb2xlcy5jLnVz
ZXJuYW1lKQ0KICAgICAgICAgXQ0KICkNCg0KDQogdGhlIHF1ZXJ5IEkgZ2V0IGlzOg0KDQogU0VM
RUNUIHVzZXJzLnVzZXJuYW1lLCByb2xlcy5yb2xlDQogRlJPTSAoU0VMRUNUIHVzZXJzLnVzZXJu
YW1lIEFTIHVzZXJuYW1lIE9SREVSIEJZIHVzZXJzLnVzZXJuYW1lDQogTElNSVQgMikgQVMgdXNl
cnMgSk9JTiByb2xlcyBPTiB1c2Vycy51c2VybmFtZSA9IHJvbGVzLnVzZXJuYW1lDQogfX19DQoN
CiBhZGRpbmcgImNvcnJlbGF0ZT1GYWxzZSIgdG8gdGhlIGFib3ZlIHN1YnF1ZXJ5IG1ha2VzIGl0
IHdvcmsuICBhbHNvDQogY2hhbmdpbmcgdGhlIG5hbWUgICJ1c2VycyIgdG8gInVhbGlhcyIgbWFr
ZXMgaXQgd29yayBhcyB3ZWxsLA0KIGhtbW1tLi4uc2hvdWxkIHRoaXMgdGhyb3cgYW4gZXhjZXB0
aW9uIHRoYXQgdGhlcmVzIGNvbmZsaWN0aW5nIG5hbWVzIGZvcg0KICJ1c2VyIiA/ICBvciB0cmFj
ayB0aGUgRlJPTSBvYmplY3RzIG9uIGlkZW50aXR5IGFuZCBub3QgbmFtZT8NCg0KLS0gDQpUaWNr
ZXQgVVJMOiA8aHR0cDovL3d3dy5zcWxhbGNoZW15Lm9yZy90cmFjL3RpY2tldC8xMTY+DQpzcWxh
bGNoZW15IDxodHRwOi8vZXhhbXBsZS5jb20vPg0KTXkgZXhhbXBsZSBwcm9qZWN0