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 1tDXfS-001R84-Gq for pgsql-committers@arkaria.postgresql.org; Tue, 19 Nov 2024 23:29:58 +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 1tDXfR-000dNS-2U for pgsql-committers@arkaria.postgresql.org; Tue, 19 Nov 2024 23:29:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDXcN-000ako-L3 for pgsql-committers@lists.postgresql.org; Tue, 19 Nov 2024 23:26:47 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDXcK-002pOL-Uk for pgsql-committers@lists.postgresql.org; Tue, 19 Nov 2024 23:26:47 +0000 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.94.2) (envelope-from ) id 1tDXcJ-008eh2-78 for pgsql-committers@lists.postgresql.org; Tue, 19 Nov 2024 23:26:43 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tDXcI-002cpP-Em for pgsql-committers@lists.postgresql.org; Tue, 19 Nov 2024 23:26:42 +0000 Content-Type: multipart/mixed; boundary="===============6961337151122238991==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Compare collations before merging UNION operations. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 19 Nov 2024 23:26:42 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6961337151122238991== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q29tcGFyZSBjb2xsYXRpb25zIGJlZm9yZSBtZXJnaW5nIFVOSU9OIG9wZXJhdGlvbnMuCgpJbiB0 aGUgZGltIHBhc3Qgd2UgZmlndXJlZCBpdCB3YXMgb2theSB0byBpZ25vcmUgY29sbGF0aW9ucwp3 aGVuIGNvbWJpbmluZyBVTklPTiBzZXQtb3BlcmF0aW9uIG5vZGVzIGludG8gYSBzaW5nbGUgTi13 YXkKVU5JT04gb3BlcmF0aW9uLiAgSSBiZWxpZXZlIHRoYXQgd2FzIGZpbmUgYXQgdGhlIHRpbWUs IGJ1dAppdCBzdG9wcGVkIGJlaW5nIGZpbmUgd2hlbiB3ZSBhZGRlZCBub25kZXRlcm1pbmlzdGlj IGNvbGxhdGlvbnM6CnRoZSBzZW1hbnRpY3Mgb2YgZGlzdGluY3QtbmVzcyBhcmUgYWZmZWN0ZWQg YnkgdGhvc2UuICB2MTcgbWFkZQppdCBldmVuIGxlc3MgZmluZSBieSBhbGxvd2luZyBwZXItY2hp bGQgc29ydGluZyBvcGVyYXRpb25zIHRvCmJlIG1lcmdlZCB2aWEgTWVyZ2VBcHBlbmQsIGFsdGhv dWdoIEkgdGhpbmsgd2UgYWNjaWRlbnRhbGx5CmF2b2lkZWQgYW55IGxpdmUgYnVnIGZyb20gdGhh dC4KCkFkZCBhIGNoZWNrIHRoYXQgY29sbGF0aW9ucyBtYXRjaCBiZWZvcmUgZGVjaWRpbmcgdGhh dCB0d28KVU5JT04gbm9kZXMgYXJlIGVxdWl2YWxlbnQuICBJIGFsc28gZmFpbGVkIHRvIHJlc2lz dCB0aGUKdGVtcHRhdGlvbiB0byBjb21tZW50IHBsYW5fdW5pb25fY2hpbGRyZW4oKSBhIGxpdHRs ZSBiZXR0ZXIuCgpCYWNrLXBhdGNoIHRvIGFsbCBzdXBwb3J0ZWQgYnJhbmNoZXMgKHYxMyBub3cp LCBzaW5jZSB0aGV5CmFsbCBoYXZlIG5vbmRldGVybWluaXN0aWMgY29sbGF0aW9ucy4KCkRpc2N1 c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMzYwNTU2OC4xNzMxOTcwNTc5QHNzcy5wZ2gucGEu dXMKCkJyYW5jaAotLS0tLS0KUkVMXzE0X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNDRhNGE1MjFkMDNhMDAzM2ZjYTY5NmI1 ZmE0NzI1YTQzNjAxOGFlNgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tl bmQvb3B0aW1pemVyL3ByZXAvcHJlcHVuaW9uLmMgfCAyMyArKysrKysrKysrKy0tLS0tLS0tLS0t LQoxIGZpbGUgY2hhbmdlZCwgMTEgaW5zZXJ0aW9ucygrKSwgMTIgZGVsZXRpb25zKC0pCgo= --===============6961337151122238991==--