Re: Underscore in positional parameters? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Underscore in positional parameters?
Date
Msg-id 22b3febb-53b4-45af-b6ee-bbd16e39f61b@eisentraut.org
Whole thread Raw
In response to Re: Underscore in positional parameters?  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Underscore in positional parameters?
List pgsql-hackers
On 16.05.24 01:11, Michael Paquier wrote:
> On Wed, May 15, 2024 at 01:59:36PM +0200, Peter Eisentraut wrote:
>> On 14.05.24 18:07, Erik Wienhold wrote:
>>> Patch 0002 replaces atol with pg_strtoint32_safe in the backend parser
>>> and strtoint in ECPG.  This fixes overflows like:
>>
>> Seems like a good idea, but as was said, this is an older issue, so let's
>> look at that separately.
> 
> Hmm, yeah.  I would be really tempted to fix that now.
> 
> Now, it has been this way for ages, and with my RMT hat on (aka I need
> to show the example), I'd suggest to wait for when the v18 branch
> opens as there is no urgency.  I'm OK to apply it myself at the end,
> the patch is a good idea.

On this specific patch, maybe reword "parameter too large" to "parameter 
number too large".

Also, I was bemused by the use of atol(), which is notoriously 
unportable (sizeof(long)).  So I poked around and found more places that 
might need fixing.  I'm attaching a patch here with annotations too look 
at later.

Attachment

pgsql-hackers by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: Pre-Commitfest Party on StHighload conf
Next
From: Peter Eisentraut
Date:
Subject: Re: SQL:2011 application time