Re: pg_plan_advice: fix parsing underscore in numbers

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Lukas Fittl <lukas(at)fittl(dot)com>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: pg_plan_advice: fix parsing underscore in numbers
Date: 2026-07-18 16:47:23
Message-ID: 2A6EC94E-66A4-40B0-AF4E-DC2D4310020F@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 18 Jul 2026, at 03:04, Lukas Fittl <lukas(at)fittl(dot)com> wrote:
> On Fri, Jul 17, 2026 at 1:59 PM Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:
>>> On Jul 17, 2026, at 18:16, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:

>>>> The attached patch fixes this by using pg_strtoint32_safe() in the same way as the core scanner.
>
> FWIW, I've raised this issue at the time during patch review, and
> Robert noted "OK" at the time, but I assume this was forgotten in the
> final committed version.

Considering the size and complexity of the patchset I am not the least bit
surprised, it's easy to lose track of all the things needing to be fixed,
happens to the best of us. Thanks for the reference to the thread though,
clearly both you and Chao Li should get credited with reporting the bug.

>> PFA v3, which only adds this test case.
>
> I think v3 looks good from a quick look.

Thanks for the updated patch and the review of that version, I'll have a closer
look at it later tonight.

--
Daniel Gustafsson

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2026-07-18 17:31:30 Re: Raise default track_activity_query_size to 16kB (from 1kB, unchanged since 8.x)
Previous Message Jeff Davis 2026-07-18 16:41:43 Re: REASSIGN OWNED vs. relisshared dep on !relisshared