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 1oJcUD-0007Zx-2K for pgsql-bugs@arkaria.postgresql.org; Thu, 04 Aug 2022 15:10:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oJcUC-0008JU-1M for pgsql-bugs@arkaria.postgresql.org; Thu, 04 Aug 2022 15:10:08 +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 1oJcHg-0005wr-18 for pgsql-bugs@lists.postgresql.org; Thu, 04 Aug 2022 14:57:12 +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 1oJcHZ-0001La-DB for pgsql-bugs@lists.postgresql.org; Thu, 04 Aug 2022 14:57:11 +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=YDh8zKddu8KQYHIZmFem62fZkm3US2D8LLdO6uRc2eQ=; b=uMz7OT423LZllEDVsd2eD442YA Mcnv0RvZB3qMqCqnXyRF6TGU0DWa//dDjzJuF4RtaS+DWqzNXHY1fOlGjC/J22TyUcN0E/DvyRIR+ KcRiNpjs8TrXIvD3W63v2T17TtfKTADwTkbKww3ciNAfAzO71XjqfLRmFbsGVNvNQRy0fYrIaEgrP nuUa9fUefypIByCcKTuzaWazaqQKdFV7lTyIldu5le0hA7H6rxOPvEJnoNWfkSbbcWXsCBpNFrGX7 8TZaDEw++iAHrj72QaPqlIujNuoubF2xqz6pAyL77IWSUQfGFp5n+gJ2fjQi3YCJFCad5k9tfhWyh ZKofIQZw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oJcHX-0005qK-O1 for pgsql-bugs@lists.postgresql.org; Thu, 04 Aug 2022 14:57:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oJcHW-001FUT-De for pgsql-bugs@lists.postgresql.org; Thu, 04 Aug 2022 14:57:02 +0000 Content-Type: multipart/mixed; boundary="===============2028296713239944002==" MIME-Version: 1.0 Subject: BUG #17571: PostgreSQL 15b2 ICU collation defined at db level sorts differently in collate clause vs implicit To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: daniel.halsey@vectorsolutions.com Reply-To: daniel.halsey@vectorsolutions.com, pgsql-bugs@lists.postgresql.org Date: Thu, 04 Aug 2022 14:56:32 +0000 Message-ID: <17571-8aa6361274d2e3c3@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 --===============2028296713239944002== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU3MQpMb2dnZWQgYnk6ICAgICAgICAgIERhbmllbCBIYWxzZXkKRW1h aWwgYWRkcmVzczogICAgICBkYW5pZWwuaGFsc2V5QHZlY3RvcnNvbHV0aW9ucy5jb20KUG9zdGdy ZVNRTCB2ZXJzaW9uOiBVbnN1cHBvcnRlZC9Vbmtub3duCk9wZXJhdGluZyBzeXN0ZW06ICAgRGVi aWFuIChEb2NrZXIgUEcxNWIyIEJ1bGxzZXllKQpEZXNjcmlwdGlvbjogICAgICAgIAoKSSdtIHVz aW5nIGFuICJvZmZpY2lhbCIgMTViZXRhMiBidWxsc2V5ZSBEb2NrZXIgaW1hZ2UgZm9yIHRoaXM6 IFdoZW4gdXNpbmcgYQpub25kZXRlcm1pbmlzdGljIElDVSBjb2xsYXRpb24gYXMgdGhlIGRlZmF1 bHQgY29sbGF0aW9uIGZvciBhIGRhdGFiYXNlLApzb3J0aW5nIChPUkRFUiBCWSkgd2l0aG91dCBh IENPTExBVEUgc3ViY2xhdXNlIGFjdHMgZGlmZmVyZW50bHkgdGhhbiB0aGUKc2FtZSBxdWVyeSB3 aXRoIG9uZS4gSW5zdGVhZCBvZiB0cmVhdGluZyBkaWZmZXJlbnRseSBjYXNlZCBjaGFyYWN0ZXJz IGFzCnRydWx5IGVxdWl2YWxlbnQsIGl0IGFwcGVhcnMgdG8gdHJlYXQgY2FzaW5nIGFzIGEgdGll YnJlYWtlciB3aXRoaW4gYQpjb2x1bW4uIE11bHRpLWNvbHVtbiBPUkRFUiBCWSBjbGF1c2VzIHJl dmVhbCB0aGlzIGRpZmZlcmVuY2UsIGFzIHNob3duIGluCnJlc3VsdHMgZnJvbSBzZWxlY3Qgc3Rh dGVtZW50cyBpbiB0aGUgZGVtbyBjb2RlIGJlbG93LiBUaGlzIGRvZXNuJ3QgYXBwZWFyCnRvIGR1 cGxpY2F0ZSBhbiBleGlzdGluZyBUT0RPLCBhcyBmYXIgYXMgSSBjYW4gZGV0ZXJtaW5lLg0KDQot LSBUZXN0IGNvZGU6DQotLS0tLQ0KLS0gYXMgc2EgKHBvc3RncmVzKQ0KDQpjcmVhdGUgY29sbGF0 aW9uIGlmIG5vdCBleGlzdHMgInVuZC1zb3J0dGVzdC14LWljdSIgDQoJKHByb3ZpZGVyPWljdSwg DQoJIGxvY2FsZT0ndW5kLXUta3MtbGV2ZWwyLWtjLWZhbHNlJywgDQoJIGRldGVybWluaXN0aWM9 ZmFsc2UpOw0KDQpjcmVhdGUgZGF0YWJhc2Ugc29ydHRlc3Qgd2l0aA0KICAgIG93bmVyID0gcG9z dGdyZXMNCiAgICBlbmNvZGluZyA9ICdVVEY4Jw0KICAgIGxvY2FsZV9wcm92aWRlciA9ICdpY3Un DQogICAgaWN1X2xvY2FsZSA9ICd1bmQtc29ydHRlc3QteC1pY3UnDQogICAgY29ubmVjdGlvbiBs aW1pdCA9IC0xDQogICAgdGVtcGxhdGUgPSB0ZW1wbGF0ZTA7DQoNCg0KLS0gQ29ubmVjdCB0byBu ZXcgInNvcnR0ZXN0IiBkYg0KDQpjcmVhdGUgdGFibGUgc29ydF90ZXN0ICgNCglpZCBiaWdzZXJp YWwgcHJpbWFyeSBrZXksDQoJc29ydGFibGVPbmUgdmFyY2hhcig1MCksDQoJc29ydGFibGVUd28g dmFyY2hhcig1MCksDQoJc29ydGFibGVUaHJlZSBpbnQNCik7DQoNCmluc2VydCBpbnRvIHNvcnRf dGVzdA0KKHNvcnRhYmxlT25lLCBzb3J0YWJsZVR3bywgc29ydGFibGVUaHJlZSkNCnZhbHVlcyAN CignQWJjJywgJ0InLCAzKSwNCignQWJDJywgJ0EnLCAzKSwNCignQWJDJywgJ0InLCAxKSwNCign QUJjJywgJ0MnLCAzKSwNCignQWJDJywgJ0MnLCAyKSwNCignQUJDJywgJ0MnLCAxKSwNCignQUJj JywgJ0EnLCAyKQ0KOw0KDQotLSBOYXR1cmFsL2luZGV4IG9yZGVyaW5nDQpzZWxlY3QgKiBmcm9t IHNvcnRfdGVzdDsNCg0KLS0gTG93ZXIgYmVmb3JlIHVwcGVyIGluIHNvcnRhYmxlT25lLCB3aXRo b3V0IHJlZ2FyZHMgdG8gc29ydGFibGVUd28Kc2Vjb25kYXJ5IG9yZGVyaW5nDQpzZWxlY3QgKiBm cm9tIHNvcnRfdGVzdA0Kb3JkZXIgYnkgc29ydGFibGVPbmUsIHNvcnRhYmxlVHdvOw0KDQotLSBU cnVseSBub24tZGV0ZXJtaW5pc3RpYyBzb3J0IG9uIHNvcnRhYmxlT25lLCBmb2xsb3dpbmcgc2Vj b25kYXJ5IG9yZGVyaW5nCm9uIHNvcnRhYmxlVHdvDQpzZWxlY3QgKiBmcm9tIHNvcnRfdGVzdA0K b3JkZXIgYnkgc29ydGFibGVPbmUgY29sbGF0ZSAidW5kLXNvcnR0ZXN0LXgtaWN1Iiwgc29ydGFi bGVUd287DQoNCi0tIEFkZGl0aW9uYWwgdGVzdCB1c2luZyB0ZXJ0aWFyeSBzb3J0DQpzZWxlY3Qg KiBmcm9tIHNvcnRfdGVzdA0Kb3JkZXIgYnkgc29ydGFibGVPbmUsIHNvcnRhYmxlVHdvLCBzb3J0 YWJsZVRocmVlOw0KDQotLSBBZGRpdGlvbmFsIHRlc3QgdXNpbmcgdGVydGlhcnkgc29ydA0Kc2Vs ZWN0ICogZnJvbSBzb3J0X3Rlc3QNCm9yZGVyIGJ5IHNvcnRhYmxlT25lIGNvbGxhdGUgInVuZC1z b3J0dGVzdC14LWljdSIsIHNvcnRhYmxlVHdvLApzb3J0YWJsZVRocmVlOw0KDQotLSBMSUtFIGNs YXVzZSB0cmVhdGluZyBkZWZhdWx0IGNvbGxhdGlvbiBhcyBkZXRlcm1pbmlzdGljDQotLSBUaGlz IGlzIGZpbmUvcHJlZmVycmVkLCBzaW5jZSB3ZSBjYW4gdXNlIGl0IHdpdGhvdXQgc3BlY2lmeWlu ZyBhIHNlcGFyYXRlCkNPTExBVEUgc3ViY2xhdXNlIGZvciB0aGUgTElLRQ0Kc2VsZWN0ICogZnJv bSBzb3J0X3Rlc3QNCndoZXJlIHNvcnRhYmxlT25lIGxpa2UgJ0FiJScNCm9yZGVyIGJ5IHNvcnRh YmxlT25lIGNvbGxhdGUgInVuZC1zb3J0dGVzdC14LWljdSIsIHNvcnRhYmxlVHdvLApzb3J0YWJs ZVRocmVlOw0KDQotLSBJTElLRSB3b3JraW5nIGFzIGRlc2lyZWQNCnNlbGVjdCAqIGZyb20gc29y dF90ZXN0DQp3aGVyZSBzb3J0YWJsZU9uZSBpbGlrZSAnYWIlJw0Kb3JkZXIgYnkgc29ydGFibGVP bmUgY29sbGF0ZSAidW5kLXNvcnR0ZXN0LXgtaWN1Iiwgc29ydGFibGVUd28sCnNvcnRhYmxlVGhy ZWU7DQoNCi0tLS0tIEVORCBUZXN0IGNvZGUKCg== --===============2028296713239944002==--