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.92) (envelope-from ) id 1jDiqF-0006iq-5u for pgsql-bugs@arkaria.postgresql.org; Mon, 16 Mar 2020 06:03:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jDiqD-00048S-QQ for pgsql-bugs@arkaria.postgresql.org; Mon, 16 Mar 2020 06:03:09 +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 1jDiqD-00048L-IV for pgsql-bugs@lists.postgresql.org; Mon, 16 Mar 2020 06:03:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jDiqA-0008FH-2r for pgsql-bugs@lists.postgresql.org; Mon, 16 Mar 2020 06:03:09 +0000 Content-Type: multipart/mixed; boundary="===============7065809880251512543==" MIME-Version: 1.0 Subject: BUG #16303: A condtion whether an index-only scan is possible includes a wrong To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: horimoto@clear-code.com Reply-To: horimoto@clear-code.com, pgsql-bugs@lists.postgresql.org Date: Mon, 16 Mar 2020 06:02:25 +0000 Message-ID: <16303-889581eb40fc0691@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7065809880251512543== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjMwMwpMb2dnZWQgYnk6ICAgICAgICAgIEhvcmltb3RvIFlhc3VoaXJv CkVtYWlsIGFkZHJlc3M6ICAgICAgaG9yaW1vdG9AY2xlYXItY29kZS5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIDEwLjMKRGVzY3JpcHRpb246 ICAgICAgICAKCkhlbGxvLCBkZXZlbG9wZXJzLg0KDQpJIHRoaW5rIHRoYXQgdGhlIGNvbmRpdGlv biBvZiB3aGV0aGVyIGFuIGluZGV4LW9ubHkgc2NhbiBpcyBwb3NzaWJsZQppbmNsdWRlcyBhIHdy b25nLg0KDQpGb3IgZXhhbXBsZSwgaW4gdGhlIGZvbGxvd2luZyBjYXNlLCB0aGUgaW5kZXggaGFz IG5vIGRhdGEgdG8gcmV0dXJuLiBCZWNhdXNlCnRoZSBxdWVyeSBkb2Vzbid0IHVzZSBzcGVjaWZ5 IGNvbHVtbnMuDQpIb3dldmVyLCB0aGUgcXVlcnkgcGxhbm5lciBjaG9pY2UgaW5kZXgtb25seSBz Y2FuLg0KDQpjcmVhdGUgdGFibGUgZ2lzdF9jb3VudF90YmwgKHRzdiB0c3ZlY3Rvcik7DQppbnNl cnQgaW50byBnaXN0X2NvdW50X3RibCB2YWx1ZXMgKG51bGwpOw0KY3JlYXRlIGluZGV4IGdpc3Rf Y291bnRfdGJsX2luZGV4IG9uIGdpc3RfY291bnRfdGJsIHVzaW5nIGdpc3QgKHRzdik7DQoNCnZh Y3V1bSBhbmFseXplIGdpc3RfY291bnRfdGJsOw0KDQpzZXQgZW5hYmxlX3NlcXNjYW49b2ZmOw0K c2V0IGVuYWJsZV9iaXRtYXBzY2FuPW9mZjsNCnNldCBlbmFibGVfaW5kZXhvbmx5c2Nhbj1vbjsN Cg0KZXhwbGFpbiAoY29zdHMgb2ZmKQ0Kc2VsZWN0IGNvdW50KCopIGZyb20gZ2lzdF9jb3VudF90 Ymw7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4gICAgICAgICAgICAg ICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBBZ2dyZWdhdGUNCiAgIC0+ICBJbmRleCBP bmx5IFNjYW4gdXNpbmcgZ2lzdF9jb3VudF90YmxfaW5kZXggb24gZ2lzdF9jb3VudF90YmwNCigy IHJvd3MpDQoNCkluIG15IG9waW5pb24sIHdlIGV4cGVjdGVkIHRoYXQgdGhlIHF1ZXJ5IHBsYW5u ZXIgZG9lc24ndCBjaG9vc2UgYW4KaW5kZXgtb25seSBzY2FuIGluIHRoZSBhYm92ZSBjYXNlLiAN Cg0KSW4gZmFjdCwgaW5kZXhfY2FucmV0dXJuX2F0dHJzIG9mCmh0dHBzOi8vZ2l0aHViLmNvbS9w b3N0Z3Jlcy9wb3N0Z3Jlcy9ibG9iL21hc3Rlci9zcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9p bmR4cGF0aC5jI0wxOTUxCmlzIE5VTEwgaW4gdGhlIGFib3ZlIGNhc2UuDQoNCnRoYW5rcyEKCg== --===============7065809880251512543==--