Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

On 2/27/20 9:08 AM, Marc wrote:
> Hello Tom,
> 
> To whom do we report our findings regarding this issue ?

Since it is an EDB hack I would try the contact form at the bottom of 
the this page:

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

> 
> I can offer you a Belgian waffle to go with you caffeine.
> 
> Kindest Regards,
> 
> 
> 
> Marc
> 
> 
> On 25 Feb 2020, at 10:35, Nick Renders wrote:
> 
>     Hi Tom,
> 
>     1. we used the EDB installer.
> 
>     2. turning JIT off did make the problem go away. So I guess this was
>     causing the Postgres process to crash all along.
> 
>     Thanks for the help,
> 
>     Nick
> 
> 
>     On 24 Feb 2020, at 16:24, Tom Lane wrote:
> 
>         "Nick Renders" <postgres@arcict.com> writes:
> 
>             We have set up a new test environment running PostgreSQL
>             v12.2 on macOS
>             10.14 and the issue is still there.
> 
>         Some nearby threads prompt these two questions:
> 
>         1. Are you using your own build, or is this from EDB's installer?
> 
>         2. If the latter, does turning JIT off ("set jit = off") make the
>         problem go away?
> 
>         There is as yet no "native" support for --with-llvm on macOS,
>         ie Apple themselves don't provide sufficient support for that.
>         EDB seem to have hacked up something that sort of works, but
>         only sort of.
> 
>         regards, tom lane
> 
> 
> 
> *ARC - your Apple Authorised Service partner*     H.D. Saviolaan 8
>     B-1700 Dilbeek
>     Belgium
> info@arcict.com <mailto:info@arcict.com>     www.arcict.com 
> <http://www.arcict.com>
> tel. : +32 (0)2 466 50 00     fax. : +32 (0)2 466 88 33
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com