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 1urqYE-00DOpe-FX for pgsql-committers@arkaria.postgresql.org; Fri, 29 Aug 2025 04:17:23 +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 1urqYD-006NIg-MB for pgsql-committers@arkaria.postgresql.org; Fri, 29 Aug 2025 04:17:22 +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 1urqYD-006NIY-Es for pgsql-committers@lists.postgresql.org; Fri, 29 Aug 2025 04:17:22 +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 1urqYB-002R3n-2O for pgsql-committers@lists.postgresql.org; Fri, 29 Aug 2025 04:17:21 +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=sKOx+lUBWMIdnSaN2VozvsjvIkD8Su+uEtq7lkyxbYc=; b=1P+6WxQvA2wzFRUxKeaYC1Gcw5 7pC2lh98pNUG8R+4sOZteegvdo+t6Uxt18rXgK7oKCPzH0f7wPjoY+bEOYnpzmRmWGJxITjr2Lkcy PcqYwEdO3SI7lmuNGFrb9yVq2Y5FBl0Jy39Zfo/lkWuDJ1lEPoUkCj0xaU1cJPlCDe3vGfSP2kxex xq4ey7AKtE0YRqUNWnnIcHTR+rWJyu8VBUXlYGVbJdyMf8FhMpjTTLTx3pJPsAHQs8m9gYNfF0i4r +Atpb4KpLBT5gRyrkUTgs+hp8vmBJNFGQMknV4Sxt/M1VhZFQCn1fQDMFwb/E2CoUHu2qEnLHzWOe 0xBtPSsw==; 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 1urqYA-006Jk5-4Q for pgsql-committers@lists.postgresql.org; Fri, 29 Aug 2025 04:17:18 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1urqY9-002Alu-1B for pgsql-committers@lists.postgresql.org; Fri, 29 Aug 2025 04:17:17 +0000 Content-Type: multipart/mixed; boundary="===============5955826315351725160==" 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:17:17 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5955826315351725160== 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 Y2twYXRjaC10aHJvdWdoOiAxOAoKQnJhbmNoCi0tLS0tLQpSRUxfMThfU1RBQkxFCgpEZXRhaWxz Ci0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81OGVhMDc0 ZjE0MzNhYmRkNWRlNzkyZTQ3YWU4NGMxZTU2YzI2M2Y5CgpNb2RpZmllZCBGaWxlcwotLS0tLS0t LS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9wYXRobm9kZS5jIHwgIDkgKysrKysr CnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvam9pbi5vdXQgICAgfCA2MCArKysrKysrKysrKysr KysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAg ICAgIHwgMzcgKysrKysrKysrKysrKysrKysrKysrCjMgZmlsZXMgY2hhbmdlZCwgMTA2IGluc2Vy dGlvbnMoKykKCg== --===============5955826315351725160==--