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 1v8Hd4-00FgaN-Sf for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Oct 2025 12:26:19 +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 1v8Hd2-005iam-2B for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Oct 2025 12:26:16 +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.94.2) (envelope-from ) id 1v8HW7-005fwU-5Z for pgsql-bugs@lists.postgresql.org; Mon, 13 Oct 2025 12:19:08 +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.96) (envelope-from ) id 1v8HW5-001WTP-2w for pgsql-bugs@lists.postgresql.org; Mon, 13 Oct 2025 12:19:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=3gi+h7nEEwdWDJIf67onVChIWeCQADshZ8GbD/sxxLk=; b=orOO+aJ3KoSbSZLbYYYTkhA8KD hrjNftO9RZ10MyCR01Mn59LlHpOx0yPaa/o6Slp1dIN4Fz+pKXTBdfoP3CJpD5LsRjG/WopBELAc0 Efc7Ycx2g8FmUGYDClxqemKPyAo1QldfclW4g0nt61vqgJAt3jv00MApLREgwIZBJxBvytNSjK/NY zjPx8unEiCb7m8Y9vA7BypmWca57sfWIssfUBwLXRBcALkO6aQp/TNu2C3knqxTfT+NyvsBDqZO4L ypBnJoaufeRhktliUt8xaqiJEOFirxLss2CxSLwBAmY188VisIvUQvaRNXQ/xOZnrNVZ6BD8xq+WP eT5Y1ZSg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8HW4-004DV0-0T for pgsql-bugs@lists.postgresql.org; Mon, 13 Oct 2025 12:19:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v8HW2-00FPtr-1P for pgsql-bugs@lists.postgresql.org; Mon, 13 Oct 2025 12:19:02 +0000 Content-Type: multipart/mixed; boundary="===============7010605195646518551==" MIME-Version: 1.0 Subject: BUG #19083: Foreign inner join is the case for char() keys but not for varchar() To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: a.ratundalov@postgrespro.ru Reply-To: a.ratundalov@postgrespro.ru, pgsql-bugs@lists.postgresql.org Date: Mon, 13 Oct 2025 12:18:21 +0000 Message-ID: <19083-5aed88a42f75bbe6@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7010605195646518551== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA4MwpMb2dnZWQgYnk6ICAgICAgICAgIEFudG9uIFJhdHVuZGFsb3YK RW1haWwgYWRkcmVzczogICAgICBhLnJhdHVuZGFsb3ZAcG9zdGdyZXNwcm8ucnUKUG9zdGdyZVNR TCB2ZXJzaW9uOiAxOC4wCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIDYuMS4xNDgtMSAoMjAy NS0wOC0yNikgeDg2XzY0IEdOVS9MaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKRERMIDoKClx1 bnNldCA6ZGF0YWJhc2UKXHVuc2V0IDp1c2VyClx1bnNldCA6aG9zdApcdW5zZXQgOnBvcnQKClNF TEVDVCBjdXJyZW50X2RhdGFiYXNlKCkgQVMgZGF0YWJhc2UgXGdzZXQKU0VMRUNUIGN1cnJlbnRf dXNlciBBUyBVU0VSIFxnc2V0ClxzZXQgaG9zdCBsb2NhbGhvc3QKU0VMRUNUIHNldHRpbmcgQVMg cG9ydCBGUk9NIHBnX3NldHRpbmdzIFdIRVJFIG5hbWU9J3BvcnQnIFxnc2V0CgpDUkVBVEUgZXh0 ZW5zaW9uIHBvc3RncmVzX2ZkdzsKCkNSRUFURSBzZXJ2ZXIgZl9zcnYgRk9SRUlHTiBkYXRhIHdy YXBwZXIgcG9zdGdyZXNfZmR3IG9wdGlvbnMgKGhvc3QgOidob3N0JywKcG9ydCA6J3BvcnQnLCBk Ym5hbWUgOidkYXRhYmFzZScpOwpDUkVBVEUgVVNFUiBtYXBwaW5nIEZPUiA6dXNlciBzZXJ2ZXIg Zl9zcnYgb3B0aW9ucyAoVVNFUiA6J3VzZXInKTsKCkNSRUFURSBUQUJMRSB0YzEgKGEgaW50LCBi IGludCwgYyBjaGFyKDQwKSkgcGFydGl0aW9uIGJ5IGhhc2goYyk7CkNSRUFURSBUQUJMRSB0YzFf ZnQgKGEgaW50LCBiIGludCwgYyBjaGFyKDQwKSk7CkNSRUFURSBUQUJMRSB0YzFfcDEgcGFydGl0 aW9uIG9mIHRjMSBGT1IgdmFsdWVzIFdJVEggKG1vZHVsdXMgMiwgcmVtYWluZGVyCjApOwpDUkVB VEUgRk9SRUlHTiBUQUJMRSB0YzFfcDIgcGFydGl0aW9uIG9mIHRjMSBGT1IgdmFsdWVzIFdJVEgg KG1vZHVsdXMgMiwKcmVtYWluZGVyIDEpIHNlcnZlciBmX3NydiBvcHRpb25zICh0YWJsZV9uYW1l ICd0YzFfZnQnKTsKCgpDUkVBVEUgVEFCTEUgdGMyIChhIGludCwgYiBpbnQsIGMgY2hhcig0MCkp IHBhcnRpdGlvbiBieSBoYXNoKGMpOwpDUkVBVEUgVEFCTEUgdGMyX2Z0IChhIGludCwgYiBpbnQs IGMgY2hhcig0MCkpOwpDUkVBVEUgVEFCTEUgdGMyX3AxIHBhcnRpdGlvbiBvZiB0YzIgRk9SIHZh bHVlcyBXSVRIIChtb2R1bHVzIDIsIHJlbWFpbmRlcgowKTsKQ1JFQVRFIEZPUkVJR04gVEFCTEUg dGMyX3AyIHBhcnRpdGlvbiBvZiB0YzIgRk9SIHZhbHVlcyBXSVRIIChtb2R1bHVzIDIsCnJlbWFp bmRlciAxKSBzZXJ2ZXIgZl9zcnYgb3B0aW9ucyAodGFibGVfbmFtZSAndGMyX2Z0Jyk7CgoKQ1JF QVRFIFRBQkxFIHR2MSAoYSBpbnQsIGIgaW50LCBjIHZhcmNoYXIoNDApKSBwYXJ0aXRpb24gYnkg aGFzaChjKTsKQ1JFQVRFIFRBQkxFIHR2MV9mdCAoYSBpbnQsIGIgaW50LCBjIHZhcmNoYXIoNDAp KTsKQ1JFQVRFIFRBQkxFIHR2MV9wMSBwYXJ0aXRpb24gb2YgdHYxIEZPUiB2YWx1ZXMgV0lUSCAo bW9kdWx1cyAyLCByZW1haW5kZXIKMCk7CkNSRUFURSBGT1JFSUdOIFRBQkxFIHR2MV9wMiBwYXJ0 aXRpb24gb2YgdHYxIEZPUiB2YWx1ZXMgV0lUSCAobW9kdWx1cyAyLApyZW1haW5kZXIgMSkgc2Vy dmVyIGZfc3J2IG9wdGlvbnMgKHRhYmxlX25hbWUgJ3R2MV9mdCcpOwoKCkNSRUFURSBUQUJMRSB0 djIgKGEgaW50LCBiIGludCwgYyB2YXJjaGFyKDQwKSkgcGFydGl0aW9uIGJ5IGhhc2goYyk7CkNS RUFURSBUQUJMRSB0djJfZnQgKGEgaW50LCBiIGludCwgYyB2YXJjaGFyKDQwKSk7CkNSRUFURSBU QUJMRSB0djJfcDEgcGFydGl0aW9uIG9mIHR2MiBGT1IgdmFsdWVzIFdJVEggKG1vZHVsdXMgMiwg cmVtYWluZGVyCjApOwpDUkVBVEUgRk9SRUlHTiBUQUJMRSB0djJfcDIgcGFydGl0aW9uIG9mIHR2 MiBGT1IgdmFsdWVzIFdJVEggKG1vZHVsdXMgMiwKcmVtYWluZGVyIDEpIHNlcnZlciBmX3NydiBv cHRpb25zICh0YWJsZV9uYW1lICd0djJfZnQnKTsKCnNldCBlbmFibGVfcGFydGl0aW9ud2lzZV9q b2luIFRPIE9OOwoKUExBTlMgOgoKRVhQTEFJTihWRVJCT1NFLCBDT1NUUyBPRkYpIFNFTEVDVCB0 YzEuYSwgdGMyLmEgRlJPTSB0YzEgSk9JTiB0YzIgT04gdGMxLmMgPQp0YzIuYyBXSEVSRSB0YzEu Yz0nMDAwMic7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIFFVRVJZIFBMQU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogRm9yZWlnbiBTY2FuCiAg IE91dHB1dDogdGMxLmEsIHRjMi5hCiAgIFJlbGF0aW9uczogKHB1YmxpYy50YzFfcDIgdGMxKSBJ Tk5FUiBKT0lOIChwdWJsaWMudGMyX3AyIHRjMikKICAgUmVtb3RlIFNRTDogU0VMRUNUIHI0LmEs IHI1LmEgRlJPTSAocHVibGljLnRjMV9mdCByNCBJTk5FUiBKT0lOCnB1YmxpYy50YzJfZnQgcjUg T04gKCgocjUuYyA9ICcwMDAyJykpIEFORCAoKHI0LmMgPSAnMDAwMicpKSkpCig0IHJvd3MpCgoK RVhQTEFJTihWRVJCT1NFLCBDT1NUUyBPRkYpIFNFTEVDVCB0djEuYSwgdHYyLmEgRlJPTSB0djEg Sk9JTiB0djIgT04gdHYxLmMgPQp0djIuYyBXSEVSRSB0djEuYz0nMDAwMic7CiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0K IE5lc3RlZCBMb29wCiAgIE91dHB1dDogdHYxLmEsIHR2Mi5hCiAgIC0+ICBGb3JlaWduIFNjYW4g b24gcHVibGljLnR2MV9wMiB0djEKICAgICAgICAgT3V0cHV0OiB0djEuYSwgdHYxLmMKICAgICAg ICAgUmVtb3RlIFNRTDogU0VMRUNUIGEsIGMgRlJPTSBwdWJsaWMudHYxX2Z0IFdIRVJFICgoYyA9 ICcwMDAyJykpCiAgIC0+ICBNYXRlcmlhbGl6ZQogICAgICAgICBPdXRwdXQ6IHR2Mi5hLCB0djIu YwogICAgICAgICAtPiAgRm9yZWlnbiBTY2FuIG9uIHB1YmxpYy50djJfcDIgdHYyCiAgICAgICAg ICAgICAgIE91dHB1dDogdHYyLmEsIHR2Mi5jCiAgICAgICAgICAgICAgIFJlbW90ZSBTUUw6IFNF TEVDVCBhLCBjIEZST00gcHVibGljLnR2Ml9mdCBXSEVSRSAoKGMgPQonMDAwMicpKQooMTAgcm93 cykKCgpJbiB0aGUgc2Vjb25kIGNhc2UgZm9yZWlnbiBqb2luIHBhdGggaXMgbm90IGNvbnNpZGVy ZWQgYmVjYXVzZQpoYXZlX3BhcnRrZXlfZXF1aV9qb2luIHJldHVybnMgZmFsc2UgaW4gY29udHJh c3QgdG8gdGhlIGZpcnN0IGNhc2UuICBUaGlzCmRpZmZlcmVuY2UgaXMgZGV0ZXJtaW5lZCBieSBk aWZmZXJlbnQgZXF1aXZhbGVuY2UgY2xhc3NlcyBleHByc19rbm93bl9lcXVhbAooIGNhbGxlZCBi eSB0aGUgaGF2ZV9wYXJ0a2V5X2VxdWlfam9pbiApIG9wZXJhdGVzLiBJbiB0aGUgZmlyc3QgY2Fz ZSBpdCdzCihUX1ZhciwgVF9WYXIsIFRfQ29uc3QpIHdoaWxlIGluIHRoZSBzZWNvbmQgKFRfUmVs YWJlbFR5cGUsIFRfUmVsYWJlbFR5cGUsClRfQ29uc3QpLgoKUHJvcG9zZWQgZml4IGlzIHRvIHJl bW92ZSBhbnkgcmVsYWJlbCBkZWNvcmF0aW9ucyAoIGxpa2UgaXQncyBkb25lCm1hdGNoX2V4cHJf dG9fcGFydGl0aW9uX2tleXMgKSBpbnNpZGUgZXhwcnNfa25vd25fZXF1YWwuCgo= --===============7010605195646518551==--