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 1urqVh-00DO6d-TA for pgsql-committers@arkaria.postgresql.org; Fri, 29 Aug 2025 04:14:47 +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 1urqVh-006Mdy-85 for pgsql-committers@arkaria.postgresql.org; Fri, 29 Aug 2025 04:14:45 +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 1urqVh-006Mdp-0R for pgsql-committers@lists.postgresql.org; Fri, 29 Aug 2025 04:14:45 +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.96) (envelope-from ) id 1urqVe-002R1w-2W for pgsql-committers@lists.postgresql.org; Fri, 29 Aug 2025 04:14:45 +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=jiQTYgx4WH6MuZT9xLxcsGEJBdy+rlMzA4z0agfPSqY=; b=RStc6rR9Ti6cs3LpzdSovn9Te6 YO2LTpszUMk2fQIe+QYdhXy6zdXQxFvOytAyJsKLe45OoMrSUYkKg3f51+axzCZ5XHOEeRk1b/VdI rzNHPNh53HKC4VncIhBOQ2PtpZ3z0Fje0gLWq7WVWTukfCFQHt7i3UUTpTRQjeUQ3/UZBL5v3T+5W 5mklLOZq1CbIs0FkxxPnQR7ZH4hDEdyvFM/7QZezNiIfo/jXY4OK551RJFY5CyCkYJlUTAaZlgvbQ Vb1UKvGQ/gdU4AdMrMwm0i7/LGARDKArGD6MoKwrlclCaISTarLcnR4m1LR/BCqisjxQlgdBp1NHL uppHXjGQ==; 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 1urqVd-006Jg5-CT for pgsql-committers@lists.postgresql.org; Fri, 29 Aug 2025 04:14:41 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1urqVb-002Aki-2w for pgsql-committers@lists.postgresql.org; Fri, 29 Aug 2025 04:14:40 +0000 Content-Type: multipart/mixed; boundary="===============6531004017819301475==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix semijoin unique-ification for child relations X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 29 Aug 2025 04:14:40 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6531004017819301475== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHNlbWlqb2luIHVuaXF1ZS1pZmljYXRpb24gZm9yIGNoaWxkIHJlbGF0aW9ucwoKRm9yIGEg Y2hpbGQgcmVsYXRpb24sIHdlIHNob3VsZCBub3QgYXNzdW1lIHRoYXQgaXRzIHBhcmVudCdzCnVu aXF1ZS1pZmllZCByZWxhdGlvbiAob3IgdW5pcXVlLWlmaWVkIHBhdGggaW4gdjE4KSBhbHdheXMg ZXhpc3RzLiAgSW4KY2FzZXMgd2hlcmUgYWxsIFJIUyBjb2x1bW5zIHRoYXQgbmVlZCB0byBiZSB1 bmlxdWUtaWZpZWQgYXJlIGVxdWF0ZWQKdG8gY29uc3RhbnRzLCB0aGUgdW5pcXVlLWlmaWVkIHJl bGF0aW9uL3BhdGggZm9yIHRoZSBwYXJlbnQgdGFibGUgaXMKbm90IGJ1aWx0LCBhcyB0aGVyZSBh cmUgbm8gY29sdW1ucyBsZWZ0IHRvIHVuaXF1ZS1pZnkuICBGYWlsaW5nIHRvCmFjY291bnQgZm9y IHRoaXMgY2FuIHJlc3VsdCBpbiBhIFNJR1NFR1YgY3Jhc2ggZHVyaW5nIHBsYW5uaW5nLgoKVGhp cyBwYXRjaCBjaGVja3Mgd2hldGhlciB0aGUgcGFyZW50J3MgdW5pcXVlLWlmaWVkIHJlbGF0aW9u IG9yIHBhdGgKZXhpc3RzIGFuZCBza2lwcyB1bmlxdWUtaWZpY2F0aW9uIG9mIHRoZSBjaGlsZCBy ZWxhdGlvbiBpZiBpdCBkb2VzCm5vdC4KCkF1dGhvcjogUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51 eEBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FNYldzNDlNT2RM VzJjK3FiTEhIQnQ4VkJ1PTRPTnBNOTFEMTk9QVdlVzkzZUZVRjZBQG1haWwuZ21haWwuY29tCkJh Y2twYXRjaC10aHJvdWdoOiAxOAoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzk3YjBmMzZiZGU5YTA4 YmM2ZjAwNDQzOGZmOGZjMGFmYmNiNDE4YzAKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyB8ICA5ICsrKysrKwpzcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4ub3V0ICAgfCA2MCArKysrKysrKysrKysrKysrKysrKysr KysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvam9pbi5zcWwgICAgICAgIHwgMzcg KysrKysrKysrKysrKysrKysrKysrKwozIGZpbGVzIGNoYW5nZWQsIDEwNiBpbnNlcnRpb25zKCsp Cgo= --===============6531004017819301475==--