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 1sYgml-00DLVR-Cf for pgsql-committers@arkaria.postgresql.org; Tue, 30 Jul 2024 06:56:39 +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 1sYgmk-006dno-0X for pgsql-committers@arkaria.postgresql.org; Tue, 30 Jul 2024 06:56:38 +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 1sYgkA-006bzk-EI for pgsql-committers@lists.postgresql.org; Tue, 30 Jul 2024 06:53:58 +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 1sYgk7-002CXB-CW for pgsql-committers@lists.postgresql.org; Tue, 30 Jul 2024 06:53:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=eqnTpxQujiXQxSdGfTvftbsQcowlOmfSjoMvd5Srju8=; b=bv3CMFF1zj4geeb0JRrRtYxHFx EzIxT0UtMOaNPYfZ/toBnbGbs8bFHfA7qwcAUtyt6BHQeQYHt8OiiQNtwsoz8bSf3SY34VrhubJfL ZDTScCQIYVMJ58hA6utnkV8X6LWXhe2ZfpfS2J4KOr85SOxlgE+6zWBSdxCxMk3d+3BUvAWrWmwow aJfKt7l5kfRFkjvCUspY/WPtWnHJfRdhva0+lC0J54b9erc4xUb6dgjgw0z75Lffdee6gXqNfkYMM Rae5NXS2Ovapg41zyDZWnEec9fLQ6GAoVeIjAvTVsAszgphjc4lOw42xTDLklOKg7LVxAHIFl/Rdd X7flaL/g==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYgk5-006mQP-S2 for pgsql-committers@lists.postgresql.org; Tue, 30 Jul 2024 06:53:53 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sYgk5-001rAN-3l for pgsql-committers@lists.postgresql.org; Tue, 30 Jul 2024 06:53:53 +0000 Content-Type: multipart/mixed; boundary="===============2819666765792864387==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix partitionwise join with partially-redundant join clauses X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 30 Jul 2024 06:53:53 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2819666765792864387== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBhcnRpdGlvbndpc2Ugam9pbiB3aXRoIHBhcnRpYWxseS1yZWR1bmRhbnQgam9pbiBjbGF1 c2VzCgpUbyBkZXRlcm1pbmUgaWYgdGhlIHR3byByZWxhdGlvbnMgYmVpbmcgam9pbmVkIGNhbiB1 c2UgcGFydGl0aW9ud2lzZQpqb2luLCB3ZSBuZWVkIHRvIHZlcmlmeSB0aGUgZXhpc3RlbmNlIG9m IGVxdWktam9pbiBjb25kaXRpb25zCmludm9sdmluZyBwYWlycyBvZiBtYXRjaGluZyBwYXJ0aXRp b24ga2V5cyBmb3IgYWxsIHBhcnRpdGlvbiBrZXlzLgpDdXJyZW50bHkgd2UgZG8gdGhhdCBieSBs b29raW5nIHRocm91Z2ggdGhlIGpvaW4ncyByZXN0cmljdGlvbgpjbGF1c2VzLiAgSG93ZXZlciwg aXQgaGFzIGJlZW4gZGlzY292ZXJlZCB0aGF0IHRoaXMgYXBwcm9hY2ggaXMKaW5zdWZmaWNpZW50 LCBiZWNhdXNlIHRoZXJlIG1pZ2h0IGJlIHBhcnRpdGlvbiBrZXlzIGtub3duIGVxdWFsIGJ5IGEK c3BlY2lmaWMgRUMsIGJ1dCB0aGV5IGRvIG5vdCBmb3JtIGEgam9pbiBjbGF1c2UgYmVjYXVzZSBp dCBoYXBwZW5zCnRoYXQgb3RoZXIgbWVtYmVycyBvZiB0aGUgRUMgdGhhbiB0aGUgcGFydGl0aW9u IGtleXMgYXJlIGNvbnN0cmFpbmVkCnRvIGJlY29tZSBhIGpvaW4gY2xhdXNlLgoKVG8gYWRkcmVz cyB0aGlzIGlzc3VlLCBpbiBhZGRpdGlvbiB0byBleGFtaW5pbmcgdGhlIGpvaW4ncyByZXN0cmlj dGlvbgpjbGF1c2VzLCB3ZSBhbHNvIGNoZWNrIGlmIGFueSBwYXJ0aXRpb24ga2V5cyBhcmUga25v d24gZXF1YWwgYnkgRUNzLApieSBsZXZlcmFnaW5nIGZ1bmN0aW9uIGV4cHJzX2tub3duX2VxdWFs KCkuICBUbyBhY2NvbXBsaXNoIHRoaXMsIHdlCmVuaGFuY2UgZXhwcnNfa25vd25fZXF1YWwoKSB0 byBjaGVjayBlcXVhbGl0eSBwZXIgdGhlIHNlbWFudGljcyBvZiB0aGUKb3BmYW1pbHksIGlmIHBy b3ZpZGVkLgoKSXQgY291bGQgYmUgYXJndWVkIHRoYXQgZXhwcnNfa25vd25fZXF1YWwoKSBjb3Vs ZCBiZSBjYWxsZWQgTyhOXjIpCnRpbWVzLCB3aGVyZSBOIGlzIHRoZSBudW1iZXIgb2YgcGFydGl0 aW9uIGtleSBleHByZXNzaW9ucywgcmVzdWx0aW5nCmluIG5vdGljZWFibGUgcGVyZm9ybWFuY2Ug Y29zdHMgaWYgdGhlcmUgYXJlIGEgbG90IG9mIHBhcnRpdGlvbiBrZXkKZXhwcmVzc2lvbnMuICBC dXQgSSB0aGluayB0aGlzIGlzIG5vdCBhIHByb2JsZW0uICBUaGUgbnVtYmVyIG9mIGEKam9pbnJl bCdzIHBhcnRpdGlvbiBrZXkgZXhwcmVzc2lvbnMgd291bGQgb25seSBiZSBlcXVhbCB0byB0aGUg am9pbgpkZWdyZWUsIHNpbmNlIGVhY2ggYmFzZSByZWxhdGlvbiB3aXRoaW4gdGhlIGpvaW4gY29u dHJpYnV0ZXMgb25seSBvbmUKcGFydGl0aW9uIGtleSBleHByZXNzaW9uLiAgVGhhdCBpcyB0byBz YXksIGl0IGRvZXMgbm90IHNjYWxlIHdpdGggdGhlCm51bWJlciBvZiBwYXJ0aXRpb25zLiAgQSBi ZW5jaG1hcmsgd2l0aCBhIHF1ZXJ5IGludm9sdmluZyA1LXdheSBqb2lucwpvZiBwYXJ0aXRpb25l ZCB0YWJsZXMsIGVhY2ggd2l0aCAzIHBhcnRpdGlvbiBrZXlzIGFuZCAxMDAwIHBhcnRpdGlvbnMs CnNob3dzIHRoYXQgdGhlIHBsYW5uaW5nIHRpbWUgaXMgbm90IHNpZ25pZmljYW50bHkgYWZmZWN0 ZWQgYnkgdGhpcwpwYXRjaCAod2l0aGluIHRoZSBtYXJnaW4gb2YgZXJyb3IpLCBwYXJ0aWN1bGFy bHkgd2hlbiBjb21wYXJlZCB0byB0aGUKaW1wYWN0IGNhdXNlZCBieSBwYXJ0aXRpb253aXNlIGpv aW4uCgpUaGFua3MgdG8gVG9tIExhbmUgZm9yIHRoZSBpZGVhIG9mIGxldmVyYWdpbmcgZXhwcnNf a25vd25fZXF1YWwoKSB0bwpjaGVjayBpZiBwYXJ0aXRpb24ga2V5cyBhcmUga25vd24gZXF1YWwg YnkgRUNzLgoKQXV0aG9yOiBSaWNoYXJkIEd1bywgVG9tIExhbmUKUmV2aWV3ZWQtYnk6IFRvbSBM YW5lLCBBc2h1dG9zaCBCYXBhdCwgUm9iZXJ0IEhhYXMKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS9DQU5fOUpUem9fMkY1ZEtMcVhWdERYNVY2ZHdxQjBYaytpaHN0cEtFdDNhMUxUNlg3 OEFAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0K aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85YjI4MmE5MzU5YTEyODMx YzA4N2ViYTdmMGY1ZjBiMWRiYTdiN2ViCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpz cmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9lcXVpdmNsYXNzLmMgICAgICB8ICAyNiArKysrKy0t CnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3JlbG5vZGUuYyAgICAgICAgIHwgMTAzICsrKysr KysrKysrKysrKysrKysrKysrKy0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvc2VsZnVuY3MuYyAg ICAgICAgICAgICB8ICAgNSArLQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcGF0aHMuaCAgICAgICAg ICAgICAgICB8ICAgMyArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3BhcnRpdGlvbl9qb2lu Lm91dCB8ICA4OCArKysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9w YXJ0aXRpb25fam9pbi5zcWwgICAgICB8ICAxMCArKysKNiBmaWxlcyBjaGFuZ2VkLCAyMTQgaW5z ZXJ0aW9ucygrKSwgMjEgZGVsZXRpb25zKC0pCgo= --===============2819666765792864387==--