BUG #16201: Second column in Range Partition is scanning all the partitions
PG Bug reporting form <[email protected]> Fri, 10 Jan 2020 08:58:23 +0000
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <[email protected]> |
--===============8385105865641003966== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjIwMQpMb2dnZWQgYnk6ICAgICAgICAgIFJhaHVsIFNhaGEKRW1haWwg YWRkcmVzczogICAgICByYWh1bHNhaGEwMzA5QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEwLjUKT3BlcmF0aW5nIHN5c3RlbTogICBBbWF6b24gTGludXgKRGVzY3JpcHRpb246ICAgICAg ICAKCkhpIFBnIFRlYW0sDQoNCkkgd2FzIHdvcmtpbmcgb24gUGFydGl0aW9ucyBvbiB2ZXJzaW9u IDEwLjUgYW5kIEkgYW0gbm90IGFibGUgdG8gdW5kZXJzdGFuZAp0aGlzIGJlaGF2aW91ciwgY291 bGQgeW91IHBsZWFzZSBzaGFyZSB5b3VyIGNvbW1lbnRzLg0KDQpJIGNyZWF0ZWQgcmFuZ2UgcGFy dGl0aW9ucyBvbiB0d28gY29sdW1ucyBhbmQgd2hlbiBJIHRyeSB0byBzZWUgZXhwbGFpbiBwbGFu CmZvciBjb2x1bW4gYiBhcyB3aGVyZSBjb25kaXRpb25zLCBpdCBkb2VzIHNjYW5uaW5nIG9uIGFs bCB0aGUgcGFydGl0aW9ucy4gSXMKaXQgZXhwZWN0ZWQgYmVoYXZpb3VyIG9yIHRoaXMgaXMgYSBi dWcuIFBsZWFzZSBmaW5kIGJlbG93IHRoZSBzdGVwcyAtIA0KDQpQRyBWZXJzaW9uIDEwLjUgLQ0K DQpDcmVhdGUgUGFyZW50IFRhYmxlOg0KPT09PT09PT09PT09PT09PQ0KQ1JFQVRFIFRBQkxFIHNh bGVzMw0KKA0KICBkZXB0X25vICAgICBpbnQsDQogIHNhbGVfeWVhciAgICBpbnQsDQogIHNhbGVf bW9udGggICBpbnQsDQogIHNhbGVfZGF5ICAgICBpbnQsDQogIGFtb3VudCAgICAgIGludA0KKQ0K UEFSVElUSU9OIEJZIFJBTkdFKHNhbGVfeWVhciwgc2FsZV9tb250aCk7DQoNCkNyZWF0ZSBQYXJ0 aXRpb24vQ2hpbGQgVGFibGU6DQo9PT09PT09PT09PT09PT09PT09PT09PT0NCmNyZWF0ZSB0YWJs ZSBjaGlsZDEgcGFydGl0aW9uIG9mIHNhbGVzMyBmb3IgdmFsdWVzIGZyb20gKCcyMDAwJywnNCcp IHRvCignMjAxMCcsJzcnKTsNCg0KY3JlYXRlIHRhYmxlIGNoaWxkMiBwYXJ0aXRpb24gb2Ygc2Fs ZXMzIGZvciB2YWx1ZXMgZnJvbSAoJzIwMTEnLCc4JykgdG8KKCcyMDIwJywnMTInKTsNCg0KY3Jl YXRlIHRhYmxlIGNoaWxkMyAgcGFydGl0aW9uIG9mIHNhbGVzMyBmb3IgdmFsdWVzIGZyb20gKCcy MDIxJywnMTMnKSB0bwooJzIwMjMnLCcxNicpOw0KDQpjcmVhdGUgdGFibGUgY2hpbGQ0ICBwYXJ0 aXRpb24gb2Ygc2FsZXMzIGZvciB2YWx1ZXMgZnJvbSAoJzIwMjEnLCcxNycpIHRvCignMjAyMycs JzEwMDAnKTsNCg0KRXhwbGFpbiBwbGFucyAgd2l0aCBjb2x1bW4gQQ0KPT09PT09PT09PT09PT09 PT09PT09PT0NCnBvc3RncmVzPT4gZXhwbGFpbiBzZWxlY3QgKiBmcm9tIHNhbGVzMyB3aGVyZSBz YWxlX3llYXI9JzIwMDEnOw0KICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAg ICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogQXBwZW5kICAoY29zdD0wLjAwLi4zMS4y NSByb3dzPTggd2lkdGg9MjApDQogICAtPiAgU2VxIFNjYW4gb24gY2hpbGQxICAoY29zdD0wLjAw Li4zMS4yNSByb3dzPTggd2lkdGg9MjApDQogICAgICAgICBGaWx0ZXI6IChzYWxlX3llYXIgPSAy MDAxKQ0KKDMgcm93cykNCg0KRXhwbGFpbiBwbGFucyAgd2l0aCBjb2x1bW4gQSAmIEINCj09PT09 PT09PT09PT09PT09PT09PT09PT09DQoNCnBvc3RncmVzPT4gZXhwbGFpbiBzZWxlY3QgKiBmcm9t IHNhbGVzMyB3aGVyZSBzYWxlX3llYXI9JzIwMDEnIGFuZApzYWxlX21vbnRoPSc1JzsNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgICAgICAgICAgICAgICAg DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KIEFwcGVuZCAgKGNvc3Q9MC4wMC4uMzUuNTAgcm93cz0xIHdpZHRoPTIwKQ0KICAg LT4gIFNlcSBTY2FuIG9uIGNoaWxkMSAgKGNvc3Q9MC4wMC4uMzUuNTAgcm93cz0xIHdpZHRoPTIw KQ0KICAgICAgICAgRmlsdGVyOiAoKHNhbGVfeWVhciA9IDIwMDEpIEFORCAoc2FsZV9tb250aCA9 IDUpKQ0KKDMgcm93cykNCg0KRXhwbGFpbiBwbGFucyAgd2l0aCBjb2x1bW4gQg0KPT09PT09PT09 PT09PT09PT09PT09PT0NCg0KcG9zdGdyZXM9PiBleHBsYWluIHNlbGVjdCAqIGZyb20gc2FsZXMz IHdoZXJlICBzYWxlX21vbnRoPSc5JzsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkg UExBTiAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEFwcGVuZCAgKGNvc3Q9MC4w MC4uNjIuNTAgcm93cz0xNiB3aWR0aD0yMCkNCiAgIC0+ICBTZXEgU2NhbiBvbiBjaGlsZDEgIChj b3N0PTAuMDAuLjMxLjI1IHJvd3M9OCB3aWR0aD0yMCkNCiAgICAgICAgIEZpbHRlcjogKHNhbGVf bW9udGggPSA5KQ0KICAgLT4gIFNlcSBTY2FuIG9uIGNoaWxkMiAgKGNvc3Q9MC4wMC4uMzEuMjUg cm93cz04IHdpZHRoPTIwKQ0KICAgICAgICAgRmlsdGVyOiAoc2FsZV9tb250aCA9IDkpIA0KKDUg cm93cykNCg0KSWYgeW91IHNlZSB0aGUgbGFzdCBFeHBsYWluIHBsYW4sIGl0IGlzIHNjYW5uaW5n IGJvdGggIHRoZSBjaGlsZCB0YWJsZS4gSXMKaXQgZXhwZWN0ZWQgYmVoYXZpb3VyLCBpZiB5ZXMg Y2FuIHlvdSBwbGVhc2UgaGVscCBtZSB1bmRlcnN0YW5kIHRoYXQgPwoK --===============8385105865641003966==--