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 1sjist-003Kh5-K0 for pgsql-committers@arkaria.postgresql.org; Thu, 29 Aug 2024 17:24:35 +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 1sjisq-004zJx-PM for pgsql-committers@arkaria.postgresql.org; Thu, 29 Aug 2024 17:24:33 +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 1sjisq-004zJo-IB for pgsql-committers@lists.postgresql.org; Thu, 29 Aug 2024 17:24:33 +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 1sjisn-0022qk-Rx for pgsql-committers@lists.postgresql.org; Thu, 29 Aug 2024 17:24:31 +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 1sjism-006mjv-Bi for pgsql-committers@lists.postgresql.org; Thu, 29 Aug 2024 17:24:28 +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 1sjisl-0020NG-UL for pgsql-committers@lists.postgresql.org; Thu, 29 Aug 2024 17:24:28 +0000 Content-Type: multipart/mixed; boundary="===============6746898164941534568==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix mis-deparsing of ORDER BY lists when there is a name conflic X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 29 Aug 2024 17:24:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6746898164941534568== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IG1pcy1kZXBhcnNpbmcgb2YgT1JERVIgQlkgbGlzdHMgd2hlbiB0aGVyZSBpcyBhIG5hbWUg Y29uZmxpY3QuCgpJZiBhbiBPUkRFUiBCWSBpdGVtIGluIFNFTEVDVCBpcyBhIGJhcmUgaWRlbnRp ZmllciwgdGhlIHBhcnNlcgpmaXJzdCBzZWVrcyBpdCBhcyBhbiBvdXRwdXQgY29sdW1uIG5hbWUg b2YgdGhlIFNFTEVDVCAoZm9yIFNRTDkyCmNvbXBhdGliaWxpdHkpLiAgSG93ZXZlciwgcnVsZXV0 aWxzLmMgaXMgZXhwZWN0aW5nIHRoZSBTUUw5OQppbnRlcnByZXRhdGlvbiB3aGVyZSBzdWNoIGEg bmFtZSBpcyBhbiBpbnB1dCBjb2x1bW4gbmFtZS4gIFNvIGl0J3MKcG9zc2libGUgdG8gcHJvZHVj ZSBhbiBpbmNvcnJlY3QgZGlzcGxheSBvZiBhIHZpZXcgaW4gdGhlIChhZG1pdHRlZGx5CnByZXR0 eSBpbGwtYWR2aXNlZCkgY2FzZSB3aGVyZSBzb21lIG90aGVyIGNvbHVtbiBpcyByZW5hbWVkIGlu IHRoZQpTRUxFQ1Qgb3V0cHV0IGxpc3QgdG8gbWF0Y2ggYW4gT1JERVIgQlkgY29sdW1uLgoKVGhp cyBjYW4gYmUgZml4ZWQgYnkgdGFibGUtcXVhbGlmeWluZyBzdWNoIG5hbWVzIGluIHRoZSBkdW1w ZWQKdmlldyB0ZXh0LiAgVG8gYXZvaWQgY2x1dHRlcmluZyBsZXNzLWlsbC1hZHZpc2VkIHF1ZXJp ZXMsIHdlJ2QKbGlrZSB0byBkbyBzbyBvbmx5IHdoZW4gdGhlcmUncyBhbiBhY3R1YWwgbmFtZSBj b25mbGljdC4KVGhhdCByZXF1aXJlcyBwYXNzaW5nIHRoZSBjdXJyZW50IGdldF9xdWVyeV9kZWYg Y2FsbCdzIHJlc3VsdERlc2MKcGFyYW1ldGVyIGRvd24gdG8gZ2V0X3ZhcmlhYmxlLCBzbyB0aGF0 IGl0IGNhbiBkZXRlcm1pbmUgd2hhdAp0aGUgb3V0cHV0IGNvbHVtbiBuYW1lcyBhcmUuICBJbiBo b3BlcyBvZiByZWR1Y2luZyByYXRoZXIgdGhhbgppbmNyZWFzaW5nIG5vdGF0aW9uYWwgY2x1dHRl ciBpbiBydWxldXRpbHMuYywgSSBtb3ZlZCB0aGF0IHZhbHVlCmludG8gdGhlIGRlcGFyc2VfY29u dGV4dCBzdHJ1Y3QgYW5kIHJlbW92ZWQgaXQgZnJvbSB0aGUgcGFyYW1ldGVyCmxpc3RzIG9mIGdl dF9xdWVyeV9kZWYncyBvdGhlciBzdWJyb3V0aW5lcy4KCkkgbWFkZSBhIGZldyBvdGhlciBjb3Nt ZXRpYyBjaGFuZ2VzIHdoaWxlIGF0IGl0OgoqIExpa2V3aXNlIG1vdmUgdGhlIGNvbE5hbWVzVmlz aWJsZSBwYXJhbWV0ZXIgaW50byBkZXBhcnNlX2NvbnRleHQuCiogUmVuYW1lIGRlcGFyc2VfY29u dGV4dCdzIHdpbmRvd1RMaXN0IGZpZWxkIHRvIHRhcmdldExpc3QsCnNpbmNlIGl0J3Mgbm8gbG9u Z2VyIHVzZWQgb25seSBpbiBjb25uZWN0aW9uIHdpdGggV0lORE9XIGNsYXVzZXMuCiogUmVwbGFj ZSB0aGUgc3BlY2lhbF9leHBya2luZCBmaWVsZCB3aXRoIGEgYm9vbCBpbkdyb3VwQnksCnNpbmNl IHRoYXQgd2FzIGFsbCBpdCB3YXMgYmVpbmcgdXNlZCBmb3IsIGFuZCB0aGUgYXBwYXJlbnQKZmxl eGliaWxpdHkgb2Ygc3RvcmluZyBhIFBhcnNlRXhwcktpbmQgcHJvdmVkIHRvIGJlIGlsbHVzb3J5 LgooV2UgbmVlZCBhIHNlcGFyYXRlIHZhckluT3JkZXJCeSBmaWVsZCB0byBtYWtlIHRoaXMgcGF0 Y2ggd29yay4pCiogUmVtb3ZlIHVzZWxlc3Mgc2F2ZS9yZXN0b3JlIGxvZ2ljIGluIGdldF9zZWxl Y3RfcXVlcnlfZGVmLgoKSW4gcHJpbmNpcGxlLCB0aGlzIGJ1ZyBpcyBxdWl0ZSBvbGQuICBIb3dl dmVyLCBpdCBzZWVtcyB1bnJlYWNoYWJsZQpiZWZvcmUgMWI0ZDI4MGVhLCBiZWNhdXNlIGJlZm9y ZSB0aGF0IHRoZSBwcmVzZW5jZSBvZiAibmV3IiBhbmQgIm9sZCIKZW50cmllcyBpbiBhIHZpZXcn cyByYW5nZXRhYmxlIGNhdXNlZCB1cyB0byBhbHdheXMgdGFibGUtcXVhbGlmeSBldmVyeQpWYXIg cmVmZXJlbmNlIGluIGR1bXBlZCB2aWV3cy4gIEhlbmNlLCBiYWNrLXBhdGNoIHRvIHYxNiB3aGVy ZSB0aGF0CmNhbWUgaW4uCgpQZXIgYnVnICMxODU4OSBmcm9tIFF1eW5oIFRyYW4uCgpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE4NTg5LTcwMDkxY2I4MWRiMWEzZjFAcG9zdGdyZXNx bC5vcmcKCkJyYW5jaAotLS0tLS0KUkVMXzE3X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYTdlYjYzMzU2M2M2YmE4ODU3Y2Y1 OWM3YjQzYjU5MzYxNDUzNzYxNwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jh Y2tlbmQvdXRpbHMvYWR0L3J1bGV1dGlscy5jICAgICAgICAgfCAyNTAgKysrKysrKysrKysrKysr KysrLS0tLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRlX3ZpZXcub3V0 IHwgIDUxICsrKysrLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVfdmlldy5zcWwgICAgICB8 ICAxNiArKwozIGZpbGVzIGNoYW5nZWQsIDIxNyBpbnNlcnRpb25zKCspLCAxMDAgZGVsZXRpb25z KC0pCgo= --===============6746898164941534568==--