Re: BUG #14986: -2147483648 is minimum value of integer but -2147483648::integer fails (out of range). - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #14986: -2147483648 is minimum value of integer but -2147483648::integer fails (out of range).
Date
Msg-id CC7D554D-9648-43D2-9391-5564A696304E@anarazel.de
Whole thread Raw
In response to Re: BUG #14986: -2147483648 is minimum value of integer but-2147483648::integer fails (out of range).  (Greg Stark <stark@mit.edu>)
Responses Re: BUG #14986: -2147483648 is minimum value of integer but-2147483648::integer fails (out of range).  (Stephen Frost <sfrost@snowman.net>)
List pgsql-bugs

On December 21, 2017 10:18:05 PM GMT+01:00, Greg Stark <stark@mit.edu> wrote:
>On 21 December 2017 at 14:13, Andres Freund <andres@anarazel.de> wrote:
>> Hi,
>>
>> On 2017-12-21 14:05:07 +0000, Greg Stark wrote:
>>> I wonder why the "out of range" error doesn't print the actual value
>>> it's trying to cast. That would help the user here...
>>
>> We'd have to mark it as non-leakproof in that case.
>
>Damn that's annoying.
>
>But..... uh, isn't it already leaking that the value is not in
>99.99999998% of
>the bigint range?

Most of the relevant operations have more than one operand, or are aggregates. Especially for actually relevant data
ranges.But yes, this is a way to analyze data, we knew that when adding RLS. 

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #14991: postgis-2.4.so: undefined symbol: GEOSMinimumClearance
Next
From: Stephen Frost
Date:
Subject: Re: BUG #14986: -2147483648 is minimum value of integer but-2147483648::integer fails (out of range).