[Sqlalchemy-tickets] [sqlalchemy] #768: MSEnum busted somehow when constructing joins

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

Izc2ODogTVNFbnVtIGJ1c3RlZCBzb21laG93IHdoZW4gY29uc3RydWN0aW5nIGpvaW5zDQotLS0t
LS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tDQogUmVwb3J0ZXI6ICB6enplZWsgIHwgICAgICAgICAgT3duZXI6ICB6
enplZWsgICAgICAgICAgICAgIA0KICAgICBUeXBlOiAgZGVmZWN0ICB8ICAgICAgICAgU3RhdHVz
OiAgbmV3ICAgICAgICAgICAgICAgICANCiBQcmlvcml0eTogIGhpZ2ggICAgfCAgICAgIE1pbGVz
dG9uZTogIDAuNC4wICAgICAgICAgICAgICAgDQpDb21wb25lbnQ6ICBteXNxbCAgIHwgICAgICAg
U2V2ZXJpdHk6ICBtaW5vciAtIGhhbGYgYW4gaG91cg0KIEtleXdvcmRzOiAgICAgICAgICB8ICAg
U3RhdHVzX2ZpZWxkOiAgaW4gcXVldWUgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0t
Ky0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N
CiB7e3sNCg0KIEhpLA0KIEkgaGF2ZSB0aGUgZm9sbG93aW5nIHR3byB0YWJsZXMgKGluIE15U3Fs
KToNCg0KIENSRUFURSBUQUJMRSBgQWAgKA0KICAgYHhrZXlgIHZhcmNoYXIoMjAwKSBOT1QgTlVM
TCwNCiAgIGB5dmFsYCBpbnQoMTEpIGRlZmF1bHQgTlVMTCwNCiAgIFBSSU1BUlkgS0VZICAoYHhr
ZXlgKQ0KICkgRU5HSU5FPUlubm9EQjsNCg0KIGFuZA0KDQogQ1JFQVRFIFRBQkxFIGBCYCAoDQog
ICBgeGtleWAgdmFyY2hhcigyMDApIE5PVCBOVUxMIGRlZmF1bHQgJycsDQogICBgc2AgZW51bSgn
eWVzJywnbm8nKSBOT1QgTlVMTCBkZWZhdWx0ICd5ZXMnLA0KICAgUFJJTUFSWSBLRVkgIChgeGtl
eWAsYHNgKQ0KICkgRU5HSU5FPUlubm9EQjsNCg0KIFRoZSBmb2xsb3dpbmcgc3RhdGVtZW50IHdv
cmtlZCBmaW5lIHRpbGwgMC4zLjggLCBhbmQgZnJvbSAwLjMuOSB0aHJvd3MNCiB0aGUgZXhjZXB0
aW9uOg0KDQogb2o9b3V0ZXJqb2luKEEsIEIsICBhbmRfKEEuYy54a2V5PT1CLmMueGtleSwgQi5j
LnM9PSd5ZXMnKSkNCg0KDQogVHJhY2ViYWNrIChtb3N0IHJlY2VudCBjYWxsIGxhc3QpOg0KICAg
RmlsZSAiam9pbi5weSIsIGxpbmUgMTMsIGluID8NCiAgICAgb2o9b3V0ZXJqb2luKEEsIEIsICBh
bmRfKEEuYy54a2V5PT1CLmMueGtleSwgQi5jLnM9PSd5ZXMnKSkNCiAgIEZpbGUgIi91c3IvbG9j
YWwvbGliL3B5dGhvbjIuNC9zaXRlLXBhY2thZ2VzL1NRTEFsY2hlbXktMC4zLjktDQogcHkyLjQu
ZWdnL3NxbGFsY2hlbXkvc3FsLnB5IiwgbGluZSAxMTcsIGluIG91dGVyam9pbg0KICAgICByZXR1
cm4gSm9pbihsZWZ0LCByaWdodCwgb25jbGF1c2UsIGlzb3V0ZXIgPSBUcnVlLCAqKmt3YXJncykN
CiAgIEZpbGUgIi91c3IvbG9jYWwvbGliL3B5dGhvbjIuNC9zaXRlLXBhY2thZ2VzL1NRTEFsY2hl
bXktMC4zLjktDQogcHkyLjQuZWdnL3NxbGFsY2hlbXkvc3FsLnB5IiwgbGluZSAyMjU2LCBpbiBf
X2luaXRfXw0KICAgICBzZWxmLl9pbml0X3ByaW1hcnlfa2V5KCkNCiAgIEZpbGUgIi91c3IvbG9j
YWwvbGliL3B5dGhvbjIuNC9zaXRlLXBhY2thZ2VzL1NRTEFsY2hlbXktMC4zLjktDQogcHkyLjQu
ZWdnL3NxbGFsY2hlbXkvc3FsLnB5IiwgbGluZSAyMjg3LCBpbiBfaW5pdF9wcmltYXJ5X2tleQ0K
ICAgICBpZiBwLnJlZmVyZW5jZXMoYykgb3IgKGMucHJpbWFyeV9rZXkgYW5kIG5vdCBwLnByaW1h
cnlfa2V5KToNCiBBdHRyaWJ1dGVFcnJvcjogJ19CaW5kUGFyYW1DbGF1c2UnIG9iamVjdCBoYXMg
bm8gYXR0cmlidXRlDQogJ3ByaW1hcnlfa2V5Jw0KDQoNCiBOb3RlLCBpZiBCLnMgd2VyZSBub3Qg
YW4gZW51bSBidXQgYSB2YXJjaGFyLCBpdCB3b3VsZCBoYXZlIHdvcmtlZC4NCiB9fX0NCg0KLS0g
DQpUaWNrZXQgVVJMOiA8aHR0cDovL3d3dy5zcWxhbGNoZW15Lm9yZy90cmFjL3RpY2tldC83Njg+
DQpzcWxhbGNoZW15IDxodHRwOi8vZXhhbXBsZS5jb20vPg0KTXkgZXhhbXBsZSBwcm9qZWN0