Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iXpbp-000829-Ks for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Nov 2019 16:47:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iXpbo-0000h8-Dz for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Nov 2019 16:47:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iXpbo-0000h1-6M for pgsql-bugs@lists.postgresql.org; Thu, 21 Nov 2019 16:47:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iXpbl-00044c-5r for pgsql-bugs@lists.postgresql.org; Thu, 21 Nov 2019 16:47:07 +0000 Content-Type: multipart/mixed; boundary="===============7682084044662708574==" MIME-Version: 1.0 Subject: BUG #16130: planner does not pick unique btree index and goes for seq scan but unsafe hash index works. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mayur555b@protonmail.com Reply-To: mayur555b@protonmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 21 Nov 2019 16:46:58 +0000 Message-ID: <16130-d936946edf14de14@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7682084044662708574== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjEzMApMb2dnZWQgYnk6ICAgICAgICAgIE1heXVyIEIuCkVtYWlsIGFk ZHJlc3M6ICAgICAgbWF5dXI1NTViQHByb3Rvbm1haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog OS42LjE1Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1CkRlc2NyaXB0aW9uOiAgICAgICAgCgpI aSwNCklmIGFueW9uZSBlbmNvdW50ZXJlZCB0aGlzIHRoZW4gcGxlYXNlIHN1Z2dlc3Qgc29sdXRp b24uDQoNCnZlcnNpb24gPT4gUG9zdGdyZVNRTCA5LjYuMTUgb24geDg2XzY0LXBjLWxpbnV4LWdu dSAoVWJ1bnR1CjkuNi4xNS0xLnBnZGcxOC4wNCsxKSwgY29tcGlsZWQgYnkgZ2NjIChVYnVudHUg Ny40LjAtMXVidW50dTF+MTguMDQuMSkKNy40LjAsIDY0LWJpdA0KDQpQbGFubmVyIGRvZXMgbm90 IHBpY2sgdW5pcXVlIGJ0cmVlIGluZGV4IGFuZCBnb2VzIGZvciBzZXEgc2NhbiBidXQgdW5zYWZl Cmhhc2ggaW5kZXggd29ya3MuDQoNCkJlbG93IGlzIG91dHB1dCBvZiBhIHNpbXBsZSB0ZXN0IGNh c2UgYW5kIG90aGVyIHN0YXRzLCBzZXR0aW5ncyBldGMuDQpJIGhhdmUgdHJpZWQgZXZlcnl0aGlu ZyBmcm9tIHZhY3V1bSBhbmFseXplLGNvdmVyIGluZGV4ZXMgdG8gZGlzYWJsaW5nIHNlcQpzY2Fu IGJ1dCBpdCBkb2VzIG5vdCBtYWtlIHBsYW5uZXIgZ28gZm9yIGluZGV4IHNjYW4uIA0KU2hvcnQg dGVybSBmaXg6IFJlaW5kZXggc3lzdGVtIGFuZCByZWJvb3Qgd29ya3MsIHRoYXQgbWVhbnMgZXZl cnl0aGluZwpjcmVhdGVkIHByaW9yIHRvIHJlaW5kZXggc3lzdGVtIHN0YXJ0cyBnZXR0aW5nIHVz ZWQgYnkgcGxhbm5lci4gQW5vdGhlcgpvYnNlcnZhdGlvbiwgaWYgdGhlcmUgYXJlIG5vIHNlc3Np b25zIHJ1bm5pbmcgb24gZGF0YWJhc2UgKGtpbGxlZC9zZXJ2aWNlcwpzaHV0ZG93bikgYW5kIHRo ZW4gYnRyZWUgaW5kZXggaXMgY3JlYXRlZCB0aGVuIGl0IGlzIHVzZWQgYnkgcGxhbm5lci4gDQoN CnBvc3RncmVzQGRiX2ZpbmRiIG9uIGZpbmRiMSAoW2xvY2FsXTo1NDMyKT0jIENSRUFURSBUQUJM RSB0ZXN0X3RhYiBBUyAoDQpkYl9maW5kYigjIFNFTEVDVCBHRU5FUkFURV9TRVJJRVM6Om51bWVy aWMgaWQxDQpkYl9maW5kYigjICAgICAgLCAocmFuZG9tKCkgKiA5MDAwMCk6Om51bWVyaWMgKyAx MDAwMDAgaWQyDQpkYl9maW5kYigjICAgICAgLCAocmFuZG9tKCkgKiA5MDAwMCk6Om51bWVyaWMg KyAxMDAwMDAgaWQzDQpkYl9maW5kYigjICAgICAgLCAocmFuZG9tKCkgKiA5MDAwMCk6Om51bWVy aWMgKyAxMDAwMDAgaWQ0DQpkYl9maW5kYigjICAgICAgLCAocmFuZG9tKCkgKiA5MDAwMCk6Om51 bWVyaWMgKyAxMDAwMDAgaWQ1DQpkYl9maW5kYigjICAgRlJPTSBHRU5FUkFURV9TRVJJRVMoMTAw MDAwLCAxOTk5OTkpDQpkYl9maW5kYigjICk7DQpTRUxFQ1QgMTAwMDAwDQpwb3N0Z3Jlc0BkYl9m aW5kYiBvbiBmaW5kYjEgKFtsb2NhbF06NTQzMik9IyBjcmVhdGUgdW5pcXVlIGluZGV4CmlkeF9i dHJlZV91cV9pZDEgb24gdGVzdF90YWIoaWQxKTsNCkNSRUFURSBJTkRFWA0KcG9zdGdyZXNAZGJf ZmluZGIgb24gZmluZGIxIChbbG9jYWxdOjU0MzIpPSMgYW5hbHl6ZSB0ZXN0X3RhYjsNCkFOQUxZ WkUNCnBvc3RncmVzQGRiX2ZpbmRiIG9uIGZpbmRiMSAoW2xvY2FsXTo1NDMyKT0jIGV4cGxhaW4g KGFuYWx5emUsYnVmZmVycykKc2VsZWN0IGlkMSxpZDIgZnJvbSB0ZXN0X3RhYiB3aGVyZSBpZDE9 MTAwMDAyOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFV RVJZIFBMQU4NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N CiBTZXEgU2NhbiBvbiB0ZXN0X3RhYiAgKGNvc3Q9MC4wMC4uMjM4Ny4wMCByb3dzPTEgd2lkdGg9 MTgpIChhY3R1YWwKdGltZT0wLjAwOS4uMTMuNDM4IHJvd3M9MSBsb29wcz0xKQ0KICAgRmlsdGVy OiAoaWQxID0gJzEwMDAwMic6Om51bWVyaWMpDQogICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiA5 OTk5OQ0KICAgQnVmZmVyczogc2hhcmVkIGhpdD0xMTM3DQogUGxhbm5pbmcgdGltZTogMC4wODMg bXMNCiBFeGVjdXRpb24gdGltZTogMTMuNDUyIG1zDQooNiByb3dzKQ0KDQpwb3N0Z3Jlc0BkYl9m aW5kYiBvbiBmaW5kYjEgKFtsb2NhbF06NTQzMik9IyBjcmVhdGUgaW5kZXggaWR4X2hhc2hfdXFf aWQxIG9uCnRlc3RfdGFiIHVzaW5nIGhhc2goaWQxKTsNCldBUk5JTkc6ICBoYXNoIGluZGV4ZXMg YXJlIG5vdCBXQUwtbG9nZ2VkIGFuZCB0aGVpciB1c2UgaXMgZGlzY291cmFnZWQNCkNSRUFURSBJ TkRFWA0KcG9zdGdyZXNAZGJfZmluZGIgb24gZmluZGIxIChbbG9jYWxdOjU0MzIpPSMgYW5hbHl6 ZSB0ZXN0X3RhYjsNCkFOQUxZWkUNCnBvc3RncmVzQGRiX2ZpbmRiIG9uIGZpbmRiMSAoW2xvY2Fs XTo1NDMyKT0jIGV4cGxhaW4gKGFuYWx5emUsYnVmZmVycykKc2VsZWN0IGlkMSxpZDIgZnJvbSB0 ZXN0X3RhYiB3aGVyZSBpZDE9MTAwMDAyOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFODQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBJbmRleCBT Y2FuIHVzaW5nIGlkeF9oYXNoX3VxX2lkMSBvbiB0ZXN0X3RhYiAgKGNvc3Q9MC4wMC4uMi4yMiBy b3dzPTEKd2lkdGg9MTgpIChhY3R1YWwgdGltZT0wLjAwOS4uMC4wMTAgcm93cz0xIGxvb3BzPTEp DQogICBJbmRleCBDb25kOiAoaWQxID0gJzEwMDAwMic6Om51bWVyaWMpDQogICBCdWZmZXJzOiBz aGFyZWQgaGl0PTMNCiBQbGFubmluZyB0aW1lOiAwLjA5OCBtcw0KIEV4ZWN1dGlvbiB0aW1lOiAw LjAyNSBtcw0KKDUgcm93cykNCg0KLS0tPT09PT09PT0tLS0gU29tZSBzZXR0aW5ncyBhbmQgc3Rh dHMgLS0tPT09PT09PT09PT09DQoNCnBvc3RncmVzQGRiX2ZpbmRiIG9uIGZpbmRiMSAoW2xvY2Fs XTo1NDMyKT0jIHNlbGVjdCBuYW1lLHNldHRpbmcsdW5pdCBmcm9tCnBnX2NhdGFsb2cucGdfc2V0 dGluZ3MNCmRiX2ZpbmRiLSMgd2hlcmUgbmFtZSBpbgooJ3JhbmRvbV9wYWdlX2Nvc3QnLCdzZXFf cGFnZV9jb3N0JywnZWZmZWN0aXZlX2NhY2hlX3NpemUnLCdzaGFyZWRfYnVmZmVycycsJ2VuYWJs ZV9pbmRleG9ubHlzY2FuJw0KZGJfZmluZGIoIyAsJ2VuYWJsZV9pbmRleHNjYW4nKTsNCiAgICAg ICAgIG5hbWUgICAgICAgICB8IHNldHRpbmcgIHwgdW5pdA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLS0tKy0tLS0tLQ0KIGVmZmVjdGl2ZV9jYWNoZV9zaXplIHwgMzc3NDg3MzYgfCA4 a0INCiBlbmFibGVfaW5kZXhvbmx5c2NhbiB8IG9uICAgICAgIHwNCiBlbmFibGVfaW5kZXhzY2Fu ICAgICB8IG9uICAgICAgIHwNCiByYW5kb21fcGFnZV9jb3N0ICAgICB8IDEuMSAgICAgIHwNCiBz ZXFfcGFnZV9jb3N0ICAgICAgICB8IDEgICAgICAgIHwNCiBzaGFyZWRfYnVmZmVycyAgICAgICB8 IDEyNTgyOTEyIHwgOGtCDQooNiByb3dzKQ0KDQpwb3N0Z3Jlc0BkYl9maW5kYiBvbiBmaW5kYjEg KFtsb2NhbF06NTQzMik9IyBzZWxlY3QgcmVsdHVwbGVzOjpudW1lcmljIGZyb20KcGdfY2xhc3Mg d2hlcmUgcmVsbmFtZXNwYWNlPSdmaW5kYic6OnJlZ25hbWVzcGFjZSBhbmQgcmVsbmFtZT0ndGVz dF90YWInOw0KIHJlbHR1cGxlcw0KLS0tLS0tLS0tLS0NCiAgICAxMDAwMDANCigxIHJvdykNCg0K cG9zdGdyZXNAZGJfZmluZGIgb24gZmluZGIxIChbbG9jYWxdOjU0MzIpPSMgc2VsZWN0IHJlbHR1 cGxlczo6bnVtZXJpYyBmcm9tCnBnX2NsYXNzIHdoZXJlIHJlbG5hbWU9J2lkeF9idHJlZV91cV9p ZDEnOw0KIHJlbHR1cGxlcw0KLS0tLS0tLS0tLS0NCiAgICAxMDAwMDANCigxIHJvdykNCg0KcG9z dGdyZXNAZGJfZmluZGIgb24gZmluZGIxIChbbG9jYWxdOjU0MzIpPSMgc2VsZWN0IGluZGV4cmVs aWQ6OnJlZ2NsYXNzLAppbmRuYXR0cywgaW5kaXN1bmlxdWUsIGluZGlzdmFsaWQsIGluZGlzcmVh ZHksIGluZGlzbGl2ZSwgaW5ka2V5DQpkYl9maW5kYi0jIGZyb20gcGdfaW5kZXggd2hlcmUgaW5k cmVsaWQ9J2ZpbmRiLnRlc3RfdGFiJzo6cmVnY2xhc3M7DQogICAgaW5kZXhyZWxpZCAgICB8IGlu ZG5hdHRzIHwgaW5kaXN1bmlxdWUgfCBpbmRpc3ZhbGlkIHwgaW5kaXNyZWFkeSB8CmluZGlzbGl2 ZSB8IGluZGtleQ0KLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tDQogaWR4X2hhc2hf dXFfaWQxICB8ICAgICAgICAxIHwgZiAgICAgICAgICAgfCB0ICAgICAgICAgIHwgdCAgICAgICAg ICB8IHQgICAgCiAgICB8IDENCiBpZHhfYnRyZWVfdXFfaWQxIHwgICAgICAgIDEgfCB0ICAgICAg ICAgICB8IHQgICAgICAgICAgfCB0ICAgICAgICAgIHwgdCAgICAKICAgIHwgMQ0KKDIgcm93cykN Cg0KcG9zdGdyZXNAZGJfZmluZGIgb24gZmluZGIxIChbbG9jYWxdOjU0MzIpPSMgc2VsZWN0IGF0 dG5hbWUsIG51bGxfZnJhYywKYXZnX3dpZHRoLCBuX2Rpc3RpbmN0OjpudW1lcmljLCBjb3JyZWxh dGlvbiBmcm9tIHBnX3N0YXRzIHdoZXJlCnRhYmxlbmFtZT0ndGVzdF90YWInOw0KIGF0dG5hbWUg fCBudWxsX2ZyYWMgfCBhdmdfd2lkdGggfCBuX2Rpc3RpbmN0IHwgY29ycmVsYXRpb24NCi0tLS0t LS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0K IGlkMSAgICAgfCAgICAgICAgIDAgfCAgICAgICAgIDYgfCAgICAgICAgIC0xIHwgICAgICAgICAg IDENCiBpZDIgICAgIHwgICAgICAgICAwIHwgICAgICAgIDEyIHwgICAtMC45OTk5OCB8IC0wLjAw NDI1NDIyDQogaWQzICAgICB8ICAgICAgICAgMCB8ICAgICAgICAxMiB8ICAgLTAuOTk5OTcgfCAt MC4wMDIzNzAwOQ0KIGlkNCAgICAgfCAgICAgICAgIDAgfCAgICAgICAgMTIgfCAgIC0wLjk5OTk5 IHwgMC4wMDA0MjM4OTUNCiBpZDUgICAgIHwgICAgICAgICAwIHwgICAgICAgIDEyIHwgICAtMC45 OTk5NiB8IC0wLjAwNTIwOTM3DQooNSByb3dzKQoK --===============7682084044662708574==--