Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwnzG-004ITx-Ml for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Apr 2024 18:56:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rwnzD-005dD7-E0 for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Apr 2024 18:56:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwjUj-00403b-7t for pgsql-bugs@lists.postgresql.org; Tue, 16 Apr 2024 14:09:09 +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 1rwjUf-001HQV-RK for pgsql-bugs@lists.postgresql.org; Tue, 16 Apr 2024 14:09:08 +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=9Tyg4NOlcgeJGHu6Rr+UfOY6WtQm32SACPP3UFQVewU=; b=X8QuMODVus0XME7EJsHusKesbM EppbunHcvcWhf5j7qaufOSZu/mLmOhnIO0xeSJA5FOabpLf2zn0fv2vCUTZ+348ASSrO3+uL5pq0b OXPgrUCVfbdAdyIc6ewVUR3mM55jBQeZIxc9O4JnDtVCT+x0kPS+SDmGC9bqVDdvENvs8Q4Xly+UG nSa0LoqE4t6ZG85LcJpXO4icnCzNWxD2Qt5CzZrTSrgvkmtpETqcrujfkc4EPcUFWe/qLbFABQC/X 1FNyH2M+dKQJ/vUDVfb5dILde5DKgUKHlE09DqU6dnp+uNNbJHj+AS43MVZpASyaTCxSyA0IUnov+ 4AWn+NRA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwjUd-007e53-Or for pgsql-bugs@lists.postgresql.org; Tue, 16 Apr 2024 14:09:04 +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 1rwjUb-008cVs-N5 for pgsql-bugs@lists.postgresql.org; Tue, 16 Apr 2024 14:09:02 +0000 Content-Type: multipart/mixed; boundary="===============3059458521866578164==" MIME-Version: 1.0 Subject: BUG #18440: Query does not prune partitions correctly or use index when prepared statements are used To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: damir.ciganovic.jankovic@gmail.com Reply-To: damir.ciganovic.jankovic@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 16 Apr 2024 14:08:15 +0000 Message-ID: <18440-9928108d0df1a36b@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 --===============3059458521866578164== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQ0MApMb2dnZWQgYnk6ICAgICAgICAgIERhbWlyIENpZ2Fub3ZpxIct SmFua292acSHCkVtYWlsIGFkZHJlc3M6ICAgICAgZGFtaXIuY2lnYW5vdmljLmphbmtvdmljQGdt YWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE1LjYKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51 eApEZXNjcmlwdGlvbjogICAgICAgIAoKTm90ZSwgc2FtZSBidWcgZnJvbQpodHRwczovL3d3dy5w b3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkLzE3NDg0LTcxNmExZmNiY2IwZTM3OWIlNDBwb3N0Z3Jl c3FsLm9yZwosIEkgd2FzIGluc3RydWN0ZWQgdG8gY2hlY2sgb24gUG9zdGdyZXMgMTQsIGJ1dCB0 aGUgaXNzdWUgaXMgc3RpbGwgcHJlc2VudAppbiAxNS42IGFuZCAxNi4yIHZlcnNpb25zLiBJIHdp bGwgcmVwZWF0IHRoZSBzdGVwcyBmb3IgcmVwcm9kdWNpbmcsIGJ1dCBub3RlCnRoYXQgd2UgaGF2 ZSBhbHNvIGV4cGVyaWVuY2UgcG9vciBwZXJmb3JtYW5jZSB3aGVuIGluZGV4IHdhcyBub3QgdXNl ZCBkdWUgdG8KcHJlcGFyZWQgc3RhdGVtZW50cy4gQ3VycmVudCB3b3JrYXJvdW5kIGlzIHRvIG5v dCB1c2UgcHJlcGFyZWQgc3RhdGVtZW50cw0KDQpTdGVwcyB0byByZXByb2R1Y2U6DQotLSBTdGFy dGluZyBTY2hlbWEuDQpEUk9QIFRBQkxFIElGIEVYSVNUUyB0ZXN0Ow0KRFJPUCBUWVBFIElGIEVY SVNUUyB0ZXN0X2VudW07DQpERUFMTE9DQVRFIG15X3ByZXBhcmVkX3N0YXRlbWVudDsNCkRFQUxM T0NBVEUgbXlfcHJlcGFyZWRfc3RhdGVtZW50X3dpdGhfZW51bV9pbmxpbmVkOw0KREVBTExPQ0FU RSBteV9wcmVwYXJlZF9zdGF0ZW1lbnRfbXVsdGlfcGFydGl0aW9uOw0KRFJPUCBGVU5DVElPTiBJ RiBFWElTVFMgY3JlYXRlX3Rlc3RfcGFydGl0aW9uczsNCiANCkNSRUFURSBUWVBFIHRlc3RfZW51 bSBBUyBFTlVNICgnRklSU1QnLCAnU0VDT05EJyk7DQoNCi0tIE5PVEU6IFBhcnRpdGlvbnMgYXJl IGJ5IHJhbmdlIHdpdGggMiB2YWx1ZXMsIG9uZSBpcyBlbnVtLCBvdGhlciBpcwp0aW1lc3RhbXAg Q1JFQVRFIFRBQkxFIHRlc3QgKGVudW1fY29sIHRlc3RfZW51bSwgdGltZXN0YW1wX2NvbCB0aW1l c3RhbXAsCnNvbWVfaWQgaW50LCBzdGF0dXMgaW50KSBQQVJUSVRJT04gQlkgUkFOR0UgKGVudW1f Y29sLCB0aW1lc3RhbXBfY29sKTsNCiANCi0tIENhc2U6IFdyb25nIHBhcnRpdGlvbiBwcnVuaW5n DQotLSBDcmVhdGUgNCBwYXJ0aXRpb25zIG9mIHRlc3QgdGFibGU6DQpDUkVBVEUgVEFCTEUgdGVz dF9GSVJTVF8xIFBBUlRJVElPTiBPRiB0ZXN0IEZPUiBWQUxVRVMgRlJPTSAoJ0ZJUlNUJywNCicy MDIyLTAxLTAxJykgVE8gKCdGSVJTVCcsICcyMDIyLTAxLTAyJyk7DQpDUkVBVEUgVEFCTEUgdGVz dF9GSVJTVF8yIFBBUlRJVElPTiBPRiB0ZXN0IEZPUiBWQUxVRVMgRlJPTSAoJ0ZJUlNUJywNCicy MDIyLTAxLTAyJykgVE8gKCdGSVJTVCcsICcyMDIyLTAxLTAzJyk7DQogDQpDUkVBVEUgVEFCTEUg dGVzdF9TRUNPTkRfMSBQQVJUSVRJT04gT0YgdGVzdCBGT1IgVkFMVUVTIEZST00gKCdTRUNPTkQn LA0KJzIwMjItMDEtMDEnKSBUTyAoJ1NFQ09ORCcsICcyMDIyLTAxLTAyJyk7DQpDUkVBVEUgVEFC TEUgdGVzdF9TRUNPTkRfMiBQQVJUSVRJT04gT0YgdGVzdCBGT1IgVkFMVUVTIEZST00gKCdTRUNP TkQnLA0KJzIwMjItMDEtMDInKSBUTyAoJ1NFQ09ORCcsICcyMDIyLTAxLTAzJyk7DQoNCi0tIEFu YWx5emVzIEFMTCA0IHBhcnRpdGlvbnMgZXZlbiB0aG91Z2ggd2Ugc3BlY2lmaWVkIHRoYXQgd2Ug d2FudCBvbmx5CidGSVJTVCcuIFNob3VsZCBoYXZlIGFuYWx5emVkIG9ubHkgdGVzdF9GSVJTVF8x LiBOT1RFOiBzYW1lIHJlc3VsdCB3aXRoCkVYUExBSU4gQU5BTFlaRQ0KUFJFUEFSRSBteV9wcmVw YXJlZF9zdGF0ZW1lbnQodGV4dCwgdGV4dCwgdGV4dCkgQVMgVVBEQVRFIHRlc3QgU0VUIHNvbWVf aWQKPQ0KNSBXSEVSRSB0aW1lc3RhbXBfY29sID49IENBU1QoJDEgQVMgdGltZXN0YW1wKDYpKSBB TkQgdGltZXN0YW1wX2NvbCA8DQpDQVNUKCQyIEFTIHRpbWVzdGFtcCg2KSkgQU5EIGVudW1fY29s ID0gJDM6OnRlc3RfZW51bTsNCkVYUExBSU4gRVhFQ1VURSBteV9wcmVwYXJlZF9zdGF0ZW1lbnQo JzIwMjItMDEtMDEgMDE6MDA6MDAnLCAnMjAyMi0wMS0wMQ0KMDI6MDA6MDAnLCAnRklSU1QnKTsN Cg0KLS0gZXhhbXBsZSB3aGVuIHN0YXRlbWVudCBpcyBub3QgcHJlcGFyZWQgKHdvcmtzIGFzIGV4 cGVjdGVkKToNCkVYUExBSU4gVVBEQVRFIHRlc3QgU0VUIHNvbWVfaWQgPSA1IFdIRVJFIHRpbWVz dGFtcF9jb2wgPj0KQ0FTVCgnMjAyMi0wMS0wMQ0KMDE6MDA6MDAnIEFTIHRpbWVzdGFtcCg2KSkg QU5EIHRpbWVzdGFtcF9jb2wgPCBDQVNUKCcyMDIyLTAxLTAxIDAyOjAwOjAwJwpBUw0KdGltZXN0 YW1wKDYpKSBBTkQgZW51bV9jb2wgPSAnRklSU1QnOjp0ZXN0X2VudW07DQoNCi0tIEFuYWx5emVz IGJvdGggdGVzdF9GSVJTVF8xIGFuZCB0ZXN0X0ZJUlNUXzIgZGVzcGl0ZSBsb29raW5nIGZvciBv bmx5CicyMDIyLTAxLTAxJy4gTk9URTogc2FtZSByZXN1bHQgd2l0aCBFWFBMQUlOIEFOQUxZWkUN ClBSRVBBUkUgbXlfcHJlcGFyZWRfc3RhdGVtZW50X3dpdGhfZW51bV9pbmxpbmVkKHRleHQsIHRl eHQpIEFTIFVQREFURSB0ZXN0DQpTRVQgc29tZV9pZCA9IDUgV0hFUkUgdGltZXN0YW1wX2NvbCA+ PSBDQVNUKCQxIEFTIHRpbWVzdGFtcCg2KSkgQU5EDQp0aW1lc3RhbXBfY29sIDwgQ0FTVCgkMiBB UyB0aW1lc3RhbXAoNikpIEFORCBlbnVtX2NvbCA9ICdGSVJTVCc7DQpFWFBMQUlOIEVYRUNVVEUg bXlfcHJlcGFyZWRfc3RhdGVtZW50X3dpdGhfZW51bV9pbmxpbmVkKCcyMDIyLTAxLTAxDQowMTow MDowMCcsICcyMDIyLTAxLTAxIDAyOjAwOjAwJyk7DQoNCi0tIGV4YW1wbGUgd2hlbiBzdGF0ZW1l bnQgaXMgbm90IHByZXBhcmVkICh3b3JrcyBhcyBleHBlY3RlZCk6DQpFWFBMQUlOIFVQREFURSB0 ZXN0IFNFVCBzb21lX2lkID0gNSBXSEVSRSB0aW1lc3RhbXBfY29sID49CkNBU1QoJzIwMjItMDEt MDENCjAxOjAwOjAwJyBBUyB0aW1lc3RhbXAoNikpIEFORCB0aW1lc3RhbXBfY29sIDwgQ0FTVCgn MjAyMi0wMS0wMSAwMjowMDowMCcKQVMNCnRpbWVzdGFtcCg2KSkgQU5EIGVudW1fY29sID0gJ0ZJ UlNUJzo6dGVzdF9lbnVtOwoK --===============3059458521866578164==--