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-001R86-Bh 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-000dNU-2X for pgsql-committers@arkaria.postgresql.org; Tue, 19 Nov 2024 23:29:57 +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 1tDXcO-000apO-KG for pgsql-committers@lists.postgresql.org; Tue, 19 Nov 2024 23:26:48 +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.94.2) (envelope-from ) id 1tDXcK-002m2C-0w for pgsql-committers@lists.postgresql.org; Tue, 19 Nov 2024 23:26:47 +0000 Received: from gemulon.postgresql.org ([72.32.157.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-008eh4-DH 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-002cpS-FI for pgsql-committers@lists.postgresql.org; Tue, 19 Nov 2024 23:26:42 +0000 Content-Type: multipart/mixed; boundary="===============7493139856094581879==" 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 --===============7493139856094581879== 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 dXMKCkJyYW5jaAotLS0tLS0KUkVMXzEzX1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNmI2NmRiYTNmOGQ4YjVmOWZjNzYxNzQ5 ZTVmMDY0MzgyOWYwOTMwNwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tl bmQvb3B0aW1pemVyL3ByZXAvcHJlcHVuaW9uLmMgfCAyMyArKysrKysrKysrKy0tLS0tLS0tLS0t LQoxIGZpbGUgY2hhbmdlZCwgMTEgaW5zZXJ0aW9ucygrKSwgMTIgZGVsZXRpb25zKC0pCgo= --===============7493139856094581879==--