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.96) (envelope-from ) id 1wB3Zx-000h77-1V for pgsql-committers@arkaria.postgresql.org; Fri, 10 Apr 2026 04:34:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wB3Zv-009Int-2O for pgsql-committers@arkaria.postgresql.org; Fri, 10 Apr 2026 04:34:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wB3Zv-009InR-1e for pgsql-committers@lists.postgresql.org; Fri, 10 Apr 2026 04:34:48 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wB3Zu-00000000H1D-13Qh for pgsql-committers@lists.postgresql.org; Fri, 10 Apr 2026 04:34:47 +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=YQk3CtDU7G4AOBCCz/M8d2xz9wbNjTalt5oyulUUFio=; b=jcHC2h2TyyRStVCrdIazpa6d+M YA3IH2eDoCD5Ofnoat5iyTT4DEX2FOJ6Nad+7fa86s/k+1fqMi2ek7YnQ8Ct8ZRGQTZD6af+sFT6b wSzEhuHR4bSM3OFepI4CEBy/D/H3lFKZulX2WpuftN1i+s3EqpNA6NRtGKhscRF4+XdYdXWCFZNJ2 ARKYDK3J3Xq0s//U7iZ6D7q4rGI+UF0stPiW3XpqWvn7UcFLK45JiKEbtnGxnpVFyrdoAIaDUeQy8 r4Yz0oSG9Sclt4wTcsOmc3uALJVmpriHiy5IMOXjX24GtnHRcqBeG161qxzFWFDO19xAxRt19jdNg kK8ps0hA==; 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.96) (envelope-from ) id 1wB3Zt-000m5y-2z for pgsql-committers@lists.postgresql.org; Fri, 10 Apr 2026 04:34:46 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wB3Zt-000FIn-2G for pgsql-committers@lists.postgresql.org; Fri, 10 Apr 2026 04:34:46 +0000 Content-Type: multipart/mixed; boundary="===============7757158625031363561==" MIME-Version: 1.0 From: Amit Langote To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix FK fast-path scan key ordering for mismatched column order X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 10 Apr 2026 04:34:46 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7757158625031363561== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IEZLIGZhc3QtcGF0aCBzY2FuIGtleSBvcmRlcmluZyBmb3IgbWlzbWF0Y2hlZCBjb2x1bW4g b3JkZXIKClRoZSBmYXN0LXBhdGggZm9yZWlnbiBrZXkgY2hlY2sgaW50cm9kdWNlZCBpbiAyZGE4 NmMxZWY5YiBhc3N1bWVkIHRoYXQKY29uc3RyYWludCBrZXkgcG9zaXRpb25zIGRpcmVjdGx5IGNv cnJlc3BvbmQgdG8gaW5kZXggY29sdW1uIHBvc2l0aW9ucy4KVGhpcyBpcyBub3QgYWx3YXlzIHRy dWUgYXMgYSBGSyBjb25zdHJhaW50IGNhbiByZWZlcmVuY2UgUEsgY29sdW1ucyBpbiBhCmRpZmZl cmVudCBvcmRlciB0aGFuIHRoZXkgYXBwZWFyIGluIHRoZSBQSydzIHVuaXF1ZSBpbmRleC4KCkZv ciBleGFtcGxlLCBpZiB0aGUgUEsgaXMgKGEsIGIsIGMpIGFuZCB0aGUgRksgcmVmZXJlbmNlcyB0 aGVtIGFzCihhLCBjLCBiKSwgdGhlIGNvbnN0cmFpbnQgc3RvcmVzIGtleXMgaW4gdGhlIEZLLXNw ZWNpZmllZCBvcmRlciwgYnV0CnRoZSBpbmRleCBoYXMgY29sdW1ucyBpbiBQSyBvcmRlci4gVGhl IGJ1Z2d5IGNvZGUgdXNlZCB0aGUgY29uc3RyYWludAprZXkgaW5kZXggdG8gYWNjZXNzIHJkX29w ZmFtaWx5W2ldLCB3aGljaCByZXRyaWV2ZWQgdGhlIHdyb25nIG9wZXJhdG9yCmZhbWlseSB3aGVu IGNvbHVtbnMgd2VyZSByZW9yZGVyZWQsIGNhdXNpbmcgIm9wZXJhdG9yIFggaXMgbm90IGEgbWVt YmVyCm9mIG9wZmFtaWx5IFkiIGVycm9ycy4KCkFmdGVyIGZpeGluZyB0aGUgb3BmYW1pbHkgbG9v a3VwLCBhIHNlY29uZCBpc3N1ZSBzdGFydGVkIHRvIGhhcHBlbjoKYnRyZWUgaW5kZXggc2NhbnMg cmVxdWlyZSBzY2FuIGtleXMgdG8gYmUgb3JkZXJlZCBieSBhdHRyaWJ1dGUgbnVtYmVyLgpUaGUg Y29kZSB3YXMgcGxhY2luZyBzY2FuIGtleXMgYXQgYXJyYXkgcG9zaXRpb24gaSB3aXRoIGF0dHJp YnV0ZSBudW1iZXIKaWR4X2F0dG5vLCBwcm9kdWNpbmcgb3V0LW9mLW9yZGVyIGtleXMgd2hlbiBj b2x1bW5zIHdlcmUgc3dhcHBlZC4gVGhpcwpjYXVzZWQgImJ0cmVlIGluZGV4IGtleXMgbXVzdCBi ZSBvcmRlcmVkIGJ5IGF0dHJpYnV0ZSIgZXJyb3JzLgoKVGhlIGZpeCBhZGRzIGFuIGluZGV4X2F0 dG5vcyBhcnJheSB0byBGYXN0UGF0aE1ldGEgdGhhdCBtYXBzIGVhY2gKY29uc3RyYWludCBrZXkg cG9zaXRpb24gdG8gaXRzIGNvcnJlc3BvbmRpbmcgaW5kZXggY29sdW1uIHBvc2l0aW9uLgpJbiBy aV9wb3B1bGF0ZV9mYXN0cGF0aF9tZXRhZGF0YSgpLCB3ZSBzZWFyY2ggaW5ka2V5IHRvIGZpbmQg dGhlIGFjdHVhbAppbmRleCBjb2x1bW4gZm9yIGVhY2ggcGtfYXR0bnVtc1tpXSBhbmQgdXNlIHRo YXQgcG9zaXRpb24gZm9yIHRoZQpvcGZhbWlseSBsb29rdXAuIEluIGJ1aWxkX2luZGV4X3NjYW5r ZXlzKCksIHdlIHBsYWNlIGVhY2ggc2NhbiBrZXkgYXQKdGhlIGFycmF5IHBvc2l0aW9uIGNvcnJl c3BvbmRpbmcgdG8gaXRzIGluZGV4IGNvbHVtbgooc2tleXNbaWR4X2F0dG5vLTFdKSByYXRoZXIg dGhhbiBhdCB0aGUgY29uc3RyYWludCBrZXkgcG9zaXRpb24sCmVuc3VyaW5nIHNjYW4ga2V5cyBh cmUgcHJvcGVybHkgb3JkZXJlZCBieSBhdHRyaWJ1dGUgbnVtYmVyIGFzIGJ0cmVlCnJlcXVpcmVz LgoKUmVwb3J0ZWQtYnk6IEZyZWRyaWsgV2lkbGVydCA8ZnJlZHJpay53aWRsZXJ0QGRpZ3Byby5z ZT4KQXV0aG9yOiBNYXRoZXVzIEFsY2FudGFyYSA8bWF0aGV1c3NzaWx2OTdAZ21haWwuY29tPgpS ZXZpZXdlZC1ieTogSnVud2FuZyBaaGFvIDx6aGp3cGt1QGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjog aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9DQURmaFNyLXBDa2JEeG1pT1ZZ U0FHRTVRR2pzUTQ4S0tIX1c0MjRTUGslMkJwd3pLWkZhUSU0MG1haWwuZ21haWwuY29tCgpCcmFu Y2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwu b3JnL3BnL2NvbW1pdGRpZmYvOTgwYzFhODVkODE5ZWRjNzJjODY2MDAxYjljYTRmYmE0NTQ5MDBm ZQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3Jp X3RyaWdnZXJzLmMgICAgICAgfCA0MCArKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tCnNy Yy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZm9yZWlnbl9rZXkub3V0IHwgMTkgKysrKysrKysrKysr KysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2ZvcmVpZ25fa2V5LnNxbCAgICAgIHwgMTggKysrKysr KysrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCA3MCBpbnNlcnRpb25zKCspLCA3IGRlbGV0aW9ucygt KQoK --===============7757158625031363561==--