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 1miFE0-0003Wp-Nj for pgsql-bugs@arkaria.postgresql.org; Wed, 03 Nov 2021 12:18:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1miFDz-0005yc-Mi for pgsql-bugs@arkaria.postgresql.org; Wed, 03 Nov 2021 12:18:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1miElQ-0005uJ-5J for pgsql-bugs@lists.postgresql.org; Wed, 03 Nov 2021 11:49:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1miElM-0000UF-Cj for pgsql-bugs@lists.postgresql.org; Wed, 03 Nov 2021 11:49: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=NR4t5eWqxJosNSsEXgzVD05mQjmDkeg6t9b3RlcFjnw=; b=qoCTVMvKojxwFLQl5cTCMR0idb pAWsmZBuR//KxYcaJXSACrkm7jE5CDfUweulIPcUCLtIG6gvE/56DO0pTzlznL0LE3tGtlIGp8z6O E2oH6xfXLT2JvBFf34A+L+KD2YzzusEkSlHA/NS9CH+tT2cYXrcpCmUiqlXwtyjuUmbaypuHJD8E2 kmINuM8cdJGuTGXtVz2egdeJ/QApeS4PF/zo1krNx06nqHy8Af+Mkr9FDy0GtqYozKvFpQFKbneV7 aN6opX2Ps8CqxHPC+kd9m7npJmBAW64tDV6bgVYpUyOQ5APd+IY2BKrlN2svO5gm/2swQvrsPbTGv mOcJItZw==; 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 1miElM-0002AE-54 for pgsql-bugs@lists.postgresql.org; Wed, 03 Nov 2021 11:49:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1miElK-0005rN-PA for pgsql-bugs@lists.postgresql.org; Wed, 03 Nov 2021 11:49:02 +0000 Content-Type: multipart/mixed; boundary="===============1239828560507854159==" MIME-Version: 1.0 Subject: BUG #17270: Partitions are not prunned for generic plans when `ANY` construct is used. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: stanislaw.skonieczny@gmail.com Reply-To: stanislaw.skonieczny@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 03 Nov 2021 11:48:12 +0000 Message-ID: <17270-3e62104d1566e7c0@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 --===============1239828560507854159== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzI3MApMb2dnZWQgYnk6ICAgICAgICAgIFN0YW5pc8WCYXcgU2tvbmll Y3pueQpFbWFpbCBhZGRyZXNzOiAgICAgIHN0YW5pc2xhdy5za29uaWVjem55QGdtYWlsLmNvbQpQ b3N0Z3JlU1FMIHZlcnNpb246IDEzLjQKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCA1LjQuMC04 OS1nZW5lcmljICMxMDB+MTguMDQuMS1VYnVudHUKRGVzY3JpcHRpb246ICAgICAgICAKCldlIHJl Y2VudGx5IGhhZCBhIHByb2JsZW0gYXQgYSBjdXN0b21lciBzaXplIHdpdGggdmVyeSBsYXJnZSBC RC4gU29tZXRpbWVzCnF1ZXJpZXMgaXNzdWVkIGZyb20gcGwvcGdTcWwgd2VyZSBzY2FubmluZyBh bGwgaGFzaCBwYXJ0aXRpb25zIGluc3RlYWQgb2YKb25seSBvbmUuIEl0IGxvb2tzIGxpa2UgcGcg aXMgbm90IGFibGUgdG8gZG8gcGFydGl0aW9uIHBydW5pbmcgd2hlbiBnZW5lcmljCnBsYW4gaXMg Y2hvc2VuIGFuZCBwYXJ0aXRpb24gaXMgZ2l2ZW4gdXNpbmcgYFdIRVJFIHBhcnRpdGlvbl9rZXkg PQpBTlkoc29tZV9hcnJheV9vZl9pZHMpYCBjb25kaXRpb24uDQoNCldlIGhhdmUgYmVlbiBhYmxl IHRvIHJlcHJvZHVjZSBpdCBsb2NhbGx5IHVzaW5nIHByZXBhcmVkIHN0YXRlbWVudHMgYW5kCmZv cmNpbmcgYSBnZW5lcmljIHBsYW46DQpgYGANCmNyZWF0ZSB0YWJsZSBrdihrZXkgYmlnaW50IHBy aW1hcnkga2V5LCB2YWx1ZSBiaWdpbnQpIHBhcnRpdGlvbiBieQpoYXNoKGtleSk7DQpDUkVBVEUg VEFCTEUga3ZfcGFydF8wIFBBUlRJVElPTiBPRiBrdiBGT1IgVkFMVUVTIFdJVEggKG1vZHVsdXMg MywgcmVtYWluZGVyCjApOw0KQ1JFQVRFIFRBQkxFIGt2X3BhcnRfMSBQQVJUSVRJT04gT0Yga3Yg Rk9SIFZBTFVFUyBXSVRIIChtb2R1bHVzIDMsIHJlbWFpbmRlcgoxKTsNCkNSRUFURSBUQUJMRSBr dl9wYXJ0XzIgUEFSVElUSU9OIE9GIGt2IEZPUiBWQUxVRVMgV0lUSCAobW9kdWx1cyAzLCByZW1h aW5kZXIKMik7DQoNCmluc2VydCBpbnRvIGt2IHZhbHVlcyAoMCwgMCk7DQppbnNlcnQgaW50byBr diB2YWx1ZXMgKDEsIDEpOw0KaW5zZXJ0IGludG8ga3YgdmFsdWVzICgyLCAyKTsNCmluc2VydCBp bnRvIGt2IHZhbHVlcyAoMywgMyk7DQppbnNlcnQgaW50byBrdiB2YWx1ZXMgKDQsIDQpOw0KaW5z ZXJ0IGludG8ga3YgdmFsdWVzICg1LCA1KTsNCg0KcHJlcGFyZSBxdWVyeV9tYW55KGJpZ2ludFtd KSBhcyBzZWxlY3QgKiBmcm9tIGt2IHdoZXJlIGtleSA9IEFOWSgkMSk7DQoNCnNldCBwbGFuX2Nh Y2hlX21vZGUgdG8gZm9yY2VfZ2VuZXJpY19wbGFuOw0KZXhwbGFpbiBhbmFseXplIGV4ZWN1dGUg cXVlcnlfbWFueShBUlJBWVswXSk7DQpgYGANCg0KT3V0cHV0IG9mIGV4cGxhaW4gYW5hbHl6ZSBp czogDQpgYGANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogQXBwZW5kICAoY29zdD04LjMy Li41Ni43OCByb3dzPTMwIHdpZHRoPTE2KSAoYWN0dWFsIHRpbWU9MC4wNDUuLjAuMDQ4CnJvd3M9 MSBsb29wcz0xKQ0KICAgLT4gIEJpdG1hcCBIZWFwIFNjYW4gb24ga3ZfcGFydF8wIGt2XzEgIChj b3N0PTguMzIuLjE4Ljg4IHJvd3M9MTAKd2lkdGg9MTYpIChhY3R1YWwgdGltZT0wLjAyNS4uMC4w MjYgcm93cz0wIGxvb3BzPTEpDQogICAgICAgICBSZWNoZWNrIENvbmQ6IChrZXkgPSBBTlkgKCQx KSkNCiAgICAgICAgIC0+ICBCaXRtYXAgSW5kZXggU2NhbiBvbiBrdl9wYXJ0XzBfcGtleSAgKGNv c3Q9MC4wMC4uOC4zMiByb3dzPTEwCndpZHRoPTApIChhY3R1YWwgdGltZT0wLjAxOS4uMC4wMTkg cm93cz0wIGxvb3BzPTEpDQogICAgICAgICAgICAgICBJbmRleCBDb25kOiAoa2V5ID0gQU5ZICgk MSkpDQogICAtPiAgQml0bWFwIEhlYXAgU2NhbiBvbiBrdl9wYXJ0XzEga3ZfMiAgKGNvc3Q9OC4z Mi4uMTguODggcm93cz0xMAp3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAuMDA1Li4wLjAwNSByb3dz PTAgbG9vcHM9MSkNCiAgICAgICAgIFJlY2hlY2sgQ29uZDogKGtleSA9IEFOWSAoJDEpKQ0KICAg ICAgICAgLT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIGt2X3BhcnRfMV9wa2V5ICAoY29zdD0wLjAw Li44LjMyIHJvd3M9MTAKd2lkdGg9MCkgKGFjdHVhbCB0aW1lPTAuMDA0Li4wLjAwNCByb3dzPTAg bG9vcHM9MSkNCiAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChrZXkgPSBBTlkgKCQxKSkNCiAg IC0+ICBCaXRtYXAgSGVhcCBTY2FuIG9uIGt2X3BhcnRfMiBrdl8zICAoY29zdD04LjMyLi4xOC44 OCByb3dzPTEwCndpZHRoPTE2KSAoYWN0dWFsIHRpbWU9MC4wMTQuLjAuMDE1IHJvd3M9MSBsb29w cz0xKQ0KICAgICAgICAgUmVjaGVjayBDb25kOiAoa2V5ID0gQU5ZICgkMSkpDQogICAgICAgICBI ZWFwIEJsb2NrczogZXhhY3Q9MQ0KICAgICAgICAgLT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIGt2 X3BhcnRfMl9wa2V5ICAoY29zdD0wLjAwLi44LjMyIHJvd3M9MTAKd2lkdGg9MCkgKGFjdHVhbCB0 aW1lPTAuMDA4Li4wLjAwOCByb3dzPTEgbG9vcHM9MSkNCiAgICAgICAgICAgICAgIEluZGV4IENv bmQ6IChrZXkgPSBBTlkgKCQxKSkNCiBQbGFubmluZyBUaW1lOiAwLjI4MiBtcw0KIEV4ZWN1dGlv biBUaW1lOiAwLjExNSBtcw0KKDE2IHJvd3MpDQpgYGANCkFsbCBwYXJ0aXRpb25zIHdlcmUgc2Nh bm5lZC4NCg0KSG93ZXZlciwgZm9yIGN1c3RvbSBwbGFuIHBhcnRpdGlvbnMgYXJlIHBydW5lZCBj b3JyZWN0bHk6DQpgYGANCnNldCBwbGFuX2NhY2hlX21vZGUgdG8gZm9yY2VfY3VzdG9tX3BsYW47 DQpleHBsYWluIGFuYWx5emUgZXhlY3V0ZSBxdWVyeV9tYW55KEFSUkFZWzBdKTsNCg0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZ IFBMQU4gICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBJbmRleCBTY2FuIHVzaW5nIGt2X3BhcnRfMl9wa2V5IG9u IGt2X3BhcnRfMiBrdiAgKGNvc3Q9MC4wMy4uOC4wNCByb3dzPTEKd2lkdGg9MTYpIChhY3R1YWwg dGltZT0wLjAyMi4uMC4wMjQgcm93cz0xIGxvb3BzPTEpDQogICBJbmRleCBDb25kOiAoa2V5ID0g QU5ZICgnezB9Jzo6YmlnaW50W10pKQ0KIFBsYW5uaW5nIFRpbWU6IDAuMjEzIG1zDQogRXhlY3V0 aW9uIFRpbWU6IDAuMDU1IG1zDQooNCByb3dzKQ0KDQpgYGANCg0KSXQgd29ya3MgYWxzbyB3aGVu IGA9YCBpcyB1c2VkIGluc3RlYWQgb2YgYEFOWWAgZm9yIGdlbmVyaWMgcGxhbjoNCmBgYA0KcHJl cGFyZSBxdWVyeV9vbmUoYmlnaW50KSBhcyBzZWxlY3QgKiBmcm9tIGt2IHdoZXJlIGtleSA9ICQx Ow0Kc2V0IHBsYW5fY2FjaGVfbW9kZSB0byBmb3JjZV9nZW5lcmljX3BsYW47DQpleHBsYWluIGFu YWx5emUgZXhlY3V0ZSBxdWVyeV9vbmUoMCk7DQoNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLQ0KIEFwcGVuZCAgKGNvc3Q9MC4wMy4uMjQuMTQgcm93cz0zIHdpZHRo PTE2KSAoYWN0dWFsIHRpbWU9MC4wMjUuLjAuMDI4IHJvd3M9MQpsb29wcz0xKQ0KICAgU3VicGxh bnMgUmVtb3ZlZDogMg0KICAgLT4gIEluZGV4IFNjYW4gdXNpbmcga3ZfcGFydF8yX3BrZXkgb24g a3ZfcGFydF8yIGt2XzEgIChjb3N0PTAuMDMuLjguMDQKcm93cz0xIHdpZHRoPTE2KSAoYWN0dWFs IHRpbWU9MC4wMjMuLjAuMDI1IHJvd3M9MSBsb29wcz0xKQ0KICAgICAgICAgSW5kZXggQ29uZDog KGtleSA9ICQxKQ0KIFBsYW5uaW5nIFRpbWU6IDAuMjQ0IG1zDQogRXhlY3V0aW9uIFRpbWU6IDAu MDcyIG1zDQooNiByb3dzKQ0KYGBgDQoNCldlIGhhdmUgcmVwcm9kdWNlZCBpdCBvbiAxMy4zLCAx My40IGFuZCAxNC4wLgoK --===============1239828560507854159==--