Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHN56-0003D6-91 for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Mar 2021 08:42:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lHN54-0007Gk-AV for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Mar 2021 08:42:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHN54-0007Gd-3j for pgsql-hackers@lists.postgresql.org; Wed, 03 Mar 2021 08:42:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHN52-00036C-AQ for pgsql-hackers@lists.postgresql.org; Wed, 03 Mar 2021 08:42:05 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHN50-0004tX-IK for pgsql-hackers@lists.postgresql.org; Wed, 03 Mar 2021 08:42:02 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lHN4z-0003qR-Ux for pgsql-hackers@lists.postgresql.org; Wed, 03 Mar 2021 08:42:01 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails To: pgsql-hackers@lists.postgresql.org From: Neil Chen Cc: Tom Lane Date: Wed, 03 Mar 2021 08:41:49 +0000 User-Agent: pgcommitfest X-cfsender: carpenter.nail.cz.gmail.com In-Reply-To: <422379.1612684550@sss.pgh.pa.us> References: <16583-4dc8f6c3b8ed24fa@postgresql.org> <422379.1612684550@sss.pgh.pa.us> Message-ID: <161476090989.29967.7097745522340560681.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgdGVzdGVkLCBwYXNzZWQK SW1wbGVtZW50cyBmZWF0dXJlOiAgICAgICB0ZXN0ZWQsIHBhc3NlZApTcGVjIGNvbXBsaWFudDog ICAgICAgICAgIG5vdCB0ZXN0ZWQKRG9jdW1lbnRhdGlvbjogICAgICAgICAgICB0ZXN0ZWQsIHBh c3NlZAoKR3JlZXRpbmdzLCANCkkgbGVhcm5lZCBhYm91dCB0aGUgcGF0Y2ggYW5kIHJlYWQgeW91 ciBkaXNjdXNzaW9ucy4gSSdtIG5vdCBzdXJlIHdoeSB0aGlzIHBhdGNoIGhhcyBub3QgYmVlbiBk aXNjdXNzZWQgbm93LiBJbiBzaG9ydCwgSSB0aGluayBpdCdzIGJlbmVmaWNpYWwgdG8gc3VibWl0 IGl0IGFzIGEgdGVtcG9yYXJ5IHNvbHV0aW9uLg0KQW5vdGhlciB0aGluZyBJIHdhbnQgdG8ga25v dyBpcyB3aGV0aGVyIHRoZXNlIGNvZGVzIGNhbiBiZSBzaW1wbGlmaWVkOg0KLQlpZiAoc3RhdGUg PiBvdXRlcl9jeHQtPnN0YXRlKQ0KKwlpZiAoY29sbGF0aW9uID09IG91dGVyX2N4dC0+Y29sbGF0 aW9uICYmDQorCQkoKHN0YXRlID09IEZEV19DT0xMQVRFX1VOU0FGRSAmJg0KKwkJICBvdXRlcl9j eHQtPnN0YXRlID09IEZEV19DT0xMQVRFX1NBRkUpIHx8DQorCQkgKHN0YXRlID09IEZEV19DT0xM QVRFX1NBRkUgJiYNCisJCSAgb3V0ZXJfY3h0LT5zdGF0ZSA9PSBGRFdfQ09MTEFURV9VTlNBRkUp KSkNCisJew0KKwkJb3V0ZXJfY3h0LT5zdGF0ZSA9IEZEV19DT0xMQVRFX1NBRkU7DQorCX0NCisJ ZWxzZSBpZiAoc3RhdGUgPiBvdXRlcl9jeHQtPnN0YXRlKQ0KDQpJZiB0aGUgc3RhdGUgaXMgZGV0 ZXJtaW5lZCBieSB0aGUgY29sbGF0aW9uLCB3aGVuIHRoZSBjb2xsYXRpb25zIGFyZSBlcXVhbCwg ZG8gd2UganVzdCBuZWVkIHRvIGp1ZGdlIHRoZSBzdGF0ZSBub3QgZXF1YWwgdG8gRkRXX0NPTExB VEVfTk9ORT8=