Обсуждение: BUG #14169: Incorrect merge join result in 9.5
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE2OQpMb2dnZWQgYnk6ICAg ICAgICAgIFNoaW50YSBLb3lhbmFnaQpFbWFpbCBhZGRyZXNzOiAgICAgIHlh bmN5YUB1cGVjLmpwClBvc3RncmVTUUwgdmVyc2lvbjogOS41LjMKT3BlcmF0 aW5nIHN5c3RlbTogICBEZWJpYW4gR05VL0xpbnV4IDggKGplc3NpZSkKRGVz Y3JpcHRpb246ICAgICAgICAKCkhpLg0KDQpJIGZvdW5kIHRoYXQgbWVyZ2Ug am9pbiBpbiA5LjUgcmV0dXJucyBpbmNvcnJlY3QgcmVzdWx0IGluIHNvbWUg Y2FzZXMuDQpFdmVuIHRob3VnaCwgbmVzdGVkIGxvb3Agam9pbiBhbmQgaGFz aCBqb2luIHdvcmtzIGNvcnJlY3RseS4NClBsZWFzZSB0YWtlIGEgbG9vayBh dCB0aGUgYXR0YWNoZWQgU1FMIHRvIHJlcHJvZHVjZSBpdC4NCg0KLS0tLS0t LXNhbXBsZS5zcWwtLS0tLS0tLQ0Kc2VsZWN0IHZlcnNpb24oKTsNCg0KQ1JF QVRFIFRFTVAgVEFCTEUgdGVtcF92YWx1ZXMgKA0KICBpZCBzZXJpYWwsIHRh cmdldF9pZCBpbnRlZ2VyLCBkYXRlIGRhdGUNCik7DQpDUkVBVEUgSU5ERVgg aW5kZXhfdGVtcF92YWx1ZXNfdGFyZ2V0X2lkIE9OIHRlbXBfdmFsdWVzICh0 YXJnZXRfaWQpOw0KDQpJTlNFUlQgSU5UTyB0ZW1wX3ZhbHVlcyAodGFyZ2V0 X2lkLCBkYXRlKQ0KU0VMRUNUIGlkLCAnMjAxNi0wNC0wMSc6OmRhdGUgKyAo cmFuZG9tKCkgKiBnZW5lcmF0ZV9zZXJpZXMoMSwKMTAwKSk6OmludGVnZXIN CiAgRlJPTSAoU0VMRUNUIGdlbmVyYXRlX3NlcmllcygxLCAzMDAwMCkpIEFT IHN1YihpZCk7DQotLSBJTlNFUlQgMCAzMDAwMDAwDQoNClZBQ1VVTSBBTkFM WVpFIHRlbXBfdmFsdWVzOw0KDQpDUkVBVEUgVEVNUCBUQUJMRSB0ZW1wX3Rh cmdldHMgKA0KICB0YXJnZXRfaWQgaW50ZWdlciwgbGFiZWwgdGV4dA0KKTsN CklOU0VSVCBJTlRPIHRlbXBfdGFyZ2V0cyh0YXJnZXRfaWQsIGxhYmVsKQ0K c2VsZWN0IHQuaWQsIHJvd19udW1iZXIoKSBPVkVSKFBBUlRJVElPTiBCWSB0 LmlkKTo6dGV4dA0KZnJvbSAodmFsdWVzICgxNDkzMyksICgxNDkwNSksICgx NDkzMSksICgxNDk3NSksICgxNDg4OCksICgxNDg5MSksICgxNDg5NCksCigx NDg5NSksICgxNDg5MiksICgxNDkyMyksICgxNDg4NyksICgxNDg5MCksICgx NDkzNSksICgxODc1NyksICgxNDk2NCksCigxNDk2MiksICgyNDUyNCksICgx NDkzNiksICgxNzg1OCksICgxNDkzNyksICgyMzA3MSksICgxNDg5NiksICgx Nzg1NiksCigxNDkwNiksICgxNDkxOCksICgxNDk3MSksICgxNzAyMCksICgx NDk3MiksICgxNzAyNSksICgxNzAyNiksICgxNDk3NyksCigxNDk3OCksICgx NDg5NyksICgxNDkwNyksICgxNDkxOSksICgyMDgzMiksICgxNDk1MyksICgx NDk0NyksICgxNDk1NSksCigxNDk1MSksICgxODQ1MiksICgxNDk1NCksICgy MTM3MyksICgxNDk0NSksICgxNDk0OSksICgyMDc3MSksICgyNDU1NiksCigy NDQxOCksICgyNjczOCksICgyMjg1NiksICgyMzU0MiksICgyNDU1NyksICgy NDQxOSksICgyNjQ0MCksICgyMjg1NyksCigxNzg1OSksICgyMzU0MyksICgx NDkyMSksICgxNDk3NiksICgxNDk0NiksICgxNDk1MiksICgxNDk3NCksICgx NDkwOSksCigxNDkyMiksICgxNDk2NiksICgxNDk0MSksICgxNDkwMyksICgy MzE2KSwgKDE0OTM4KSwgKDI1MjApLCAoMTQ5MzQpLAooMTQ5NDIpLCAoMTQ5 MzkpLCAoMTQ5MTApLCAoMTQ5MjQpLCAoMTQ5NjUpLCAoMTQ5NjMpLCAoMjY0 NDMpLCAoMjY0NDEpLAooMjY0NDIpLCAoMTg0NjIpLCAoMTg0NjMpLCAoMTg0 NjQpLCAoMTg0NjUpLCAoMTg0NzApLCAoMTg0NjYpLCAoMTg0NjcpLAooMTg0 NjgpLCAoMTg0NjkpLCAoMTg0NTMpLCAoMTg0NTQpLCAoMTg0NTUpLCAoMTg0 NTYpLCAoMTg0NjEpLCAoMTg0NTcpLAooMTg0NTgpLCAoMTg0NTkpLCAoMTg0 NjApLCAoMTQ4OTgpLCAoMTQ5MTEpLCAoMTQ5MjUpLCAoMTQ5MTIpLCAoMTQ5 MjYpLAooMTQ5MTUpLCAoMTQ5MjkpLCAoMjE0ODcpLCAoMTcwMTgpLCAoMjcx ODQpLCAoMjM3NTMpLCAoMTQ5MTYpLCAoMjE0ODgpLAooMTc4NTcpLCAoMjcx ODUpLCAoMjM3NTQpLCAoMTQ5MzApLCAoMTQ5MDQpLCAoMTQ5MTcpLCAoMjAx ODApLCAoMTQ5MzIpLAooMTQ5MTMpLCAoMTQ5MjcpLCAoMTQ5NzApLCAoMTQ5 NTkpLCAoMTQ5NjApLCAoMTQ5MDIpLCAoMjI4NTUpLCAoMTQ4OTkpLAooMTQ5 NDMpLCAoMTQ5NDQpLCAoMTQ5NjkpLCAoMTQ5NjgpLCAoMTg2NjgpLCAoMTQ5 NTApLCAoMTcxNjApLCAoMTQ5MTQpLAooMTQ5MjgpLCAoMTQ5NDgpLCAoMTQ5 NTYpLCAoMTQ5NTgpLCAoMTg3NTYpLCAoMTQ5NTcpLCAoMTQ5MDApLCAoMTQ5 MDEpLAooMTQ5MDgpLCAoMTQ5MjApLCAoMTQ5NjcpLCAoMTQ4ODkpLCAoMTQ4 OTMpLCAoMjMxMyksICgxNDk0MCksICgyNTkwOCksCigyNTkwOSksICgyNTkx MiksICgxODQ3MyksICgyNTkxMCksICgyNTkxMSksICgxNjg5OCksICgyNTg1 MSksICgxNjg5OSksCigxNjkwNCksICgxNjkwMCksICgxNjkwMSksICgxNjkw MiksICgxNjkwMyksICgyMDc3MiksICgxNzAxOSksICgxNzAyMSksCigxNjkw NSksICgxNjkwNiksICgxNjkwNyksICgxNjkwOCksICgxNjkwOSksICgxNjkx MCksICgxNjkxMSksICgxNzAyMiksCigxNjkxMiksICgxNjkxMyksICgxODQ3 MSksICgxODQ3MiksICgxNjkyMiksICgyMTM3NCksICgxNjkxNyksICgxNjkx NCksCigxNzAyMyksICgxNjkxNSksICgxNjkxNiksICgyMTM3NSksICgxNjkx OCksICgxNjkxOSksICgxNjkyMCksICgxNjkyMSksCigyMDc3MyksICgxNzAy NCksICgyNTg1MiksICgyNTg1MyksICgyNTg1NCksICgyNTg1NSksICgyNTg1 NiksICgyNjczOSksCigyNTg1NyksICgyNTg1OCksICgyNTg1OSksICgyNTg3 NSksICgyNjQ0NCksICgyNTg3OSksICgyNTg2NSksICgyNTg2NCksCigyNTg2 MCksICgyNTg2MSksICgyNTg2MiksICgyNTg2MyksICgyNTg2NiksICgyNTg2 NyksICgyNTg2OCksICgyNTg2OSksCigyNTg3MCksICgyNTg3MSksICgyNTg3 MiksICgyNTg3MyksICgyNTg3NCksICgyNTg3NiksICgyNTg3NyksICgyNTg3 OCksCigyNTg4MCksICgyNTg4MSksICgyNTg4MiksICgyNTg4MyksICgyNTg4 NCksICgyNjc0MCksICgyNTg4NSksICgyNTg4NiksCigyNTg4NyksICgyNTkw MyksICgyNjQ0NSksICgyNTkwNyksICgyNTg5MyksICgyNTg5MiksICgyNTg4 OCksICgyNTg4OSksCigyNTg5MCksICgyNTg5MSksICgyNTg5NCksICgyNTg5 NSksICgyNTg5NiksICgyNTg5NyksICgyNTg5OCksICgyNTg5OSksCigyNTkw MCksICgyNTkwMSksICgyNTkwMiksICgyNTkwNCksICgyNTkwNSksICgyNTkw NiksICgxNDk2MSksICgxNDkzMyksCigxNDkwNSksICgxNDkzMSksICgxNDk3 NSksICgxNDg4OCksICgxNDg5MSksICgxNDg5NCksICgxNDg5NSksICgxNDg5 MiksCigxNDkyMyksICgxNDg4NyksICgxNDg5MCksICgxNDkzNSksICgxODc1 NyksICgxNDk2NCksICgxNDk2MiksICgyNDUyNCksCigxNDkzNiksICgxNzg1 OCksICgxNDkzNyksICgyMzA3MSksICgxNDg5NiksICgxNzg1NiksICgxNDkw NiksICgxNDkxOCksCigxNDg5NyksICgxNDkwNyksICgxNDkxOSksICgyMDgz MiksICgxNDk1MyksICgxNDk0NyksICgxNDk1NSksICgxNDk1MSksCigxODQ1 MiksICgxNDk1NCksICgyMTM3MyksICgxNDk0NSksICgxNDk0OSksICgyMDc3 MSksICgyNDU1NiksICgyNDQxOCksCigyNjczOCksICgyMjg1NiksICgyMzU0 MiksICgyNDU1NyksICgyNDQxOSksICgyNjQ0MCksICgyMjg1NyksICgxNzg1 OSksCigyMzU0MyksICgxNDkyMSksICgxNDk0NiksICgxNDk1MiksICgxNDk3 NCksICgxNDkwOSksICgxNDkyMiksICgxNDk2NiksCigxNDk0MSksICgxNDkw MyksICgyMzE2KSwgKDE0OTM4KSwgKDI1MjApLCAoMTQ5MzQpLCAoMTQ5NDIp LCAoMTQ5MzkpLAooMTQ5MTApLCAoMTQ5MjQpLCAoMTQ5NjUpLCAoMTQ5NjMp LCAoMjY0NDMpLCAoMjY0NDEpLCAoMjY0NDIpLCAoMTg0NjIpLAooMTg0NjMp LCAoMTg0NjQpLCAoMTg0NjUpLCAoMTg0NzApLCAoMTg0NjYpLCAoMTg0Njcp LCAoMTg0NjgpLCAoMTg0NjkpLAooMTg0NTMpLCAoMTg0NTQpLCAoMTg0NTUp LCAoMTg0NTYpLCAoMTg0NjEpLCAoMTg0NTcpLCAoMTg0NTgpLCAoMTg0NTkp LAooMTg0NjApLCAoMTQ4OTgpLCAoMTQ5MTEpLCAoMTQ5MjUpLCAoMTQ5MTIp LCAoMTQ5MjYpLCAoMTQ5MTUpLCAoMTQ5MjkpLAooMjE0ODcpLCAoMTcwMTgp LCAoMjcxODQpLCAoMjM3NTMpLCAoMTQ5MTYpLCAoMjE0ODgpLCAoMTc4NTcp LCAoMjcxODUpLAooMjM3NTQpLCAoMTQ5MzApLCAoMTQ5MDQpLCAoMTQ5MTcp LCAoMjAxODApLCAoMTQ5MzIpLCAoMTQ5MTMpLCAoMTQ5MjcpLAooMTQ5NzAp LCAoMTQ5NTkpLCAoMTQ5NjApLCAoMTQ5MDIpLCAoMjI4NTUpLCAoMTQ4OTkp LCAoMTQ5NDMpLCAoMTQ5NDQpLAooMTQ5NjkpLCAoMTQ5NjgpLCAoMTg2Njgp LCAoMTQ5NTApLCAoMTcxNjApLCAoMTQ5MTQpLCAoMTQ5MjgpLCAoMTQ5NDgp LAooMTQ5NTYpLCAoMTQ5NTgpLCAoMTg3NTYpLCAoMTQ5NTcpLCAoMTQ5MDAp LCAoMTQ5MDEpLCAoMTQ5MDgpLCAoMTQ5MjApLAooMTQ5NjcpLCAoMTQ4ODkp LCAoMTQ4OTMpLCAoMjMxMyksICgxNDk0MCksICgxNDk2MSkpIEFTIHQoaWQp Ow0KDQpTRUxFQ1QgQ09VTlQoRElTVElOQ1QgdGFyZ2V0X2lkKQ0KICBGUk9N IHRlbXBfdGFyZ2V0cyA7DQotLSAyNTQNCg0KU0VMRUNUIENPVU5UKERJU1RJ TkNUIHRlbXBfdmFsdWVzLmlkKQ0KICBGUk9NIHRlbXBfdmFsdWVzDQogV0hF UkUgdGVtcF92YWx1ZXMudGFyZ2V0X2lkIElOICgxNDkzMywgMTQ5MDUsIDE0 OTMxLCAxNDk3NSwgMTQ4ODgsIDE0ODkxLAoxNDg5NCwgMTQ4OTUsIDE0ODky LCAxNDkyMywgMTQ4ODcsIDE0ODkwLCAxNDkzNSwgMTg3NTcsIDE0OTY0LCAx NDk2MiwgMjQ1MjQsCjE0OTM2LCAxNzg1OCwgMTQ5MzcsIDIzMDcxLCAxNDg5 NiwgMTc4NTYsIDE0OTA2LCAxNDkxOCwgMTQ5NzEsIDE3MDIwLCAxNDk3MiwK MTcwMjUsIDE3MDI2LCAxNDk3NywgMTQ5NzgsIDE0ODk3LCAxNDkwNywgMTQ5 MTksIDIwODMyLCAxNDk1MywgMTQ5NDcsIDE0OTU1LAoxNDk1MSwgMTg0NTIs IDE0OTU0LCAyMTM3MywgMTQ5NDUsIDE0OTQ5LCAyMDc3MSwgMjQ1NTYsIDI0 NDE4LCAyNjczOCwgMjI4NTYsCjIzNTQyLCAyNDU1NywgMjQ0MTksIDI2NDQw LCAyMjg1NywgMTc4NTksIDIzNTQzLCAxNDkyMSwgMTQ5NzYsIDE0OTQ2LCAx NDk1MiwKMTQ5NzQsIDE0OTA5LCAxNDkyMiwgMTQ5NjYsIDE0OTQxLCAxNDkw MywgMjMxNiwgMTQ5MzgsIDI1MjAsIDE0OTM0LCAxNDk0MiwKMTQ5MzksIDE0 OTEwLCAxNDkyNCwgMTQ5NjUsIDE0OTYzLCAyNjQ0MywgMjY0NDEsIDI2NDQy LCAxODQ2MiwgMTg0NjMsIDE4NDY0LAoxODQ2NSwgMTg0NzAsIDE4NDY2LCAx ODQ2NywgMTg0NjgsIDE4NDY5LCAxODQ1MywgMTg0NTQsIDE4NDU1LCAxODQ1 NiwgMTg0NjEsCjE4NDU3LCAxODQ1OCwgMTg0NTksIDE4NDYwLCAxNDg5OCwg MTQ5MTEsIDE0OTI1LCAxNDkxMiwgMTQ5MjYsIDE0OTE1LCAxNDkyOSwKMjE0 ODcsIDE3MDE4LCAyNzE4NCwgMjM3NTMsIDE0OTE2LCAyMTQ4OCwgMTc4NTcs IDI3MTg1LCAyMzc1NCwgMTQ5MzAsIDE0OTA0LAoxNDkxNywgMjAxODAsIDE0 OTMyLCAxNDkxMywgMTQ5MjcsIDE0OTcwLCAxNDk1OSwgMTQ5NjAsIDE0OTAy LCAyMjg1NSwgMTQ4OTksCjE0OTQzLCAxNDk0NCwgMTQ5NjksIDE0OTY4LCAx ODY2OCwgMTQ5NTAsIDE3MTYwLCAxNDkxNCwgMTQ5MjgsIDE0OTQ4LCAxNDk1 NiwKMTQ5NTgsIDE4NzU2LCAxNDk1NywgMTQ5MDAsIDE0OTAxLCAxNDkwOCwg MTQ5MjAsIDE0OTY3LCAxNDg4OSwgMTQ4OTMsIDIzMTMsCjE0OTQwLCAyNTkw OCwgMjU5MDksIDI1OTEyLCAxODQ3MywgMjU5MTAsIDI1OTExLCAxNjg5OCwg MjU4NTEsIDE2ODk5LCAxNjkwNCwKMTY5MDAsIDE2OTAxLCAxNjkwMiwgMTY5 MDMsIDIwNzcyLCAxNzAxOSwgMTcwMjEsIDE2OTA1LCAxNjkwNiwgMTY5MDcs IDE2OTA4LAoxNjkwOSwgMTY5MTAsIDE2OTExLCAxNzAyMiwgMTY5MTIsIDE2 OTEzLCAxODQ3MSwgMTg0NzIsIDE2OTIyLCAyMTM3NCwgMTY5MTcsCjE2OTE0 LCAxNzAyMywgMTY5MTUsIDE2OTE2LCAyMTM3NSwgMTY5MTgsIDE2OTE5LCAx NjkyMCwgMTY5MjEsIDIwNzczLCAxNzAyNCwKMjU4NTIsIDI1ODUzLCAyNTg1 NCwgMjU4NTUsIDI1ODU2LCAyNjczOSwgMjU4NTcsIDI1ODU4LCAyNTg1OSwg MjU4NzUsIDI2NDQ0LAoyNTg3OSwgMjU4NjUsIDI1ODY0LCAyNTg2MCwgMjU4 NjEsIDI1ODYyLCAyNTg2MywgMjU4NjYsIDI1ODY3LCAyNTg2OCwgMjU4Njks CjI1ODcwLCAyNTg3MSwgMjU4NzIsIDI1ODczLCAyNTg3NCwgMjU4NzYsIDI1 ODc3LCAyNTg3OCwgMjU4ODAsIDI1ODgxLCAyNTg4MiwKMjU4ODMsIDI1ODg0 LCAyNjc0MCwgMjU4ODUsIDI1ODg2LCAyNTg4NywgMjU5MDMsIDI2NDQ1LCAy NTkwNywgMjU4OTMsIDI1ODkyLAoyNTg4OCwgMjU4ODksIDI1ODkwLCAyNTg5 MSwgMjU4OTQsIDI1ODk1LCAyNTg5NiwgMjU4OTcsIDI1ODk4LCAyNTg5OSwg MjU5MDAsCjI1OTAxLCAyNTkwMiwgMjU5MDQsIDI1OTA1LCAyNTkwNiwgMTQ5 NjEsIDE0OTMzLCAxNDkwNSwgMTQ5MzEsIDE0OTc1LCAxNDg4OCwKMTQ4OTEs IDE0ODk0LCAxNDg5NSwgMTQ4OTIsIDE0OTIzLCAxNDg4NywgMTQ4OTAsIDE0 OTM1LCAxODc1NywgMTQ5NjQsIDE0OTYyLAoyNDUyNCwgMTQ5MzYsIDE3ODU4 LCAxNDkzNywgMjMwNzEsIDE0ODk2LCAxNzg1NiwgMTQ5MDYsIDE0OTE4LCAx NDg5NywgMTQ5MDcsCjE0OTE5LCAyMDgzMiwgMTQ5NTMsIDE0OTQ3LCAxNDk1 NSwgMTQ5NTEsIDE4NDUyLCAxNDk1NCwgMjEzNzMsIDE0OTQ1LCAxNDk0OSwK MjA3NzEsIDI0NTU2LCAyNDQxOCwgMjY3MzgsIDIyODU2LCAyMzU0MiwgMjQ1 NTcsIDI0NDE5LCAyNjQ0MCwgMjI4NTcsIDE3ODU5LAoyMzU0MywgMTQ5MjEs IDE0OTQ2LCAxNDk1MiwgMTQ5NzQsIDE0OTA5LCAxNDkyMiwgMTQ5NjYsIDE0 OTQxLCAxNDkwMywgMjMxNiwKMTQ5MzgsIDI1MjAsIDE0OTM0LCAxNDk0Miwg MTQ5MzksIDE0OTEwLCAxNDkyNCwgMTQ5NjUsIDE0OTYzLCAyNjQ0MywgMjY0 NDEsCjI2NDQyLCAxODQ2MiwgMTg0NjMsIDE4NDY0LCAxODQ2NSwgMTg0NzAs IDE4NDY2LCAxODQ2NywgMTg0NjgsIDE4NDY5LCAxODQ1MywKMTg0NTQsIDE4 NDU1LCAxODQ1NiwgMTg0NjEsIDE4NDU3LCAxODQ1OCwgMTg0NTksIDE4NDYw LCAxNDg5OCwgMTQ5MTEsIDE0OTI1LAoxNDkxMiwgMTQ5MjYsIDE0OTE1LCAx NDkyOSwgMjE0ODcsIDE3MDE4LCAyNzE4NCwgMjM3NTMsIDE0OTE2LCAyMTQ4 OCwgMTc4NTcsCjI3MTg1LCAyMzc1NCwgMTQ5MzAsIDE0OTA0LCAxNDkxNywg MjAxODAsIDE0OTMyLCAxNDkxMywgMTQ5MjcsIDE0OTcwLCAxNDk1OSwKMTQ5 NjAsIDE0OTAyLCAyMjg1NSwgMTQ4OTksIDE0OTQzLCAxNDk0NCwgMTQ5Njks IDE0OTY4LCAxODY2OCwgMTQ5NTAsIDE3MTYwLAoxNDkxNCwgMTQ5MjgsIDE0 OTQ4LCAxNDk1NiwgMTQ5NTgsIDE4NzU2LCAxNDk1NywgMTQ5MDAsIDE0OTAx LCAxNDkwOCwgMTQ5MjAsCjE0OTY3LCAxNDg4OSwgMTQ4OTMsIDIzMTMsIDE0 OTQwLCAxNDk2MSk7DQotLSAyNTQwMA0KDQpTRUxFQ1QgQ09VTlQoRElTVElO Q1QgdGVtcF92YWx1ZXMuaWQpDQogIEZST00gdGVtcF92YWx1ZXMNCiAgSk9J TiB0ZW1wX3RhcmdldHMgVVNJTkcgKHRhcmdldF9pZCk7DQotLSAyNTQwMA0K DQpTRUxFQ1QgQ09VTlQoRElTVElOQ1QgdGVtcF92YWx1ZXMuaWQpDQogIEZS T00gdGVtcF92YWx1ZXMNCiAgSk9JTiB0ZW1wX3RhcmdldHMgVVNJTkcgKHRh cmdldF9pZCkNCiBXSEVSRSB0ZW1wX3ZhbHVlcy50YXJnZXRfaWQgSU4gKDE0 OTMzLCAxNDkwNSwgMTQ5MzEsIDE0OTc1LCAxNDg4OCwgMTQ4OTEsCjE0ODk0 LCAxNDg5NSwgMTQ4OTIsIDE0OTIzLCAxNDg4NywgMTQ4OTAsIDE0OTM1LCAx ODc1NywgMTQ5NjQsIDE0OTYyLCAyNDUyNCwKMTQ5MzYsIDE3ODU4LCAxNDkz NywgMjMwNzEsIDE0ODk2LCAxNzg1NiwgMTQ5MDYsIDE0OTE4LCAxNDk3MSwg MTcwMjAsIDE0OTcyLAoxNzAyNSwgMTcwMjYsIDE0OTc3LCAxNDk3OCwgMTQ4 OTcsIDE0OTA3LCAxNDkxOSwgMjA4MzIsIDE0OTUzLCAxNDk0NywgMTQ5NTUs CjE0OTUxLCAxODQ1MiwgMTQ5NTQsIDIxMzczLCAxNDk0NSwgMTQ5NDksIDIw NzcxLCAyNDU1NiwgMjQ0MTgsIDI2NzM4LCAyMjg1NiwKMjM1NDIsIDI0NTU3 LCAyNDQxOSwgMjY0NDAsIDIyODU3LCAxNzg1OSwgMjM1NDMsIDE0OTIxLCAx NDk3NiwgMTQ5NDYsIDE0OTUyLAoxNDk3NCwgMTQ5MDksIDE0OTIyLCAxNDk2 NiwgMTQ5NDEsIDE0OTAzLCAyMzE2LCAxNDkzOCwgMjUyMCwgMTQ5MzQsIDE0 OTQyLAoxNDkzOSwgMTQ5MTAsIDE0OTI0LCAxNDk2NSwgMTQ5NjMsIDI2NDQz LCAyNjQ0MSwgMjY0NDIsIDE4NDYyLCAxODQ2MywgMTg0NjQsCjE4NDY1LCAx ODQ3MCwgMTg0NjYsIDE4NDY3LCAxODQ2OCwgMTg0NjksIDE4NDUzLCAxODQ1 NCwgMTg0NTUsIDE4NDU2LCAxODQ2MSwKMTg0NTcsIDE4NDU4LCAxODQ1OSwg MTg0NjAsIDE0ODk4LCAxNDkxMSwgMTQ5MjUsIDE0OTEyLCAxNDkyNiwgMTQ5 MTUsIDE0OTI5LAoyMTQ4NywgMTcwMTgsIDI3MTg0LCAyMzc1MywgMTQ5MTYs IDIxNDg4LCAxNzg1NywgMjcxODUsIDIzNzU0LCAxNDkzMCwgMTQ5MDQsCjE0 OTE3LCAyMDE4MCwgMTQ5MzIsIDE0OTEzLCAxNDkyNywgMTQ5NzAsIDE0OTU5 LCAxNDk2MCwgMTQ5MDIsIDIyODU1LCAxNDg5OSwKMTQ5NDMsIDE0OTQ0LCAx NDk2OSwgMTQ5NjgsIDE4NjY4LCAxNDk1MCwgMTcxNjAsIDE0OTE0LCAxNDky OCwgMTQ5NDgsIDE0OTU2LAoxNDk1OCwgMTg3NTYsIDE0OTU3LCAxNDkwMCwg MTQ5MDEsIDE0OTA4LCAxNDkyMCwgMTQ5NjcsIDE0ODg5LCAxNDg5MywgMjMx MywKMTQ5NDAsIDI1OTA4LCAyNTkwOSwgMjU5MTIsIDE4NDczLCAyNTkxMCwg MjU5MTEsIDE2ODk4LCAyNTg1MSwgMTY4OTksIDE2OTA0LAoxNjkwMCwgMTY5 MDEsIDE2OTAyLCAxNjkwMywgMjA3NzIsIDE3MDE5LCAxNzAyMSwgMTY5MDUs IDE2OTA2LCAxNjkwNywgMTY5MDgsCjE2OTA5LCAxNjkxMCwgMTY5MTEsIDE3 MDIyLCAxNjkxMiwgMTY5MTMsIDE4NDcxLCAxODQ3MiwgMTY5MjIsIDIxMzc0 LCAxNjkxNywKMTY5MTQsIDE3MDIzLCAxNjkxNSwgMTY5MTYsIDIxMzc1LCAx NjkxOCwgMTY5MTksIDE2OTIwLCAxNjkyMSwgMjA3NzMsIDE3MDI0LAoyNTg1 MiwgMjU4NTMsIDI1ODU0LCAyNTg1NSwgMjU4NTYsIDI2NzM5LCAyNTg1Nywg MjU4NTgsIDI1ODU5LCAyNTg3NSwgMjY0NDQsCjI1ODc5LCAyNTg2NSwgMjU4 NjQsIDI1ODYwLCAyNTg2MSwgMjU4NjIsIDI1ODYzLCAyNTg2NiwgMjU4Njcs IDI1ODY4LCAyNTg2OSwKMjU4NzAsIDI1ODcxLCAyNTg3MiwgMjU4NzMsIDI1 ODc0LCAyNTg3NiwgMjU4NzcsIDI1ODc4LCAyNTg4MCwgMjU4ODEsIDI1ODgy LAoyNTg4MywgMjU4ODQsIDI2NzQwLCAyNTg4NSwgMjU4ODYsIDI1ODg3LCAy NTkwMywgMjY0NDUsIDI1OTA3LCAyNTg5MywgMjU4OTIsCjI1ODg4LCAyNTg4 OSwgMjU4OTAsIDI1ODkxLCAyNTg5NCwgMjU4OTUsIDI1ODk2LCAyNTg5Nywg MjU4OTgsIDI1ODk5LCAyNTkwMCwKMjU5MDEsIDI1OTAyLCAyNTkwNCwgMjU5 MDUsIDI1OTA2LCAxNDk2MSwgMTQ5MzMsIDE0OTA1LCAxNDkzMSwgMTQ5NzUs IDE0ODg4LAoxNDg5MSwgMTQ4OTQsIDE0ODk1LCAxNDg5MiwgMTQ5MjMsIDE0 ODg3LCAxNDg5MCwgMTQ5MzUsIDE4NzU3LCAxNDk2NCwgMTQ5NjIsCjI0NTI0 LCAxNDkzNiwgMTc4NTgsIDE0OTM3LCAyMzA3MSwgMTQ4OTYsIDE3ODU2LCAx NDkwNiwgMTQ5MTgsIDE0ODk3LCAxNDkwNywKMTQ5MTksIDIwODMyLCAxNDk1 MywgMTQ5NDcsIDE0OTU1LCAxNDk1MSwgMTg0NTIsIDE0OTU0LCAyMTM3Mywg MTQ5NDUsIDE0OTQ5LAoyMDc3MSwgMjQ1NTYsIDI0NDE4LCAyNjczOCwgMjI4 NTYsIDIzNTQyLCAyNDU1NywgMjQ0MTksIDI2NDQwLCAyMjg1NywgMTc4NTks CjIzNTQzLCAxNDkyMSwgMTQ5NDYsIDE0OTUyLCAxNDk3NCwgMTQ5MDksIDE0 OTIyLCAxNDk2NiwgMTQ5NDEsIDE0OTAzLCAyMzE2LAoxNDkzOCwgMjUyMCwg MTQ5MzQsIDE0OTQyLCAxNDkzOSwgMTQ5MTAsIDE0OTI0LCAxNDk2NSwgMTQ5 NjMsIDI2NDQzLCAyNjQ0MSwKMjY0NDIsIDE4NDYyLCAxODQ2MywgMTg0NjQs IDE4NDY1LCAxODQ3MCwgMTg0NjYsIDE4NDY3LCAxODQ2OCwgMTg0NjksIDE4 NDUzLAoxODQ1NCwgMTg0NTUsIDE4NDU2LCAxODQ2MSwgMTg0NTcsIDE4NDU4 LCAxODQ1OSwgMTg0NjAsIDE0ODk4LCAxNDkxMSwgMTQ5MjUsCjE0OTEyLCAx NDkyNiwgMTQ5MTUsIDE0OTI5LCAyMTQ4NywgMTcwMTgsIDI3MTg0LCAyMzc1 MywgMTQ5MTYsIDIxNDg4LCAxNzg1NywKMjcxODUsIDIzNzU0LCAxNDkzMCwg MTQ5MDQsIDE0OTE3LCAyMDE4MCwgMTQ5MzIsIDE0OTEzLCAxNDkyNywgMTQ5 NzAsIDE0OTU5LAoxNDk2MCwgMTQ5MDIsIDIyODU1LCAxNDg5OSwgMTQ5NDMs IDE0OTQ0LCAxNDk2OSwgMTQ5NjgsIDE4NjY4LCAxNDk1MCwgMTcxNjAsCjE0 OTE0LCAxNDkyOCwgMTQ5NDgsIDE0OTU2LCAxNDk1OCwgMTg3NTYsIDE0OTU3 LCAxNDkwMCwgMTQ5MDEsIDE0OTA4LCAxNDkyMCwKMTQ5NjcsIDE0ODg5LCAx NDg5MywgMjMxMywgMTQ5NDAsIDE0OTYxKTsNCi0tIEVYUEVDVCAyNTQwMCwg YnV0IFJFU1VMVCAyNTMwMCBvbiA5LjUgYW5kIDkuNg0KDQpzZXQgZW5hYmxl X21lcmdlam9pbiB0byBvZmY7DQoNClNFTEVDVCBDT1VOVChESVNUSU5DVCB0 ZW1wX3ZhbHVlcy5pZCkNCiAgRlJPTSB0ZW1wX3ZhbHVlcw0KICBKT0lOIHRl bXBfdGFyZ2V0cyBVU0lORyAodGFyZ2V0X2lkKQ0KIFdIRVJFIHRlbXBfdmFs dWVzLnRhcmdldF9pZCBJTiAoMTQ5MzMsIDE0OTA1LCAxNDkzMSwgMTQ5NzUs IDE0ODg4LCAxNDg5MSwKMTQ4OTQsIDE0ODk1LCAxNDg5MiwgMTQ5MjMsIDE0 ODg3LCAxNDg5MCwgMTQ5MzUsIDE4NzU3LCAxNDk2NCwgMTQ5NjIsIDI0NTI0 LAoxNDkzNiwgMTc4NTgsIDE0OTM3LCAyMzA3MSwgMTQ4OTYsIDE3ODU2LCAx NDkwNiwgMTQ5MTgsIDE0OTcxLCAxNzAyMCwgMTQ5NzIsCjE3MDI1LCAxNzAy NiwgMTQ5NzcsIDE0OTc4LCAxNDg5NywgMTQ5MDcsIDE0OTE5LCAyMDgzMiwg MTQ5NTMsIDE0OTQ3LCAxNDk1NSwKMTQ5NTEsIDE4NDUyLCAxNDk1NCwgMjEz NzMsIDE0OTQ1LCAxNDk0OSwgMjA3NzEsIDI0NTU2LCAyNDQxOCwgMjY3Mzgs IDIyODU2LAoyMzU0MiwgMjQ1NTcsIDI0NDE5LCAyNjQ0MCwgMjI4NTcsIDE3 ODU5LCAyMzU0MywgMTQ5MjEsIDE0OTc2LCAxNDk0NiwgMTQ5NTIsCjE0OTc0 LCAxNDkwOSwgMTQ5MjIsIDE0OTY2LCAxNDk0MSwgMTQ5MDMsIDIzMTYsIDE0 OTM4LCAyNTIwLCAxNDkzNCwgMTQ5NDIsCjE0OTM5LCAxNDkxMCwgMTQ5MjQs IDE0OTY1LCAxNDk2MywgMjY0NDMsIDI2NDQxLCAyNjQ0MiwgMTg0NjIsIDE4 NDYzLCAxODQ2NCwKMTg0NjUsIDE4NDcwLCAxODQ2NiwgMTg0NjcsIDE4NDY4 LCAxODQ2OSwgMTg0NTMsIDE4NDU0LCAxODQ1NSwgMTg0NTYsIDE4NDYxLAox ODQ1NywgMTg0NTgsIDE4NDU5LCAxODQ2MCwgMTQ4OTgsIDE0OTExLCAxNDky NSwgMTQ5MTIsIDE0OTI2LCAxNDkxNSwgMTQ5MjksCjIxNDg3LCAxNzAxOCwg MjcxODQsIDIzNzUzLCAxNDkxNiwgMjE0ODgsIDE3ODU3LCAyNzE4NSwgMjM3 NTQsIDE0OTMwLCAxNDkwNCwKMTQ5MTcsIDIwMTgwLCAxNDkzMiwgMTQ5MTMs IDE0OTI3LCAxNDk3MCwgMTQ5NTksIDE0OTYwLCAxNDkwMiwgMjI4NTUsIDE0 ODk5LAoxNDk0MywgMTQ5NDQsIDE0OTY5LCAxNDk2OCwgMTg2NjgsIDE0OTUw LCAxNzE2MCwgMTQ5MTQsIDE0OTI4LCAxNDk0OCwgMTQ5NTYsCjE0OTU4LCAx ODc1NiwgMTQ5NTcsIDE0OTAwLCAxNDkwMSwgMTQ5MDgsIDE0OTIwLCAxNDk2 NywgMTQ4ODksIDE0ODkzLCAyMzEzLAoxNDk0MCwgMjU5MDgsIDI1OTA5LCAy NTkxMiwgMTg0NzMsIDI1OTEwLCAyNTkxMSwgMTY4OTgsIDI1ODUxLCAxNjg5 OSwgMTY5MDQsCjE2OTAwLCAxNjkwMSwgMTY5MDIsIDE2OTAzLCAyMDc3Miwg MTcwMTksIDE3MDIxLCAxNjkwNSwgMTY5MDYsIDE2OTA3LCAxNjkwOCwKMTY5 MDksIDE2OTEwLCAxNjkxMSwgMTcwMjIsIDE2OTEyLCAxNjkxMywgMTg0NzEs IDE4NDcyLCAxNjkyMiwgMjEzNzQsIDE2OTE3LAoxNjkxNCwgMTcwMjMsIDE2 OTE1LCAxNjkxNiwgMjEzNzUsIDE2OTE4LCAxNjkxOSwgMTY5MjAsIDE2OTIx LCAyMDc3MywgMTcwMjQsCjI1ODUyLCAyNTg1MywgMjU4NTQsIDI1ODU1LCAy NTg1NiwgMjY3MzksIDI1ODU3LCAyNTg1OCwgMjU4NTksIDI1ODc1LCAyNjQ0 NCwKMjU4NzksIDI1ODY1LCAyNTg2NCwgMjU4NjAsIDI1ODYxLCAyNTg2Miwg MjU4NjMsIDI1ODY2LCAyNTg2NywgMjU4NjgsIDI1ODY5LAoyNTg3MCwgMjU4 NzEsIDI1ODcyLCAyNTg3MywgMjU4NzQsIDI1ODc2LCAyNTg3NywgMjU4Nzgs IDI1ODgwLCAyNTg4MSwgMjU4ODIsCjI1ODgzLCAyNTg4NCwgMjY3NDAsIDI1 ODg1LCAyNTg4NiwgMjU4ODcsIDI1OTAzLCAyNjQ0NSwgMjU5MDcsIDI1ODkz LCAyNTg5MiwKMjU4ODgsIDI1ODg5LCAyNTg5MCwgMjU4OTEsIDI1ODk0LCAy NTg5NSwgMjU4OTYsIDI1ODk3LCAyNTg5OCwgMjU4OTksIDI1OTAwLAoyNTkw MSwgMjU5MDIsIDI1OTA0LCAyNTkwNSwgMjU5MDYsIDE0OTYxLCAxNDkzMywg MTQ5MDUsIDE0OTMxLCAxNDk3NSwgMTQ4ODgsCjE0ODkxLCAxNDg5NCwgMTQ4 OTUsIDE0ODkyLCAxNDkyMywgMTQ4ODcsIDE0ODkwLCAxNDkzNSwgMTg3NTcs IDE0OTY0LCAxNDk2MiwKMjQ1MjQsIDE0OTM2LCAxNzg1OCwgMTQ5MzcsIDIz MDcxLCAxNDg5NiwgMTc4NTYsIDE0OTA2LCAxNDkxOCwgMTQ4OTcsIDE0OTA3 LAoxNDkxOSwgMjA4MzIsIDE0OTUzLCAxNDk0NywgMTQ5NTUsIDE0OTUxLCAx ODQ1MiwgMTQ5NTQsIDIxMzczLCAxNDk0NSwgMTQ5NDksCjIwNzcxLCAyNDU1 NiwgMjQ0MTgsIDI2NzM4LCAyMjg1NiwgMjM1NDIsIDI0NTU3LCAyNDQxOSwg MjY0NDAsIDIyODU3LCAxNzg1OSwKMjM1NDMsIDE0OTIxLCAxNDk0NiwgMTQ5 NTIsIDE0OTc0LCAxNDkwOSwgMTQ5MjIsIDE0OTY2LCAxNDk0MSwgMTQ5MDMs IDIzMTYsCjE0OTM4LCAyNTIwLCAxNDkzNCwgMTQ5NDIsIDE0OTM5LCAxNDkx MCwgMTQ5MjQsIDE0OTY1LCAxNDk2MywgMjY0NDMsIDI2NDQxLAoyNjQ0Miwg MTg0NjIsIDE4NDYzLCAxODQ2NCwgMTg0NjUsIDE4NDcwLCAxODQ2NiwgMTg0 NjcsIDE4NDY4LCAxODQ2OSwgMTg0NTMsCjE4NDU0LCAxODQ1NSwgMTg0NTYs IDE4NDYxLCAxODQ1NywgMTg0NTgsIDE4NDU5LCAxODQ2MCwgMTQ4OTgsIDE0 OTExLCAxNDkyNSwKMTQ5MTIsIDE0OTI2LCAxNDkxNSwgMTQ5MjksIDIxNDg3 LCAxNzAxOCwgMjcxODQsIDIzNzUzLCAxNDkxNiwgMjE0ODgsIDE3ODU3LAoy NzE4NSwgMjM3NTQsIDE0OTMwLCAxNDkwNCwgMTQ5MTcsIDIwMTgwLCAxNDkz MiwgMTQ5MTMsIDE0OTI3LCAxNDk3MCwgMTQ5NTksCjE0OTYwLCAxNDkwMiwg MjI4NTUsIDE0ODk5LCAxNDk0MywgMTQ5NDQsIDE0OTY5LCAxNDk2OCwgMTg2 NjgsIDE0OTUwLCAxNzE2MCwKMTQ5MTQsIDE0OTI4LCAxNDk0OCwgMTQ5NTYs IDE0OTU4LCAxODc1NiwgMTQ5NTcsIDE0OTAwLCAxNDkwMSwgMTQ5MDgsIDE0 OTIwLAoxNDk2NywgMTQ4ODksIDE0ODkzLCAyMzEzLCAxNDk0MCwgMTQ5NjEp Ow0KLS0gMjU0MDANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KLS0t LSA5LjQuOCByZXN1bHQgLS0tLS0tLQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICB2ZXJzaW9uDQoNCi0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogUG9z dGdyZVNRTCA5LjQuOCBvbiB4ODZfNjQtdW5rbm93bi1saW51eC1nbnUsIGNv bXBpbGVkIGJ5IGdjYyAoRGViaWFuCjQuOS4yLTEwKQ0KIDQuOS4yLCA2NC1i aXQNCigxIHJvdykNCg0KQ1JFQVRFIFRBQkxFDQpDUkVBVEUgSU5ERVgNCklO U0VSVCAwIDMwMDAwMDANClZBQ1VVTQ0KQ1JFQVRFIFRBQkxFDQpJTlNFUlQg MCAzOTcNCiBjb3VudA0KLS0tLS0tLQ0KICAgMjU0DQooMSByb3cpDQoNCiBj b3VudA0KLS0tLS0tLQ0KIDI1NDAwDQooMSByb3cpDQoNCiBjb3VudA0KLS0t LS0tLQ0KIDI1NDAwDQooMSByb3cpDQoNCiBjb3VudA0KLS0tLS0tLQ0KIDI1 NDAwDQooMSByb3cpDQoNClNFVA0KIGNvdW50DQotLS0tLS0tDQogMjU0MDAN CigxIHJvdykNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KLS0tLS0t LTkuNS4zIHJlc3VsdC0tLS0tLQ0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIHZlcnNpb24NCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFBvc3RncmVTUUwg OS42YmV0YTEgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkg Z2NjIChEZWJpYW4KNC45LjItMTApIDQuOS4yLCA2NC1iaXQNCigxIHJvdykN Cg0KQ1JFQVRFIFRBQkxFDQpDUkVBVEUgSU5ERVgNCklOU0VSVCAwIDMwMDAw MDANClZBQ1VVTQ0KQ1JFQVRFIFRBQkxFDQpJTlNFUlQgMCAzOTcNCiBjb3Vu dA0KLS0tLS0tLQ0KICAgMjU0DQooMSByb3cpDQoNCiBjb3VudA0KLS0tLS0t LQ0KIDI1NDAwDQooMSByb3cpDQoNCiBjb3VudA0KLS0tLS0tLQ0KIDI1NDAw DQooMSByb3cpDQoNCiBjb3VudA0KLS0tLS0tLQ0KIDI1MzAwDQooMSByb3cp DQoNClNFVA0KIGNvdW50DQotLS0tLS0tDQogMjU0MDANCigxIHJvdykNCi0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KLS0tLTkuNi1iZXRhMSByZXN1 bHQtLS0tLQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIHZlcnNpb24NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFBvc3RncmVTUUwgOS42YmV0YTEgb24g eDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChEZWJpYW4K NC45LjItMTApIDQuOS4yLCA2NC1iaXQNCigxIHJvdykNCg0KQ1JFQVRFIFRB QkxFDQpDUkVBVEUgSU5ERVgNCklOU0VSVCAwIDMwMDAwMDANClZBQ1VVTQ0K Q1JFQVRFIFRBQkxFDQpJTlNFUlQgMCAzOTcNCiBjb3VudA0KLS0tLS0tLQ0K ICAgMjU0DQooMSByb3cpDQoNCiBjb3VudA0KLS0tLS0tLQ0KIDI1NDAwDQoo MSByb3cpDQoNCiBjb3VudA0KLS0tLS0tLQ0KIDI1NDAwDQooMSByb3cpDQoN CiBjb3VudA0KLS0tLS0tLQ0KIDI1MzAwDQooMSByb3cpDQoNClNFVA0KIGNv dW50DQotLS0tLS0tDQogMjU0MDANCigxIHJvdykNCi0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0NCg0KSSBidWlsdCBQb3N0Z3JlU1FMIDkuNS4zIHdpdGgg YC0tZW5hYmxlLWNhc3NlcnRgIG9wdGlvbi4NClRoYXQgaXMgRmFpbGVkQXNz ZXJ0aW9uIGxvZy4NCg0KLS0tLS0tLWNhc3NlcnQgbG9nLS0tLS0tLQ0KTE9H OiAgZGF0YWJhc2Ugc3lzdGVtIHdhcyBzaHV0IGRvd24gYXQgMjAxNi0wNi0w MSAwNjowOTo1OCBVVEMNCkxPRzogIE11bHRpWGFjdCBtZW1iZXIgd3JhcGFy b3VuZCBwcm90ZWN0aW9ucyBhcmUgbm93IGVuYWJsZWQNCkxPRzogIGRhdGFi YXNlIHN5c3RlbSBpcyByZWFkeSB0byBhY2NlcHQgY29ubmVjdGlvbnMNCkxP RzogIGF1dG92YWN1dW0gbGF1bmNoZXIgc3RhcnRlZA0KVFJBUDogRmFpbGVk QXNzZXJ0aW9uKCIhKGNvbXBhcmVSZXN1bHQgPCAwKSIsIEZpbGU6ICJub2Rl TWVyZ2Vqb2luLmMiLCBMaW5lOgo5NDIpDQpMT0c6ICBzZXJ2ZXIgcHJvY2Vz cyAoUElEIDI4KSB3YXMgdGVybWluYXRlZCBieSBzaWduYWwgNjogQWJvcnRl ZA0KREVUQUlMOiAgRmFpbGVkIHByb2Nlc3Mgd2FzIHJ1bm5pbmc6IFNFTEVD VCBDT1VOVChESVNUSU5DVCB0ZW1wX3ZhbHVlcy5pZCkNCgkgIEZST00gdGVt cF92YWx1ZXMNCgkgIEpPSU4gdGVtcF90YXJnZXRzIFVTSU5HICh0YXJnZXRf aWQpDQoJIFdIRVJFIHRlbXBfdmFsdWVzLnRhcmdldF9pZCBJTiAoMTQ5MzMs IDE0OTA1LCAxNDkzMSwgMTQ5NzUsIDE0ODg4LCAxNDg5MSwKMTQ4OTQsIDE0 ODk1LCAxNDg5MiwgMTQ5MjMsIDE0ODg3LCAxNDg5MCwgMTQ5MzUsIDE4NzU3 LCAxNDk2NCwgMTQ5NjIsIDI0NTI0LAoxNDkzNiwgMTc4NTgsIDE0OTM3LCAy MzA3MSwgMTQ4OTYsIDE3ODU2LCAxNDkwNiwgMTQ5MTgsIDE0OTcxLCAxNzAy MCwgMTQ5NzIsCjE3MDI1LCAxNzAyNiwgMTQ5NzcsIDE0OTc4LCAxNDg5Nywg MTQ5MDcsIDE0OTE5LCAyMDgzMiwgMTQ5NTMsIDE0OTQ3LCAxNDk1NSwKMTQ5 NTEsIDE4NDUyLCAxNDk1NCwgMjEzNzMsIDE0OTQ1LCAxNDk0OSwgMjA3NzEs IDI0NTU2LCAyNDQxOCwgMjY3MzgsIDIyODU2LAoyMzU0MiwgMjQ1NTcsIDI0 NDE5LCAyNjQ0MCwgMjI4NTcsIDE3ODU5LCAyMzU0MywgMTQ5MjEsIDE0OTc2 LCAxNDk0NiwgMTQ5NTIsCjE0OTc0LCAxNDkwOSwgMTQ5MjIsIDE0OTY2LCAx NDk0MSwgMTQ5MDMsIDIzMTYsIDE0OTM4LCAyNTIwLCAxNDkzNCwgMTQ5NDIs CjE0OTM5LCAxNDkxMCwgMTQ5MjQsIDE0OTY1LCAxNDk2MywgMjY0NDMsIDI2 NDQxLCAyNjQ0MiwgMTg0NjIsIDE4NDYzLCAxODQ2NCwKMTg0NjUsIDE4NDcw LCAxODQ2NiwgMTg0NjcsIDE4NDY4LCAxODQ2OSwgMTg0NTMsIDE4NDU0LCAx ODQ1NSwgMTg0NTYsIDE4NDYxLAoxODQ1NywgMTg0NTgsIDE4NDU5LCAxODQ2 MCwgMTQ4OTgsIDE0OTExLCAxNDkyNSwgMTQ5MTIsIDE0OTI2LCAxNDkxNSwg MTQ5MjksCjIxNDg3LCAxNzAxOCwgMjcxODQsIDIzNzUzLCAxNDkxNiwgMjE0 ODgsIDE3ODU3LCAyNzE4NSwgMjM3NTQsIDE0OTMwLCAxNDkwNCwKMTQ5MTcs IDIwMTgwLCAxNDkzMiwgMTQ5MTMsIDE0OTI3LCAxNDk3MCwgMTQ5NTksIDE0 OTYwLCAxNDkwMiwgMjI4NTUsIDE0ODk5LAoxNDk0MywgMQ0KTE9HOiAgdGVy bWluYXRpbmcgYW55IG90aGVyIGFjdGl2ZSBzZXJ2ZXIgcHJvY2Vzc2VzDQpX QVJOSU5HOiAgdGVybWluYXRpbmcgY29ubmVjdGlvbiBiZWNhdXNlIG9mIGNy YXNoIG9mIGFub3RoZXIgc2VydmVyCnByb2Nlc3MNCkRFVEFJTDogIFRoZSBw b3N0bWFzdGVyIGhhcyBjb21tYW5kZWQgdGhpcyBzZXJ2ZXIgcHJvY2VzcyB0 byByb2xsIGJhY2sgdGhlCmN1cnJlbnQgdHJhbnNhY3Rpb24gYW5kIGV4aXQs IGJlY2F1c2UgYW5vdGhlciBzZXJ2ZXIgcHJvY2VzcyBleGl0ZWQKYWJub3Jt YWxseSBhbmQgcG9zc2libHkgY29ycnVwdGVkIHNoYXJlZCBtZW1vcnkuDQpI SU5UOiAgSW4gYSBtb21lbnQgeW91IHNob3VsZCBiZSBhYmxlIHRvIHJlY29u bmVjdCB0byB0aGUgZGF0YWJhc2UgYW5kCnJlcGVhdCB5b3VyIGNvbW1hbmQu DQpMT0c6ICBhbGwgc2VydmVyIHByb2Nlc3NlcyB0ZXJtaW5hdGVkOyByZWlu aXRpYWxpemluZw0KTE9HOiAgZGF0YWJhc2Ugc3lzdGVtIHdhcyBpbnRlcnJ1 cHRlZDsgbGFzdCBrbm93biB1cCBhdCAyMDE2LTA2LTAxIDA2OjQ0OjExClVU Qw0KTE9HOiAgZGF0YWJhc2Ugc3lzdGVtIHdhcyBub3QgcHJvcGVybHkgc2h1 dCBkb3duOyBhdXRvbWF0aWMgcmVjb3ZlcnkgaW4KcHJvZ3Jlc3MNCkxPRzog IHJlZG8gc3RhcnRzIGF0IDAvMTcwNzA2OA0KTE9HOiAgaW52YWxpZCByZWNv cmQgbGVuZ3RoIGF0IDAvMTcyQ0VEMA0KTE9HOiAgcmVkbyBkb25lIGF0IDAv MTcyQ0VBOA0KTE9HOiAgbGFzdCBjb21wbGV0ZWQgdHJhbnNhY3Rpb24gd2Fz IGF0IGxvZyB0aW1lIDIwMTYtMDYtMDEKMDY6NDU6MDQuOTc4NzgyKzAwDQpM T0c6ICBNdWx0aVhhY3QgbWVtYmVyIHdyYXBhcm91bmQgcHJvdGVjdGlvbnMg YXJlIG5vdyBlbmFibGVkDQpMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gaXMgcmVh ZHkgdG8gYWNjZXB0IGNvbm5lY3Rpb25zDQpMT0c6ICBhdXRvdmFjdXVtIGxh dW5jaGVyIHN0YXJ0ZWQNCi0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KSXMgdGhp cyBpbnRlbnRpb25hbD8NCgoK
On Wed, Jun 1, 2016 at 2:59 AM, <yancya@upec.jp> wrote: > The following bug has been logged on the website: > > Bug reference: 14169 > Logged by: Shinta Koyanagi > Email address: yancya@upec.jp > PostgreSQL version: 9.5.3 > Operating system: Debian GNU/Linux 8 (jessie) > Description: > > -------9.5.3 result------ > version > > -------------------------------------------------------------------------= -------------------- > PostgreSQL 9.6beta1 on x86_64-pc-linux-gnu, compiled by gcc (Debian > 4.9.2-10) 4.9.2, 64-bit > (1 row) > =E2=80=8BYour 9.5.3 result shows a version string for 9.6beta1. I'm inclin= ed to believe this is indeed a 9.5 introduced bug - I'll let the -hackers fix confirm and fix. David J. =E2=80=8B
yancya@upec.jp writes:
> TRAP: FailedAssertion("!(compareResult < 0)", File: "nodeMergejoin.c", Line:
> 942)
This is not a mergejoin logic bug, because nodeMergejoin.c didn't change
significantly between 9.4 and 9.5. It must be that the input data is not
being delivered in the expected order. I first thought that Peter G's
sorting optimizations must be at fault, but if you run either of the
mergejoin's subplans in isolation, you get correctly sorted data. What
must be happening, then, is that mergejoin's mark/restore operations are
confusing the btree indexscan and causing it to deliver the wrong tuple(s)
after a restore.
Armed with that conclusion about where the bug probably is, I looked
through the git history, and soon found that the crash goes away if
I manually revert commit 2ed5b87f96d473962ec5230fd820abfeaccb2069.
In short: Kevin, you broke mark/restore. Please fix.
regards, tom lane
On Wed, Jun 1, 2016 at 11:10 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> yancya@upec.jp writes:
>> TRAP: FailedAssertion("!(compareResult < 0)", File: "nodeMergejoin.c", Line: 942)
>
> This is not a mergejoin logic bug, because nodeMergejoin.c didn't change
> significantly between 9.4 and 9.5. It must be that the input data is not
> being delivered in the expected order. I first thought that Peter G's
> sorting optimizations must be at fault, but if you run either of the
> mergejoin's subplans in isolation, you get correctly sorted data. What
> must be happening, then, is that mergejoin's mark/restore operations are
> confusing the btree indexscan and causing it to deliver the wrong tuple(s)
> after a restore.
>
> Armed with that conclusion about where the bug probably is, I looked
> through the git history, and soon found that the crash goes away if
> I manually revert commit 2ed5b87f96d473962ec5230fd820abfeaccb2069.
>
> In short: Kevin, you broke mark/restore. Please fix.
I'm on it.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jun 1, 2016 at 11:15 AM, Kevin Grittner <kgrittn@gmail.com> wrote:
> On Wed, Jun 1, 2016 at 11:10 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> yancya@upec.jp writes:
>>> TRAP: FailedAssertion("!(compareResult < 0)", File: "nodeMergejoin.c", Line: 942)
>>
>> This is not a mergejoin logic bug, because nodeMergejoin.c didn't change
>> significantly between 9.4 and 9.5. It must be that the input data is not
>> being delivered in the expected order. I first thought that Peter G's
>> sorting optimizations must be at fault, but if you run either of the
>> mergejoin's subplans in isolation, you get correctly sorted data. What
>> must be happening, then, is that mergejoin's mark/restore operations are
>> confusing the btree indexscan and causing it to deliver the wrong tuple(s)
>> after a restore.
>>
>> Armed with that conclusion about where the bug probably is, I looked
>> through the git history, and soon found that the crash goes away if
>> I manually revert commit 2ed5b87f96d473962ec5230fd820abfeaccb2069.
>>
>> In short: Kevin, you broke mark/restore. Please fix.
>
> I'm on it.
Fix pushed. Basically, I reverted an attempt to optimize repeated
restores to the same page. I had a rather bad thinko there where I
essentially assumed that it was also to the same mark, so advancing
marks on the same page caused the bug. There's probably room to
optimize that with more refined logic, but for now I just reverted
the problem code.
I reduced the test case supplied by the OP to something smaller
which still failed the assertion without the patch, but am having
trouble getting it to run in the regression test environment with a
stable plan. In order to deal with 9.6beta1 issues I'm setting
that aside for the moment and will see if I can get something
commit-worthy into the regression tests for this once I clear the
beta issues.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Kevin Grittner <kgrittn@gmail.com> writes:
> On Wed, Jun 1, 2016 at 11:15 AM, Kevin Grittner <kgrittn@gmail.com> wrote:
>> On Wed, Jun 1, 2016 at 11:10 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> In short: Kevin, you broke mark/restore. Please fix.
>> I'm on it.
> Fix pushed.
I confirm this fixes the submitted test case.
> Basically, I reverted an attempt to optimize repeated
> restores to the same page. I had a rather bad thinko there where I
> essentially assumed that it was also to the same mark, so advancing
> marks on the same page caused the bug. There's probably room to
> optimize that with more refined logic, but for now I just reverted
> the problem code.
Sounds reasonable. The comments in that removed hunk of code had made
me suspicious as heck the moment I saw them ...
> I reduced the test case supplied by the OP to something smaller
> which still failed the assertion without the patch, but am having
> trouble getting it to run in the regression test environment with a
> stable plan.
Best bet might be to use a temp table, so that autoanalyze won't touch it.
regards, tom lane