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 1k2VUC-0008Bv-MM for pgsql-bugs@arkaria.postgresql.org; Mon, 03 Aug 2020 08:06:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k2VUA-00070I-Vz for pgsql-bugs@arkaria.postgresql.org; Mon, 03 Aug 2020 08:06:18 +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 1k2Ugh-00074s-QY for pgsql-bugs@lists.postgresql.org; Mon, 03 Aug 2020 07:15:11 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k2Uga-0007uX-JN for pgsql-bugs@lists.postgresql.org; Mon, 03 Aug 2020 07:15:11 +0000 Content-Type: multipart/mixed; boundary="===============7944946964198085573==" MIME-Version: 1.0 Subject: BUG #16570: Collation not working To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: arnaud.perrier@gmail.com Reply-To: arnaud.perrier@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 03 Aug 2020 07:14:06 +0000 Message-ID: <16570-58cc04e1a6ef3c3f@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7944946964198085573== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjU3MApMb2dnZWQgYnk6ICAgICAgICAgIEFybmF1ZCBQZXJyaWVyCkVt YWlsIGFkZHJlc3M6ICAgICAgYXJuYXVkLnBlcnJpZXJAZ21haWwuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTIuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgLyBMaW51eApEZXNjcmlwdGlv bjogICAgICAgIAoKSSd2ZSBpbnN0YWxsZWQgUG9zdGdyZXNxbCAxMiBvbiBib3RoIFduaW5kb3dz IGFuZCBMaW51eCBDZW50T1MgOC4NCg0KRm9yIG15IHByb2plY3QsIEkgbmVlZGVkIHRvIGNyZWF0 ZSBteSBvd24gSUNVIENvbGxhdGlvbiBhbmQgYXBwbHkgaXQgdG8gYWxsCmNoYXJhY3RlciBjb2x1 bW5zIChlaXRoZXIgaW4gY29sdW1uIGNyZWF0aW9uIG9yIG9yZGVyIGJ5IHJlcXVlc3RzID0KcHJl ZmVycmVkKS4NCg0KQmVmb3JlIGRvaW5nIHNvLCBJIHRyaWVkIHRvIG1ha2UgYSBzaW1wbGUgdGVz dCBjYXNlIHRvIGNoZWNrIGlmIGl0J3Mgd29ya3MKYXMgZXhwZWN0ZWQgLi4uIGFuZCBpdCdzIG5v dC4NCg0KQSBzaW1wbGUgdGFibGUgd2l0aCBzb21lIG51bWVyaWMgYW5kIGFscGhhYmV0aWMgZGF0 YQ0KDQpEUk9QIFRBQkxFIElGIEVYSVNUUyBUQkw7DQpDUkVBVEUgVEFCTEUgVEJMICggVEVYVDEg Q0hBUkFDVEVSKDUpLCBURVhUMiBDSEFSQUNURVIoNSkgKTsNCklOU0VSVCBJTlRPIFRCTCBWQUxV RVMNCiAoJ2FhYWFhJywgJ2FhYWFhJykNCiwoJ2FhYWFhJywgJzAwMDAwJykNCiwoJ2FhYWFhJywg J2JiYmJiJykNCiwoJ2FhYWFhJywgJzExMTExJykNCg0KLCgnYmJiYmInLCAnMjIyMjInKQ0KLCgn MDAwMDAnLCAnMjIyMjInKQ0KLCgnY2NjY2MnLCAnMjIyMjInKQ0KLCgnMTExMTEnLCAnMjIyMjIn KTsNCg0KSSd2ZSBpbnN0YWxsZWQgUG9zdGdyZXNxbCAxMiBvbiBib3RoIFduaW5kb3dzIGFuZCBM aW51eCBDZW50T1MgOC4NCg0KRm9yIG15IHByb2plY3QsIEkgbmVlZGVkIHRvIGNyZWF0ZSBteSBv d24gSUNVIENvbGxhdGlvbiBhbmQgYXBwbHkgaXQgdG8gYWxsCmNoYXJhY3RlciBjb2x1bW5zIChl aXRoZXIgaW4gY29sdW1uIGNyZWF0aW9uIG9yIG9yZGVyIGJ5IHJlcXVlc3RzID0KcHJlZmVycmVk KS4NCg0KQmVmb3JlIGRvaW5nIHNvLCBJIHRyaWVkIHRvIG1ha2UgYSBzaW1wbGUgdGVzdCBjYXNl IHRvIGNoZWNrIGlmIGl0J3Mgd29ya3MKYXMgZXhwZWN0ZWQgLi4uIGFuZCBpdCdzIG5vdC4NCg0K QSBzaW1wbGUgdGFibGUgd2l0aCBzb21lIG51bWVyaWMgYW5kIGFscGhhYmV0aWMgZGF0YQ0KDQpE Uk9QIFRBQkxFIElGIEVYSVNUUyBUQkw7DQpDUkVBVEUgVEFCTEUgVEJMICggVEVYVDEgQ0hBUkFD VEVSKDUpLCBURVhUMiBDSEFSQUNURVIoNSkgKTsNCklOU0VSVCBJTlRPIFRCTCBWQUxVRVMNCiAo J2FhYWFhJywgJ2FhYWFhJykNCiwoJ2FhYWFhJywgJzAwMDAwJykNCiwoJ2FhYWFhJywgJ2JiYmJi JykNCiwoJ2FhYWFhJywgJzExMTExJykNCg0KLCgnYmJiYmInLCAnMjIyMjInKQ0KLCgnMDAwMDAn LCAnMjIyMjInKQ0KLCgnY2NjY2MnLCAnMjIyMjInKQ0KLCgnMTExMTEnLCAnMjIyMjInKTsNCg0K VGhlIGNvbGxhdGlvbiB0byBvcmRlciBkaWdpdHMgYWZ0ZXIgbGF0aW4gY2hhcmFjdGVycyBmcm9t IHRoZSBvZmZpY2lhbApkb2N1bWVudGF0aW9uIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2Rv Y3MvMTIvY29sbGF0aW9uLmh0bWwNCg0KQ1JFQVRFIENPTExBVElPTiBkaWdpdHNsYXN0IChwcm92 aWRlciA9IGljdSwgbG9jYWxlID0KJ2VuLXUta3ItbGF0bi1kaWdpdCcpOw0KQ1JFQVRFIENPTExB VElPTiBkaWdpdHNsYXN0IChwcm92aWRlciA9IGljdSwgbG9jYWxlID0KJ2VuQGNvbFJlb3JkZXI9 bGF0bi1kaWdpdCcpOw0KICAgIFNvcnQgZGlnaXRzIGFmdGVyIExhdGluIGxldHRlcnMuIChUaGUg ZGVmYXVsdCBpcyBkaWdpdHMgYmVmb3JlCmxldHRlcnMuKQ0KDQpJJ3ZlIGluc3RhbGxlZCBQb3N0 Z3Jlc3FsIDEyIG9uIGJvdGggV25pbmRvd3MgYW5kIExpbnV4IENlbnRPUyA4Lg0KDQpGb3IgbXkg cHJvamVjdCwgSSBuZWVkZWQgdG8gY3JlYXRlIG15IG93biBJQ1UgQ29sbGF0aW9uIGFuZCBhcHBs eSBpdCB0byBhbGwKY2hhcmFjdGVyIGNvbHVtbnMgKGVpdGhlciBpbiBjb2x1bW4gY3JlYXRpb24g b3Igb3JkZXIgYnkgcmVxdWVzdHMgPQpwcmVmZXJyZWQpLg0KDQpCZWZvcmUgZG9pbmcgc28sIEkg dHJpZWQgdG8gbWFrZSBhIHNpbXBsZSB0ZXN0IGNhc2UgdG8gY2hlY2sgaWYgaXQncyB3b3Jrcwph cyBleHBlY3RlZCAuLi4gYW5kIGl0J3Mgbm90Lg0KDQpBIHNpbXBsZSB0YWJsZSB3aXRoIHNvbWUg bnVtZXJpYyBhbmQgYWxwaGFiZXRpYyBkYXRhDQoNCkRST1AgVEFCTEUgSUYgRVhJU1RTIFRCTDsN CkNSRUFURSBUQUJMRSBUQkwgKCBURVhUMSBDSEFSQUNURVIoNSksIFRFWFQyIENIQVJBQ1RFUig1 KSApOw0KSU5TRVJUIElOVE8gVEJMIFZBTFVFUw0KICgnYWFhYWEnLCAnYWFhYWEnKQ0KLCgnYWFh YWEnLCAnMDAwMDAnKQ0KLCgnYWFhYWEnLCAnYmJiYmInKQ0KLCgnYWFhYWEnLCAnMTExMTEnKQ0K DQosKCdiYmJiYicsICcyMjIyMicpDQosKCcwMDAwMCcsICcyMjIyMicpDQosKCdjY2NjYycsICcy MjIyMicpDQosKCcxMTExMScsICcyMjIyMicpOw0KVGhlIGNvbGxhdGlvbiB0byBvcmRlciBkaWdp dHMgYWZ0ZXIgbGF0aW4gY2hhcmFjdGVycyBmcm9tIHRoZSBvZmZpY2lhbApkb2N1bWVudGF0aW9u IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTIvY29sbGF0aW9uLmh0bWwNCg0KQ1JF QVRFIENPTExBVElPTiBkaWdpdHNsYXN0IChwcm92aWRlciA9IGljdSwgbG9jYWxlID0KJ2VuLXUt a3ItbGF0bi1kaWdpdCcpOw0KQ1JFQVRFIENPTExBVElPTiBkaWdpdHNsYXN0IChwcm92aWRlciA9 IGljdSwgbG9jYWxlID0KJ2VuQGNvbFJlb3JkZXI9bGF0bi1kaWdpdCcpOw0KICAgIFNvcnQgZGln aXRzIGFmdGVyIExhdGluIGxldHRlcnMuIChUaGUgZGVmYXVsdCBpcyBkaWdpdHMgYmVmb3JlCmxl dHRlcnMuKQ0KDQpUaGUgdGVzdGluZyByZXF1ZXN0cw0KDQoxLyBTRUxFQ1QgKiBGUk9NIFRCTDsN CjIvIFNFTEVDVCAqIEZST00gVEJMIE9SREVSIEJZIFRFWFQxLCBURVhUMjsNCjMvIFNFTEVDVCAq IEZST00gVEJMIE9SREVSIEJZIFRFWFQxIENPTExBVEUgZGlnaXRzbGFzdDsNCjQvIFNFTEVDVCAq IEZST00gVEJMIE9SREVSIEJZIFRFWFQyIENPTExBVEUgZGlnaXRzbGFzdDsNCjUvIFNFTEVDVCAq IEZST00gVEJMIE9SREVSIEJZIFRFWFQxIENPTExBVEUgZGlnaXRzbGFzdCwgVEVYVDIgQ09MTEFU RQpkaWdpdHNsYXN0Ow0KNi8gU0VMRUNUICogRlJPTSBUQkwgT1JERVIgQlkgVEVYVDIgQ09MTEFU RSBkaWdpdHNsYXN0LCBURVhUMSBDT0xMQVRFCmRpZ2l0c2xhc3Q7DQpUaGUgcmVzdWx0cyBvbiBX aW5kb3dzID0gY29sbGF0aW9uIG5vdCB3b3JrcyBhdCBhbGwNCg0KMS8gT0sgPSBURVhUMSArIFRF WFQyID0gZGlnaXRzIGJlZm9yZSBsZXR0ZXJzDQoyLyBPSyA9IFRFWFQxICsgVEVYVDIgPSBkaWdp dHMgYmVmb3JlIGxldHRlcnMNCjMvIEtPID0gVEVYVDEgKyBURVhUMiA9IGRpZ2l0cyBiZWZvcmUg bGV0dGVycw0KNC8gS08gPSBURVhUMSArIFRFWFQyID0gZGlnaXRzIGJlZm9yZSBsZXR0ZXJzDQo1 LyBLTyA9IFRFWFQxICsgVEVYVDIgPSBkaWdpdHMgYmVmb3JlIGxldHRlcnMNCjYvIEtPID0gVEVY VDEgKyBURVhUMiA9IGRpZ2l0cyBiZWZvcmUgbGV0dGVycw0KVGhlIHJlc3VsdHMgb24gTGludXgg Q2VudG9zIDggPSBjb2xsYXRpb24gd29ya3Mgb25seSBmb3IgMXN0IGNvbHVtbiBmcm9tCk9SREVS IEJZDQoNCjEvIE9LID0gVEVYVDEgKyBURVhUMiA9IGRpZ2l0cyBiZWZvcmUgbGV0dGVycw0KMi8g T0sgPSBURVhUMSArIFRFWFQyID0gZGlnaXRzIGJlZm9yZSBsZXR0ZXJzDQozLyBPSyA9IFRFWFQx ID0gZGlnaXRzIGFmdGVyIGxldHRlcnMgKyBURVhUMiA9IGRpZ2l0cyBiZWZvcmUgbGV0dGVycw0K NC8gT0sgPSBURVhUMSA9IGRpZ2l0cyBiZWZvcmUgbGV0dGVycyArIFRFWFQyID0gZGlnaXRzIGFm dGVyIGxldHRlcnMNCjUvIEtPID0gVEVYVDEgPSBkaWdpdHMgYWZ0ZXIgbGV0dGVycyArIFRFWFQy ID0gZGlnaXRzIGJlZm9yZSBsZXR0ZXJzDQo2LyBLTyA9IFRFWFQxID0gZGlnaXRzIGJlZm9yZSBs ZXR0ZXJzICsgVEVYVDIgPSBkaWdpdHMgYWZ0ZXIgbGV0dGVycw0KSWYgSSBhcHBsaWVkIHRoZSBD T0xMQVRFIGNsYXVzZSBvbiB0aGUgdGFibGUgY29sdW1ucywgaXQncyBub3Qgd29ya2luZwphbHNv Lg0KDQpJQ1UgNTMgaXMgcGFja2FnZWQgdG8gYWxsIFBvc3RncmVzcWwgMTIgaW5zdGFsbGF0aW9u IGFuZCAtLXdpdGgtaWN1IGFyZ3VtZW50CmlzIHByZXNlbnQgb24gUG9zdGdyZXNxbCBjb25maWd1 cmF0aW9uLg0KDQpEb2VzIGFueWJvZHkgaGFzIGFueSBjbHVlIHRvIG1ha2UgdGhpcyBzaW1wbGUg dGVzdCBjYXNlIHdvcmtzID8NCg0KUG9zdCBhbHNvIG9uIHN0YWNrIG92ZXJmbG93IDoKaHR0cHM6 Ly9zdGFja292ZXJmbG93LmNvbS9xdWVzdGlvbnMvNjMwNTQ1NDMvcG9zdGdyZXNxbC0xMi1jb2xs YXRpb24tbm90LXdvcmtpbmctd2luZG93cy1saW51eAoK --===============7944946964198085573==--