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 1uaRWm-005KXe-JM for pgsql-hackers@arkaria.postgresql.org; Sat, 12 Jul 2025 04:07:56 +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 1uaRWi-007sak-Gr for pgsql-hackers@arkaria.postgresql.org; Sat, 12 Jul 2025 04:07:53 +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 1uaRWi-007sab-4I for pgsql-hackers@lists.postgresql.org; Sat, 12 Jul 2025 04:07:52 +0000 Received: from mail-pg1-x52c.google.com ([2607:f8b0:4864:20::52c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uaRWf-0078Q5-32 for pgsql-hackers@lists.postgresql.org; Sat, 12 Jul 2025 04:07:52 +0000 Received: by mail-pg1-x52c.google.com with SMTP id 41be03b00d2f7-b31d578e774so3281960a12.1 for ; Fri, 11 Jul 2025 21:07:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752293267; x=1752898067; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Zm7mrvReeIcNVd2PioY1Vab7IQq04PC0ECWSeWnRhaY=; b=MTPjyQJ7ym3RpQHsR8cDjGmSnsrYLYY8F+lhwHJ/mw0y8TZFZlcCmrU10eKjKheZRv ovlg71qAvV6XNr4EZn8Nt3vHoDyLRQ6N/q49DqyMZscMYP+U5coBiRgvdkSOzRX91hA1 4Q8BSXSPUygH3uFhJCpiB5VRwQk7vgI/3/D8df7V/MmDS4/UfxZ1dATD3eEj1ky3W+S4 2BLWq1jkk7eyQhSJ7a2KUT4IUfsMkIFY4A58aqkrOutVFmhqwgV7WwZGHMnl9JF3kLer ulapWEQL9ICbO1988NHhtd155FYMsbCsn/uco0g85ltX4LgZGDvo6q09UYhszHWlw1WQ +rCg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752293267; x=1752898067; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Zm7mrvReeIcNVd2PioY1Vab7IQq04PC0ECWSeWnRhaY=; b=i+MfsthA+VV0LJ0kobfudqFhu4jHnkvQg9jOxAUgWG5qKR6srrVfQO/MiPNTGrgb2d 6iWj/19V9/4bDnzMXmkCad8huw+Q2T40U3THgvF7yMSXLAzx3LIa7rCh7THBu9BorqCg fyFMpoujU2MPwmQ5RvCSXZGYDNkWB9R46VrOKZeo8GNpUVxRmfYPFpRNyPvR/XQOAtjQ 1NLNXTQnoU7eJHjN9/hRewoIPxo70h9WP9to8f3ux8cYqltE9L5w+Iru+uyRoMsZRvEk KH+YhaWxsPZhoTJZLtRIwFssrkd8kC8ZqixLzeDR2wbDvHaiLe+2acjyoB76L/8h0Oar 2hDA== X-Forwarded-Encrypted: i=1; AJvYcCV3JRhhMeivX1D1TdDFwGUS21sbjnyHzwkxiVEB5vahArmAHE/TJIohYck7ajyyCOOrt7xwtOqI/BojQMuj@lists.postgresql.org X-Gm-Message-State: AOJu0Yzqx8Of0ggD07T38WaFJeAT7CipfK0MsJGHIImEP9lR51VCP52+ 1TeXrm3zDkuId70A7zw6VSZeZadJfln041ruIYIn3M297vzNOSpRFJ8RVG6eYFKNkR8M4mFayKH 938vhua8fe/O2AHp1fPoLqitjMNca6IQ= X-Gm-Gg: ASbGncs+mukOZqgRjjFxr1TD32SgAs9UzvU+zmEkSQsI4Xr69nz6JzJkXailp9EONEl XT45Doz6ppFMKhWCVtdtPCJX9dDCZ5NbzAcfR9hMdJ1yTHwkGuJ8l+5RwCjByJTD7jW+wDh0/6f Xdphvyb/Wu0QQ276I141971KNOMg5ySILGTvOvcsdRQ9x89/4S0y0Glm8+hy6ZYxn6+vzqGPYRz XYNlA+bCLP0GNuWGDMraqEZLlQfn1KV1d6FwBIsX257mvoieO0= X-Google-Smtp-Source: AGHT+IEByTTYe5xGfA+r0dYk2nSfzWvntk8njg5cwoBzRzDMBfO5HyvGYntNIibCSXF/bzi3WzKHKRI9S6Kw56sctQc= X-Received: by 2002:a17:90b:5486:b0:311:83d3:fd9c with SMTP id 98e67ed59e1d1-31c3ce231c4mr15685927a91.0.1752293266377; Fri, 11 Jul 2025 21:07:46 -0700 (PDT) MIME-Version: 1.0 References: <145894.1727298237@sss.pgh.pa.us> <7e9debe6-4e96-4b0d-a801-b531e962ef43@eisentraut.org> <01DC1C38-0692-461B-AA63-5394330356BE@gmail.com> <2568904.1748022721@sss.pgh.pa.us> <40912112-7FFE-400F-A38F-368827C4BDF1@gmail.com> <176C517D-2DEB-4CAB-9AE4-261079D313B9@justatheory.com> <8FD5F4CF-9059-40C1-9F0A-C3CBA8DFE17A@justatheory.com> <696ECBBC-3CBF-4522-AE66-E48225688E93@gmail.com> <59C63857-406D-4704-A1EB-9BF3AA639C86@justatheory.com> <06FA8975-2E21-46A5-B510-028B3B967EB2@justatheory.com> <2F58E05D-D319-4CD3-8805-E1A8A2482A1A@justatheory.com> <4A96ACDB-78A1-4434-8C25-7C9716A7D421@justatheory.com> <4904EA5B-C6CA-42BD-BF08-C89325240C9D@gmail.com> <84727E10-62B7-4FE4-B487-E7044C7C0A1F@justatheory.com> <6CD16A54-BFEE-4CB5-84AC-F3B46289FA6D@justatheory.com> <7D19A273-1306-4F4C-9DFD-CE16F44790CB@justatheory.com> In-Reply-To: <7D19A273-1306-4F4C-9DFD-CE16F44790CB@justatheory.com> From: Florents Tselai Date: Sat, 12 Jul 2025 07:07:08 +0300 X-Gm-Features: Ac12FXwWzV8pH1C4zsTeO2d6cvZKhhp5pKlpHWW_x6jL8-mN41zTRA2Q82TI2dI Message-ID: Subject: Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part To: "David E. Wheeler" Cc: Tom Lane , Peter Eisentraut , Robert Haas , Alexander Korotkov , pgsql-hackers , Andrew Dunstan Content-Type: multipart/alternative; boundary="000000000000af53540639b3911f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000af53540639b3911f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Jul 11, 2025 at 9:48=E2=80=AFPM David E. Wheeler wrote: > On Jul 10, 2025, at 19:23, David E. Wheeler wrote= : > > > Now with the `ISO C90 forbids mixed declarations and code` warning > cleared up. > > > > Weird that there=E2=80=99s a failure on Bookworm with Meson [1] (pg_reg= ress > diffs [2]) but not Bookworm with Configure [3]. Collation issue, perhaps? > > David Johnson noticed that this build is 32-bit. I looked at the > split_path function and after trying a couple of things, realized that it > was passing an int8 when the SQL function in Marlena.c passes an int4. Th= is > change got the test passing in my clone (indentation reduced): Occasionally I've noticed myself some inconsistencies wrt to compiler warnings between meson & make . But cirrus seems generally happy now https://cirrus-ci.com/build/4964687915253760 To recap so far; - I like your changes and renames on the parser/lexer; it indeed looks much cleaner now and will help with future improvements. - I also like the addition of executeStringInternalMethod ; it'll help us add more stuff in the future (reminder that for the original patch I implemented the methods I'd like more, but string operations are quite more). - AFAICT no test cases / results have changed with your versions; is this correct ? --000000000000af53540639b3911f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Fri, = Jul 11, 2025 at 9:48=E2=80=AFPM David E. Wheeler <david@justatheory.com> wrote:
On Jul 10, 2025, at 19:23, David E. Wheeler <david@justatheory.com> wrote:=

> Now with the `ISO C90 forbids mixed declarations and code` warning cle= ared up.
>
> Weird that there=E2=80=99s a failure on Bookworm with Meson [1] (pg_re= gress diffs [2]) but not Bookworm with Configure [3]. Collation issue, perh= aps?

David Johnson noticed that this build is 32-bit. I looked at the split_path= function and after trying a couple of things, realized that it was passing= an int8 when the SQL function in Marlena.c passes an int4. This change got= the test passing in my clone (indentation reduced):

<= /div>
Occasionally I've noticed myself some inconsistencies wrt to = compiler warnings between meson & make .=C2=A0
But cirrus see= ms generally happy now=C2=A0https://cirrus-ci.com/build/4964687915253760=C2=A0
=
To recap so far;=C2=A0

- I like you= r changes and renames on the parser/lexer; it indeed looks much cleaner now= and will help with future improvements.
- I also like the additi= on of=C2=A0executeStringInternalMethod ; it'll help us add more stuff i= n the future (reminder that for the original patch I implemented the method= s I'd like more, but string operations are quite more).

<= /div>
- AFAICT no test cases / results have changed with your versions;= is this correct ?

--000000000000af53540639b3911f--