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 1pvPXI-0003Oa-Lo for pgsql-bugs@arkaria.postgresql.org; Sat, 06 May 2023 21:33:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pvPXH-0002iN-6B for pgsql-bugs@arkaria.postgresql.org; Sat, 06 May 2023 21:33:47 +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 1pvOxu-00077m-TL for pgsql-bugs@lists.postgresql.org; Sat, 06 May 2023 20:57:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pvOxm-0010LO-HZ for pgsql-bugs@lists.postgresql.org; Sat, 06 May 2023 20:57:13 +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=Hp1GQE4dlf6IEEooxFlF4/VrhCgFHO14CyDsG8zxu88=; b=ZzMjqRhXcddTzH/3qFyoDo2lKT fLrd75yJb5O6WkNr0RRy/eu8NVlNgf2NXQvRSyxCVZyzTwR6uviOiIGdLGt+r9/87kwUPgAXJeNZ3 ShGBKpX6w2z40MGgJNTCGBtKCbY50ujdjAN8tNnLdIdAs08frTD6whAx9MtuF+Y0wyZouUwrqhNAT GURYF10Wv+nHvgdw1kBG0BJFF5DgfoCQHOppDAZM6HHl8CyHGIwGfcDacvEZnhYR3lAWxtF/lryhP rqhhhRXOnWiDNH+7ZwvbtHW5N2gfnEbYwvMtrbxk9XpK2kkJXlLl8qu4YGeUU6iixVnhy3wQkYsrU DHrTRV5w==; 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 1pvOxl-0006Xz-L0 for pgsql-bugs@lists.postgresql.org; Sat, 06 May 2023 20:57: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 1pvOxi-0033dv-3i for pgsql-bugs@lists.postgresql.org; Sat, 06 May 2023 20:57:02 +0000 Content-Type: multipart/mixed; boundary="===============0518229853736792066==" MIME-Version: 1.0 Subject: BUG #17922: ANY vs IN execution plan difference for a single explicit input value To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kaarel.moppel@gmail.com Reply-To: kaarel.moppel@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 06 May 2023 20:56:21 +0000 Message-ID: <17922-1e2e0aeedd294424@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 --===============0518229853736792066== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzkyMgpMb2dnZWQgYnk6ICAgICAgICAgIEthYXJlbCBNb3BwZWwKRW1h aWwgYWRkcmVzczogICAgICBrYWFyZWwubW9wcGVsQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE1LjIKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCkkgZ3Vlc3MgdGhlcmUgY2FuIGJlIGRpZmZlcmVuY2VzIGhvdyBJTiB2cyBBTlkgaW5w dXQgaXMgaGFuZGxlZCBmb3IgcHJlcGFyZWQKc3RhdGVtZW50cyBidXQgZm9yIHBsYWluIFNRTCBp bnB1dCBJIHdvdWxkIGV4cGVjdCB0aGVtIHRvIHByb2R1Y2UgaWRlbnRpY2FsCnBsYW5zLiBTZWVt cyB0byBiZSBub3QgdGhlIGNhc2UgdGhvdWdoIGZvciBhIGJlbG93IHNjZW5hcmlvIHdoaWNoIHdl CnN0dW1ibGVkIG9uIGluIHByb2R1Y3Rpb24gd2hlcmUgdGhlcmUncyBhIHJ1bnRpbWUgZGlmZmVy ZW5jZSBvZiBhcm91bmQgNQpvcmRlcnMgb2YgbWFnbml0dWRlIGFzIGEgZGlmZmVyZW50IGxlYWRp bmcgaW5kZXggaXMgY2hvc2VuLiBBIHJlcGVhdGFibGUKdGVzdCBjYXNlOg0KDQpDUkVBVEUgVU5M T0dHRUQgVEFCTEUgYSAoDQogICAgbm9kZV9pZCBpbnQ4IE5PVCBOVUxMIEdFTkVSQVRFRCBCWSBE RUZBVUxUIEFTIElERU5USVRZLA0KICAgIHByb2plY3RfaWQgaW50OCBOT1QgTlVMTA0KKTsNCg0K SU5TRVJUIElOVE8gYSAocHJvamVjdF9pZCkNClNFTEVDVA0KICAgIENBU0UgV0hFTiByYW5kb20o KSA8IDAuOTkgVEhFTg0KICAgICAgICAxDQogICAgRUxTRQ0KICAgICAgICAyDQogICAgRU5EDQpG Uk9NDQogICAgZ2VuZXJhdGVfc2VyaWVzKDEsIDhlNik7DQoNCkNSRUFURSBVTklRVUUgSU5ERVgg YV91cSBPTiBhIChwcm9qZWN0X2lkLCBub2RlX2lkKTsNCg0KVkFDVVVNIEFOQUxZWkUgYTsNCg0K Q1JFQVRFIFVOTE9HR0VEIFRBQkxFIGIgKA0KICAgIG5vZGVfaWQgaW50OCBOT1QgTlVMTCBVTklR VUUNCik7DQoNCklOU0VSVCBJTlRPIGIgKG5vZGVfaWQpDQpTRUxFQ1QNCiAgICBub2RlX2lkDQpG Uk9NICgNCiAgICBTRUxFQ1QNCiAgICAgICAgbm9kZV9pZA0KICAgIEZST00NCiAgICAgICAgYQ0K ICAgIFdIRVJFDQogICAgICAgIG5vZGVfaWQgPiA3ZTYNCiAgICBMSU1JVCAxNTAwMCkgeDsNCg0K VkFDVVVNIEFOQUxZWkUgYjsNCg0KRVhQTEFJTg0KU0VMRUNUDQogICAgYS4qDQpGUk9NDQogICAg YQ0KICAgIEpPSU4gYiBVU0lORyAobm9kZV9pZCkNCldIRVJFDQogICAgYS5wcm9qZWN0X2lkID0g QU5ZIChBUlJBWVsxXTo6aW50OFtdKQ0KT1JERVIgQlkNCiAgICBhLnByb2plY3RfaWQsDQogICAg YS5ub2RlX2lkDQpMSU1JVCAxMDsNCg0KRVhQTEFJTg0KU0VMRUNUDQogICAgYS4qDQpGUk9NDQog ICAgYQ0KICAgIEpPSU4gYiBVU0lORyAobm9kZV9pZCkNCldIRVJFDQogICAgYS5wcm9qZWN0X2lk IElOICgxKSAtLSBBbHNvIE9LIHdpdGggYSBwbGFpbiAiPTEiIHdpdG91dCBJTg0KT1JERVIgQlkN CiAgICBhLnByb2plY3RfaWQsDQogICAgYS5ub2RlX2lkDQpMSU1JVCAxMDsNCg0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4gICAgICAgICAgICAgICAg ICAgICAgICAgIAogICAgICAgICAgICAgIA0K4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSADQogTGltaXQgIChjb3N0PTAuNzIuLjE3ODkuNjggcm93cz0xMCB3aWR0 aD0xNikNCiAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC43Mi4uMjY1NTE3NS40NSByb3dzPTE0 ODQyIHdpZHRoPTE2KQ0KICAgICAgICAgLT4gIEluZGV4IE9ubHkgU2NhbiB1c2luZyBhX3VxIG9u IGEgIChjb3N0PTAuNDMuLjI2MDQ1Mi4xOQpyb3dzPTc5MTU4NzIgd2lkdGg9MTYpDQogICAgICAg ICAgICAgICBJbmRleCBDb25kOiAocHJvamVjdF9pZCA9IEFOWSAoJ3sxfSc6OmJpZ2ludFtdKSkN CiAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgYl9ub2RlX2lkX2tleSBvbiBiICAo Y29zdD0wLjI5Li4wLjMwCnJvd3M9MSB3aWR0aD04KQ0KICAgICAgICAgICAgICAgSW5kZXggQ29u ZDogKG5vZGVfaWQgPSBhLm5vZGVfaWQpDQooNiByb3dzKQ0KDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAg CiAgICAgICAgICAgICAgICAgDQrilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIANCiBMaW1pdCAgKGNvc3Q9MC43Mi4uMzguMDcgcm93cz0xMCB3aWR0 aD0xNikNCiAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC43Mi4uNTU0NDAuNzkgcm93cz0xNDg0 MiB3aWR0aD0xNikNCiAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgYl9ub2RlX2lk X2tleSBvbiBiICAoY29zdD0wLjI5Li4zOTcuMjkKcm93cz0xNTAwMCB3aWR0aD04KQ0KICAgICAg ICAgLT4gIEluZGV4IE9ubHkgU2NhbiB1c2luZyBhX3VxIG9uIGEgIChjb3N0PTAuNDMuLjMuNjcg cm93cz0xCndpZHRoPTE2KQ0KICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChwcm9qZWN0X2lk ID0gMSkgQU5EIChub2RlX2lkID0gYi5ub2RlX2lkKSkNCig1IHJvd3MpCgo= --===============0518229853736792066==--