BUG #14438: Wrong row count in the join plan with unique index scan - Mailing list pgsql-bugs
| From | nikolay.nikitin@infowatch.com |
|---|---|
| Subject | BUG #14438: Wrong row count in the join plan with unique index scan |
| Date | |
| Msg-id | 20161128182113.6527.58926@wrigleys.postgresql.org Whole thread Raw |
| Responses |
Re: BUG #14438: Wrong row count in the join plan with unique index scan
|
| List | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQzOApMb2dnZWQgYnk6ICAg ICAgICAgIE5pa29sYXkgTmlraXRpbgpFbWFpbCBhZGRyZXNzOiAgICAgIG5p a29sYXkubmlraXRpbkBpbmZvd2F0Y2guY29tClBvc3RncmVTUUwgdmVyc2lv bjogOS42LjEKT3BlcmF0aW5nIHN5c3RlbTogICBSZWQgSGF0IHNlcnZlciA2 LjcKRGVzY3JpcHRpb246ICAgICAgICAKCkhpLA0KDQpJIGV4ZWN1dGUgc2Vs ZWN0IHdpdGggImluIiBjb25kaXRpb24gb24gdGhlIGVtcHR5IHRhYmxlLg0K VGhpcyBzZWxlY3Qgd29ya3Mgd2l0aCB3cm9uZyBwbGFuLiANCkkgdGhpbmsg dGhlIHdyb25nIHBsYW4gaXMgY2hvc2VuIGJlY29zZSB0aGUgcG9zdGdyZXMg b3B0aW1pemVyIGluY29ycmVjdGx5CmNhbGN1bGF0ZXMgcm93IGNvdW50IGlu IHRoZSByaWdodCBwbGFuLg0KU2FtcGxlOg0KDQpkcm9wIHRhYmxlIGlmIGV4 aXN0cyB0ZXN0X21haW47DQoNCi0tIG1haW4gdGFibGUgd2l0aCBtYW55IGRh dGEgcm93cw0KY3JlYXRlIHRhYmxlIHRlc3RfbWFpbg0KKA0KICBpZCBudW1l cmljKDIwKSBub3QgbnVsbCwNCiAgdG1zIHRpbWVzdGFtcCBub3QgbnVsbCwN CiAgcHJpbWFyeSBrZXkgKGlkKQ0KKTsNCg0KY3JlYXRlIGluZGV4IGlkeF90 ZXN0X21haW5fdG1zIG9uIHRlc3RfbWFpbih0bXMgZGVzYyk7DQoNCmluc2Vy dCBpbnRvIHRlc3RfbWFpbihpZCwgdG1zKQ0Kc2VsZWN0IGEsIGN1cnJlbnRf ZGF0ZSArICh0cnVuYyhyYW5kb20oKSAqIDMgKiAyNCAqIDYwKSB8fCAnCm1p bnV0ZXMnKTo6aW50ZXJ2YWwNCmZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsIDEw MDAwMCkgYTsNCg0KYW5hbHl6ZSB0ZXN0X21haW47DQoNCmRyb3AgdGFibGUg aWYgZXhpc3RzIHRlc3Rfc2xhdmU7DQoNCi0tIGVtcHR5IHRhYmxlIHRlc3Rf c2xhdmUNCmNyZWF0ZSB0YWJsZSB0ZXN0X3NsYXZlDQooDQogIGlkIG51bWVy aWMoMjApIG5vdCBudWxsLA0KICBuIG51bWVyaWMNCik7DQoNCmNyZWF0ZSBp bmRleCBpZHhfdGVzdF9zbGF2ZV9uIG9uIHRlc3Rfc2xhdmUobik7DQoNCmFu YWx5emUgdGVzdF9zbGF2ZTsNCg0KLS0gV3JvbmcgcGxhbi4gQXQgZmlyc3Qg aWR4X3Rlc3RfbWFpbl90bXMgaW5kZXggaXMgdXNlZC4gDQpleHBsYWluICAN CnNlbGVjdCAqDQpmcm9tIHRlc3RfbWFpbg0Kd2hlcmUgdG1zIGJldHdlZW4g Y3VycmVudF9kYXRlIGFuZCBjdXJyZW50X2RhdGUgKyAxDQogIGFuZCBpZCBp biANCiAgKHNlbGVjdCBpZCBmcm9tIHRlc3Rfc2xhdmUgd2hlcmUgbiA9IDUp DQpvcmRlciBieSB0bXMgZGVzYw0KbGltaXQgMTAwOw0KDQotLSBSaWdodCBw bGFuIHdpdGggZXJyb3IuIEF0IGZpcnN0IGlkeF90ZXN0X3NsYXZlX24gaW5k ZXggaXMgdXNlZC4gDQpleHBsYWluICANCnNlbGVjdCAqDQpmcm9tIHRlc3Rf bWFpbg0Kd2hlcmUgdG1zIGJldHdlZW4gY3VycmVudF9kYXRlIGFuZCBjdXJy ZW50X2RhdGUgKyAnMSBob3VyJzo6aW50ZXJ2YWwNCiAgYW5kIGlkIGluIA0K ICAoc2VsZWN0IGlkIGZyb20gdGVzdF9zbGF2ZSB3aGVyZSBuID0gNSkNCm9y ZGVyIGJ5IHRtcyBkZXNjDQpsaW1pdCAxMDA7DQoNClRoZSB3cm9uZyBwbGFu IGdvZXMgZnJvbSB0aGUgYmlnIG1haW4gdGFibGUuDQpUaGUgcmlnaHQgcGxh biBzY2FucyB0aGUgc2xhdmUgZW1wdHkgdGFibGUgYXQgdGhlIGJlZ2lubmlu Zy4NCkJ1dCBpdCBoYXMgZXJyb3I6DQoiTGltaXQgIChjb3N0PTU2LjgyLi41 Ny4wNyByb3dzPTEwMCB3aWR0aD0xNCkiDQoiICAtPiAgU29ydCAgKGNvc3Q9 NTYuODIuLjU4LjYxIHJvd3M9NzE4IHdpZHRoPTE0KSINCiIgICAgICAgIFNv cnQgS2V5OiB0ZXN0X21haW4udG1zIg0KIiAgICAgICAgLT4gIE5lc3RlZCBM b29wICAoY29zdD0xMi45Ny4uMjkuMzcgcm93cz03MTggd2lkdGg9MTQpIg0K IiAgICAgICAgICAgICAgLT4gIEhhc2hBZ2dyZWdhdGUgIChjb3N0PTEyLjY3 Li4xMi42OSByb3dzPTIgd2lkdGg9MjApIg0KIiAgICAgICAgICAgICAgICAg ICAgR3JvdXAgS2V5OiB0ZXN0X3NsYXZlLmlkIg0KIiAgICAgICAgICAgICAg ICAgICAgLT4gIEJpdG1hcCBIZWFwIFNjYW4gb24gdGVzdF9zbGF2ZSAgKGNv c3Q9NC4xOS4uMTIuNjYKcm93cz01IHdpZHRoPTIwKSINCiIgICAgICAgICAg ICAgICAgICAgICAgICAgIFJlY2hlY2sgQ29uZDogKG4gPSA1OjpudW1lcmlj KSINCiIgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBCaXRtYXAgSW5k ZXggU2NhbiBvbiBpZHhfdGVzdF9zbGF2ZV9uIAooY29zdD0wLjAwLi40LjE5 IHJvd3M9NSB3aWR0aD0wKSINCiIgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIEluZGV4IENvbmQ6IChuID0gNTo6bnVtZXJpYykiDQoiICAgICAg ICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB0ZXN0X21haW5fcGtleSBv biB0ZXN0X21haW4gCihjb3N0PTAuMjkuLjguMzMgcm93cz0xIHdpZHRoPTE0 KSINCiIgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChpZCA9IHRl c3Rfc2xhdmUuaWQpIg0KIiAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAo KHRtcyA+PSAoJ25vdyc6OmNzdHJpbmcpOjpkYXRlKSBBTkQgKHRtcyA8PQoo KCdub3cnOjpjc3RyaW5nKTo6ZGF0ZSArICcwMTowMDowMCc6OmludGVydmFs KSkpIg0KDQpUaGUgSGFzaEFnZ3JlZ2F0ZSBzdGVwIHJldHVybnMgMiByb3dz LiBJdCBqb2lucyB3aXRoIHRoZSBtYWluIHRhYmxlIGJ5IHVzaW5nCnByaW1h cnkgdW5pcXVlIGluZGV4IHRlc3RfbWFpbl9wa2V5Lg0KVGhlIE5lc3RlZCBM b29wIHN0ZXAgaGFzIHRvIHJldHVybiBtYXhpbXVtIDIgcm93cyBidXQgd2Ug c2VlIHJvd3M9NzE4LiBJdCBpcwppbmNvcnJlY3QgY2FsY3VsYXRpb24uDQpB bmQgdGhlcmVmb3JlIHRoZSBTb3J0IHN0ZXAgaXMgc28gbG9uZy4gDQpBbmQg b24gZ3JlYXRlciB0aW1lc3RhbXAgaW50ZXJ2YWwgdGhlIHJpZ2h0IHBsYW4g Y29zdCB3aWxsIGJlIG1vcmUgdGhlIHdyb25nCnBsYW4gY29zdC4NCg0KQWxz byBpdCBpcyB2ZXJ5IHN0cmFuZ2UgdGhhdCB0aGUgcmVjb3JkIGNvdW50IGlz IGVxdWFsIDUsIGJ1dCBub3QgMCBpbiBzdGVwCihCaXRtYXAgSW5kZXggU2Nh biBvbiBpZHhfdGVzdF9zbGF2ZV9uICAoY29zdD0wLjAwLi40LjE5IHJvd3M9 NSB3aWR0aD0wKSkuDQpTbGF2ZSB0YWJsZSBpcyBlbXB0eSwgYnV0IHJvdyBj b3VudCBpcyBlcXVhbCA1Lg0KDQpSZWdhcmRzLA0KTmlrb2xheS4KCg==
pgsql-bugs by date: