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(at)arcict(dot)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(at)arcict(dot)com <mailto:info(at)arcict(dot)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(dot)klaver(at)aklaver(dot)com