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 1tKc6z-009jdm-IM for pgsql-committers@arkaria.postgresql.org; Mon, 09 Dec 2024 11:39:37 +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 1tKc6x-007YcN-5H for pgsql-committers@arkaria.postgresql.org; Mon, 09 Dec 2024 11:39:36 +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 1tKc6W-007XjZ-06 for pgsql-committers@lists.postgresql.org; Mon, 09 Dec 2024 11:39:09 +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 1tKc6U-001sVO-2b for pgsql-committers@lists.postgresql.org; Mon, 09 Dec 2024 11:39:08 +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=tnPdWYY0VZnUrU+Q4Bp6eZuP6xtGBE+ruLljyHyigjA=; b=ctHVUCIE5QVhMRkC75g3GV0V3u PRh/s/l6p/sK0NYdzNZjkplXuR8JzwiUBZxiRXz6hXHxnTXfTuPJ52VmuzUI9uMi5H2EmC8qtQirB 00YHV0+dbL0b1FTiLORKUh9qEw5jTkbyiqy2JQc6fgWS2vxmATjdor7FMZx0Bz05U9pL+BHPOGdMu rka88fdHDyqCMih9cKxWvpN7N1+FPDkTUfHDdXdHTuAMfgDn+PED446QvsktW5e80XKS+Pt9FPbxi K+DB+o3rXBJusTJPqccRHqD79S9k5fRGBGcmALmyOwWIuSZxRK7aPa4ZP13tNx4dSDzkAm1qFOa5q fyfkviKQ==; 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 1tKc6T-005uAc-46 for pgsql-committers@lists.postgresql.org; Mon, 09 Dec 2024 11:39:05 +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 1tKc6R-001rig-GT for pgsql-committers@lists.postgresql.org; Mon, 09 Dec 2024 11:39:04 +0000 Content-Type: multipart/mixed; boundary="===============1332838440038791807==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix right-semi-joins in HashJoin rescans X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 09 Dec 2024 11:39:04 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1332838440038791807== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJpZ2h0LXNlbWktam9pbnMgaW4gSGFzaEpvaW4gcmVzY2FucwoKV2hlbiByZXNldHRpbmcg YSBIYXNoSm9pbiBub2RlIGZvciByZXNjYW5zLCBpZiBpdCBpcyBhIHNpbmdsZS1iYXRjaApqb2lu IGFuZCB0aGVyZSBhcmUgbm8gcGFyYW1ldGVyIGNoYW5nZXMgZm9yIHRoZSBpbm5lciBzdWJub2Rl LCB3ZSBjYW4KanVzdCByZXVzZSB0aGUgZXhpc3RpbmcgaGFzaCB0YWJsZSB3aXRob3V0IHJlYnVp bGRpbmcgaXQuICBIb3dldmVyLApmb3Igam9pbiB0eXBlcyB0aGF0IGRlcGVuZCBvbiB0aGUgaW5u ZXItdHVwbGUgbWF0Y2ggZmxhZ3MgaW4gdGhlIGhhc2gKdGFibGUsIHdlIG5lZWQgdG8gcmVzZXQg dGhlc2UgbWF0Y2ggZmxhZ3MgdG8gYXZvaWQgaW5jb3JyZWN0IHJlc3VsdHMuClRoaXMgYXBwbGll cyB0byByaWdodCwgcmlnaHQtYW50aSwgcmlnaHQtc2VtaSwgYW5kIGZ1bGwgam9pbnMuCgpXaGVu IEkgaW50cm9kdWNlZCAiUmlnaHQgU2VtaSBKb2luIiBwbGFuIHNoYXBlcyBpbiBhYTg2MTI5ZTEs IEkgZmFpbGVkCnRvIHJlc2V0IHRoZSBtYXRjaCBmbGFncyBpbiB0aGUgaGFzaCB0YWJsZSBmb3Ig cmlnaHQtc2VtaSBqb2lucyBpbgpyZXNjYW5zLiAgVGhpcyBvdmVyc2lnaHQgaGFzIGJlZW4gc2hv d24gdG8gcHJvZHVjZSBpbmNvcnJlY3QgcmVzdWx0cy4KVGhpcyBwYXRjaCBmaXhlcyBpdC4KCkF1 dGhvcjogUmljaGFyZCBHdW8KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU1iV3M0 LW5RRjlpbzJXTDJTa0QwZVh2ZlBkeUJjOVE9aFJ3ZlFIQ0dWMnVzYTBqeUFAbWFpbC5nbWFpbC5j b20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9z dGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81NjY4YTg1N2RlNGYzZjEyMDY2YjJiYmM2MjZiNzdi ZTRmYzk1ZWU1CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9leGVj dXRvci9ub2RlSGFzaGpvaW4uYyB8ICA3ICsrKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv am9pbi5vdXQgIHwgNjMgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMv dGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAgICB8IDMwICsrKysrKysrKysrKysrKysrKwoz IGZpbGVzIGNoYW5nZWQsIDk3IGluc2VydGlvbnMoKyksIDMgZGVsZXRpb25zKC0pCgo= --===============1332838440038791807==--