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 1smFg4-004Ler-54 for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Sep 2024 16:49:48 +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 1smFg2-00DukC-BF for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Sep 2024 16:49:46 +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 1smFg2-00Duk4-12 for pgsql-hackers@lists.postgresql.org; Thu, 05 Sep 2024 16:49:46 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1smFg0-000JZp-Au for pgsql-hackers@lists.postgresql.org; Thu, 05 Sep 2024 16:49:45 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 485Gngmh1998878; Thu, 5 Sep 2024 12:49:42 -0400 From: Tom Lane To: Karina Litskevich cc: Pavel Borisov , Postgres hackers Subject: Re: Invalid "trailing junk" error message when non-English letters are used In-reply-to: References: <1709057.1725490341@sss.pgh.pa.us> Comments: In-reply-to Karina Litskevich message dated "Thu, 05 Sep 2024 18:11:20 +0300" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <1998875.1725554982.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Thu, 05 Sep 2024 12:49:42 -0400 Message-ID: <1998877.1725554982@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Karina Litskevich writes: > On Thu, Sep 5, 2024 at 6:07 PM Karina Litskevich > wrote: >> In v3 of the patch I grouped all the *_junk rules together and included >> the suggested comment with a little added something. > Oops, I forgot to attach the patch, here it is. Pushed with a bit of further wordsmithing on the comment. I left out the proposed new test case "SELECT 1ä;". The trouble with that is it'd introduce an encoding dependency into the test. For example, it'd likely fail with some other error message in a server encoding that lacks an equivalent to UTF8 "ä". While we have methods for coping with such cases, it requires some pushups, and I didn't see the value. The changes in existing test case results are sufficient to show the patch does what we want. Also, while the bug exists in v15, the patch didn't apply at all. I got lazy and just did the minimal s/ident_start/identifier/ change in that branch, instead of back-patching the cosmetic aspects. regards, tom lane