Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oBb70-0000XU-QZ for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Jul 2022 12:05:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oBb6z-0006EU-NA for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Jul 2022 12:05:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oBaom-00084l-OP for pgsql-bugs@lists.postgresql.org; Wed, 13 Jul 2022 11:46:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oBaog-00043r-VB for pgsql-bugs@lists.postgresql.org; Wed, 13 Jul 2022 11:46:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=xvQYZDVzrfF4AsH0SJq8CSdAEvcYcKc/v8jizo0767o=; b=JdCquH0PQ9/xGlfvofLXZIKhsu tDmtB/VswEbzFiKc/pnrhubmtQaKaJxeWiJAe0Xe2U4P+PjCBVYPDWr7y6ihWVdApLecAi8ALSisN 1EUsNGYJYLqbosbj/2yuDObLWoNY8xuKchcb9aAIObzfdtTwE6DmmjYeabVH+uM11ZeRXhf+VvQnd H+d+i5hCwHrmd4+rz1RYprwBih6fFTtaZjvpPV1qGduCFGNTdP7/JvBTpnQxGxHzEAytEqCFZNFRM kJ9KQRDymctD1VmsGSoYh+WpBVMBXtOqsqmJXUY0A4EN8r7skMCGELO6beiGz/Sk+tfw9PhF0KMlZ Z7+vM0uA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oBaoe-00060d-7H for pgsql-bugs@lists.postgresql.org; Wed, 13 Jul 2022 11:46:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oBaoc-009h7j-06 for pgsql-bugs@lists.postgresql.org; Wed, 13 Jul 2022 11:46:02 +0000 Content-Type: multipart/mixed; boundary="===============4464988799799268645==" MIME-Version: 1.0 Subject: BUG #17549: wrong index scan plan with RLS To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 875941708@qq.com Reply-To: 875941708@qq.com, pgsql-bugs@lists.postgresql.org Date: Wed, 13 Jul 2022 11:45:54 +0000 Message-ID: <17549-5114159516d34c2d@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4464988799799268645== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU0OQpMb2dnZWQgYnk6ICAgICAgICAgIFpoYW8gUnVpCkVtYWlsIGFk ZHJlc3M6ICAgICAgODc1OTQxNzA4QHFxLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE0LjQKT3Bl cmF0aW5nIHN5c3RlbTogICBBbGwKRGVzY3JpcHRpb246ICAgICAgICAKCllvdSBjYW4gcmVwcm9k dWNlIGluIHRoaXMgd2F5Og0KDQpjcmVhdGUgdGFibGUgYWJjIChhIGludGVnZXIsIGIgdGV4dCk7 DQppbnNlcnQgaW50byBhYmMgc2VsZWN0IChyYW5kb20oKSooMTBeNCkpOjppbnRlZ2VyLCAocmFu ZG9tKCkqKDEwXjQpKTo6dGV4dApmcm9tIGdlbmVyYXRlX3NlcmllcygxLDEwMDAwMCk7DQpjcmVh dGUgaW5kZXggb24gYWJjKGEsIGxvd2VyKGIpKTsNCg0KQUxURVIgVEFCTEUgYWJjIGVuYWJsZSBS T1cgTEVWRUwgU0VDVVJJVFk7DQpBTFRFUiBUQUJMRSBhYmMgRk9SQ0UgIFJPVyBMRVZFTCBTRUNV UklUWTsNCkNSRUFURSBQT0xJQ1kgYWJjX2lkX2lzb19wbHkgb24gYWJjIHRvIENVUlJFTlRfVVNF UiBVU0lORyAoYSA9CihjdXJyZW50X3NldHRpbmcoJ2FwcC5hJzo6dGV4dCkpOjppbnQpOw0KDQoj IGZvciBieXBhc3MgdXNlciwgaW5kZXggc2NhbiB3b3JrcyBmaW5lDQpleHBsYWluIGFuYWx5c2Ug c2VsZWN0ICogZnJvbSBhYmMgd2hlcmUgYT0xIGFuZCBsb3dlcihiKT0nMTIzNCc7DQogICAgIElu ZGV4IFNjYW4gdXNpbmcgYWJjX2FfbG93ZXJfaWR4IG9uIGFiYw0KICAgICAgICAgSW5kZXggQ29u ZDogKChhID0gMSkgQU5EIChsb3dlcihiKSA9ICcxMjM0Jzo6dGV4dCkpDQoNCiMgZm9yIFJMUyB1 c2VyLCBpbmRleCBzY2FuIGNhbiBvbmx5IHVzZSBjb2x1bW4gYSwgYW5kIGZpbHRlciBieSBsb3dl cihiKQ0Kc2V0IGFwcC5hPTE7DQpleHBsYWluIGFuYWx5c2Ugc2VsZWN0ICogZnJvbSBhYmMgd2hl cmUgYT0xIGFuZCBsb3dlcihiKT0nMTIzNCc7DQogICAgIEluZGV4IFNjYW4gdXNpbmcgYWJjX2Ff bG93ZXJfaWR4IG9uIGFiYw0KICAgICAgICAgSW5kZXggQ29uZDogKGEgPSAxKQ0KICAgICAgICAg RmlsdGVyOiAobG93ZXIoYikgPSAnMTIzNCc6OnRleHQpDQoNClRoaXMgb25seSBvY2N1cnMgd2hl biB1c2luZyBub24tbGVhay1wcm9vZiBmdW5jdGlvbmFsIGluZGV4LiBFdmVyeXRoaW5nCndvcmtz IGZpbmUgaW4gZm9sbG93aW5nIHdheToNCmNyZWF0ZSBpbmRleCBvbiBhYmMoYSwgYik7DQpleHBs YWluIGFuYWx5c2Ugc2VsZWN0ICogZnJvbSBhYmMgd2hlcmUgYT0xIGFuZCBiPScxMjM0JzsNCg0K SSB0aGluayBjcnVjaWFsIGZ1bmN0aW9uIGlzIHJlc3RyaWN0aW9uX2lzX3NlY3VyZWx5X3Byb21v dGFibGUuIE1heWJlIGl0IGlzCnRvbyBzdHJpY3QgdG8gcmVqZWN0IG5vcm1hbCBjbGF1c2UgbWF0 Y2guDQpDb3VsZCB5b3UgcGxlYXNlIHJlY2hlY2sgUkxTIHdpdGggZnVuY3Rpb25hbCBpbmRleD8K Cg== --===============4464988799799268645==--