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 1nrGW4-0004gB-Ur for pgsql-bugs@arkaria.postgresql.org; Wed, 18 May 2022 10:02:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nrGW3-0007a5-RC for pgsql-bugs@arkaria.postgresql.org; Wed, 18 May 2022 10:02:51 +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 1nrG88-0008Ds-5a for pgsql-bugs@lists.postgresql.org; Wed, 18 May 2022 09:38:08 +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 1nrG86-0001Yp-SQ for pgsql-bugs@lists.postgresql.org; Wed, 18 May 2022 09:38:07 +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=FD4Oz9f4DtPUN9Dg7GOs3zjA5PYmTgoMt1gqdT14PYY=; b=kJiPAjoEv0gc13oPWeeelAkYuF GOCxTYWAC5wsLP2vLbAFCHcjlt3pTSTAD+pgmV6SWY0a0UxNugN3iKBKiY9WAmTdbKg9AAx3vNnSm JAK54xbkEMZph3q33diE/fqe9H9fYyEtxzdOIa9MLzvnMxYEegsBPoDfZ/VD+IhBZ7rdjUaLfAzMl TnwH5Mbuv6g9bHuH2cVxxw8ha8R7t89bKyVJwc9DuIDzCkmyvhDpJzAD1uSSABzvx6cWX4UoQlyAD xuVNDxjgrK1uU0XxhxUgJvwMBcauZAAAdbGlcNtvbjnYNQuS2am9uRuIOXJ7KSQJZnVPswzqj9wFO s5V7hwmw==; 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 1nrG85-0007Q9-A0 for pgsql-bugs@lists.postgresql.org; Wed, 18 May 2022 09:38: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 1nrG83-0089zD-Vs for pgsql-bugs@lists.postgresql.org; Wed, 18 May 2022 09:38:02 +0000 Content-Type: multipart/mixed; boundary="===============3062652792464495309==" MIME-Version: 1.0 Subject: BUG #17484: Query does not prune partitions correctly 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: Wed, 18 May 2022 09:37:20 +0000 Message-ID: <17484-716a1fcbcb0e379b@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 --===============3062652792464495309== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ4NApMb2dnZWQgYnk6ICAgICAgICAgIERhbWlyIENpZ2Fub3ZpxIct SmFua292acSHCkVtYWlsIGFkZHJlc3M6ICAgICAgZGFtaXIuY2lnYW5vdmljLmphbmtvdmljQGdt YWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEzLjUKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5k b3dzIDEwLCBDZW50T1MgNwpEZXNjcmlwdGlvbjogICAgICAgIAoKV2UgaGF2ZSB1cGdyYWRlZCBQ b3N0Z3JlcyBmcm9tIDExLjEyIHRvIDEzLjUgYW5kIGhhdmUgc3RhcnRlZCB0bwpleHBlcmllbmNl DQpzb21lIHByb2JsZW1zIHdpdGggb25lIHF1ZXJ5LiBXZSBhcmUgdXNpbmcgSmF2YSBhbmQgcG9z dGdyZXMgamRiYyBkcml2ZXIsIA0KYnV0IHdlIGhhdmUgbWFuYWdlZCB0byByZXByb2R1Y2UgdGhl IHByb2JsZW0gd2l0aCBwc3FsLg0KDQotLSBTdGFydGluZyBTY2hlbWEuDQpEUk9QIFRBQkxFIElG IEVYSVNUUyB0ZXN0Ow0KRFJPUCBUWVBFIElGIEVYSVNUUyB0ZXN0X2VudW07DQpERUFMTE9DQVRF IG15X3ByZXBhcmVkX3N0YXRlbWVudDsNCkRFQUxMT0NBVEUgbXlfcHJlcGFyZWRfc3RhdGVtZW50 X3dpdGhfZW51bV9pbmxpbmVkOw0KREVBTExPQ0FURSBteV9wcmVwYXJlZF9zdGF0ZW1lbnRfbXVs dGlfcGFydGl0aW9uOw0KRFJPUCBGVU5DVElPTiBJRiBFWElTVFMgY3JlYXRlX3Rlc3RfcGFydGl0 aW9uczsNCiANCkNSRUFURSBUWVBFIHRlc3RfZW51bSBBUyBFTlVNICgnRklSU1QnLCAnU0VDT05E Jyk7DQotLSBOT1RFOiBQYXJ0aXRpb25zIGFyZSBieSByYW5nZSB3aXRoIDIgdmFsdWVzLCBvbmUg aXMgZW51bSwgb3RoZXIgaXMKdGltZXN0YW1wDQpDUkVBVEUgVEFCTEUgdGVzdCAoZW51bV9jb2wg dGVzdF9lbnVtLCB0aW1lc3RhbXBfY29sIHRpbWVzdGFtcCwgc29tZV9pZCBpbnQsCnN0YXR1cyBp bnQpIFBBUlRJVElPTiBCWSBSQU5HRSAoZW51bV9jb2wsIHRpbWVzdGFtcF9jb2wpOw0KIA0KLS0g Q2FzZTogV3JvbmcgcGFydGl0aW9uIHBydW5pbmcNCi0tIENyZWF0ZSA0IHBhcnRpdGlvbnMgb2Yg dGVzdCB0YWJsZToNCkNSRUFURSBUQUJMRSB0ZXN0X0ZJUlNUXzEgUEFSVElUSU9OIE9GIHRlc3Qg Rk9SIFZBTFVFUyBGUk9NICgnRklSU1QnLAonMjAyMi0wMS0wMScpIFRPICgnRklSU1QnLCAnMjAy Mi0wMS0wMicpOw0KQ1JFQVRFIFRBQkxFIHRlc3RfRklSU1RfMiBQQVJUSVRJT04gT0YgdGVzdCBG T1IgVkFMVUVTIEZST00gKCdGSVJTVCcsCicyMDIyLTAxLTAyJykgVE8gKCdGSVJTVCcsICcyMDIy LTAxLTAzJyk7DQogDQpDUkVBVEUgVEFCTEUgdGVzdF9TRUNPTkRfMSBQQVJUSVRJT04gT0YgdGVz dCBGT1IgVkFMVUVTIEZST00gKCdTRUNPTkQnLAonMjAyMi0wMS0wMScpIFRPICgnU0VDT05EJywg JzIwMjItMDEtMDInKTsNCkNSRUFURSBUQUJMRSB0ZXN0X1NFQ09ORF8yIFBBUlRJVElPTiBPRiB0 ZXN0IEZPUiBWQUxVRVMgRlJPTSAoJ1NFQ09ORCcsCicyMDIyLTAxLTAyJykgVE8gKCdTRUNPTkQn LCAnMjAyMi0wMS0wMycpOw0KDQoNCi0tIEFuYWx5emVzIEFMTCA0IHBhcnRpdGlvbnMgZXZlbiB0 aG91Z2ggd2Ugc3BlY2lmaWVkIHRoYXQgd2Ugd2FudCBvbmx5CidGSVJTVCcuIFNob3VsZCBoYXZl IGFuYWx5emVkIG9ubHkgdGVzdF9GSVJTVF8xLiBOT1RFOiBzYW1lIHJlc3VsdCB3aXRoCkVYUExB SU4gQU5BTFlaRQ0KUFJFUEFSRSBteV9wcmVwYXJlZF9zdGF0ZW1lbnQodGV4dCwgdGV4dCwgdGV4 dCkgQVMgVVBEQVRFIHRlc3QgU0VUIHNvbWVfaWQgPQo1IFdIRVJFIHRpbWVzdGFtcF9jb2wgPj0g Q0FTVCgkMSBBUyB0aW1lc3RhbXAoNikpIEFORCB0aW1lc3RhbXBfY29sIDwKQ0FTVCgkMiBBUyB0 aW1lc3RhbXAoNikpIEFORCBlbnVtX2NvbCA9ICQzOjp0ZXN0X2VudW07DQpFWFBMQUlOIEVYRUNV VEUgbXlfcHJlcGFyZWRfc3RhdGVtZW50KCcyMDIyLTAxLTAxIDAxOjAwOjAwJywgJzIwMjItMDEt MDEKMDI6MDA6MDAnLCAnRklSU1QnKTsNCg0KLS0gZXhhbXBsZSB3aGVuIHN0YXRlbWVudCBpcyBu b3QgcHJlcGFyZWQgKHdvcmtzIGFzIGV4cGVjdGVkKToNCkVYUExBSU4gVVBEQVRFIHRlc3QgU0VU IHNvbWVfaWQgPSA1IFdIRVJFIHRpbWVzdGFtcF9jb2wgPj0gQ0FTVCgnMjAyMi0wMS0wMQowMTow MDowMCcgQVMgdGltZXN0YW1wKDYpKSBBTkQgdGltZXN0YW1wX2NvbCA8IENBU1QoJzIwMjItMDEt MDEgMDI6MDA6MDAnIEFTCnRpbWVzdGFtcCg2KSkgQU5EIGVudW1fY29sID0gJ0ZJUlNUJzo6dGVz dF9lbnVtOw0KDQoNCi0tIEFuYWx5emVzIGJvdGggdGVzdF9GSVJTVF8xIGFuZCB0ZXN0X0ZJUlNU XzIgZGVzcGl0ZSBsb29raW5nIGZvciBvbmx5CicyMDIyLTAxLTAxJy4gTk9URTogc2FtZSByZXN1 bHQgd2l0aCBFWFBMQUlOIEFOQUxZWkUNClBSRVBBUkUgbXlfcHJlcGFyZWRfc3RhdGVtZW50X3dp dGhfZW51bV9pbmxpbmVkKHRleHQsIHRleHQpIEFTIFVQREFURSB0ZXN0ClNFVCBzb21lX2lkID0g NSBXSEVSRSB0aW1lc3RhbXBfY29sID49IENBU1QoJDEgQVMgdGltZXN0YW1wKDYpKSBBTkQKdGlt ZXN0YW1wX2NvbCA8IENBU1QoJDIgQVMgdGltZXN0YW1wKDYpKSBBTkQgZW51bV9jb2wgPSAnRklS U1QnOw0KRVhQTEFJTiBFWEVDVVRFIG15X3ByZXBhcmVkX3N0YXRlbWVudF93aXRoX2VudW1faW5s aW5lZCgnMjAyMi0wMS0wMQowMTowMDowMCcsICcyMDIyLTAxLTAxIDAyOjAwOjAwJyk7DQoNCi0t IGV4YW1wbGUgd2hlbiBzdGF0ZW1lbnQgaXMgbm90IHByZXBhcmVkICh3b3JrcyBhcyBleHBlY3Rl ZCk6DQpFWFBMQUlOIFVQREFURSB0ZXN0IFNFVCBzb21lX2lkID0gNSBXSEVSRSB0aW1lc3RhbXBf Y29sID49IENBU1QoJzIwMjItMDEtMDEKMDE6MDA6MDAnIEFTIHRpbWVzdGFtcCg2KSkgQU5EIHRp bWVzdGFtcF9jb2wgPCBDQVNUKCcyMDIyLTAxLTAxIDAyOjAwOjAwJyBBUwp0aW1lc3RhbXAoNikp IEFORCBlbnVtX2NvbCA9ICdGSVJTVCc6OnRlc3RfZW51bTsNCg0KVGhpcyBjYXVzZXMgb3VyIHF1 ZXJ5IHRvIGJlIHJlYWxseSBzbG93LiBXaGF0IEkgbm90aWNlZCBpcyB0aGF0IHRoaXMgYWxzbwpt aWdodCBoYXZlDQpoYXBwZW5lZCBvbiAxMS4xMiwgYnV0IHdlIGRpZG4ndCBub3RpY2UgdGhpcyB1 bnRpbCBzZWNvbmQgcHJvYmxlbSBzdGFydGVkCnRvDQphcHBlYXIsIGJ1dCBsZXRzIG5vdCBib3Ro ZXIgYWJvdXQgdGhhdCBvbmUuDQoNCk1PUkUgQkFDS0dST1VORDogDQoxLiBXaGlsZSBteSBxdWVy eSBoZXJlIGxvb2tzIGxpa2UgIldpdGggWCBhcyAoU0VMRUNUKSAtPiBVUERBVEUgIiwgbXkNCm9y aWdpbmFsIHF1ZXJ5IGxvb2tzIGxpa2UgIkNyZWF0ZSB1bmxvZ2dlZCB0YWJsZSBBUyAoV2l0aCBY IGFzIChTRUxFQ1QpLA0Kd2l0aCBZIGFzIFVQREFURSByZXR1cm5pbmcgKiAtPiBTRUxFQ1QgRlJP TSBZIiB3aGljaCBiYXNpY2FsbHkgbWVhbnMgdGhhdApJDQphbSB1cGRhdGluZyB0YWJsZSBhbmQg Y3JlYXRpbmcgbmV3IHRhYmxlIHdpdGggdXBkYXRlZCByZWNvcmRzLiBJIGhhdmUKdHJpZWQNCnRv IHNpbXBsaWZ5IGl0IHRvIGVhc2llciBleHBsYWluIHRoZSBwcm9ibGVtIGhlcmUsIGhvcGVmdWxs eSBJIHN1Y2NlZWRlZC4NCjIuIEN1cnJlbnQgd29ya2Fyb3VuZCBpcyB0byBub3QgdXNlIHByZXBh cmVkIHN0YXRlbWVudCBpbnNpZGUgYXBwbGljYXRpb24NCnRoYXQgaXMgZXhlY3V0aW5nIHRoaXMg cHJvYmxlbWF0aWMgcXVlcnksIGJ1dCB3ZSB3b3VsZCBwcmVmZXIgdG8gdXNlIHRoZW0KaWYNCnRo aXMgd291bGQgYmUgZml4ZWQuDQoNClRoYW5rIHlvdSBpbiBhZHZhbmNlLCBEYW1pcgoK --===============3062652792464495309==--