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

On 2/8/20 12:09 PM, Nick Renders wrote:
> Hi,
>
> We have just upgraded our Postgres 9.6 database to 12.1 (pg_dumpall ->
> pg_restore on a clean installation) and now we are having some issues
> with one of our tables.
>
> When we do the following statement:
>
>     SELECT * FROM f_gsxws_schedule WHERE UPPER(gwsc_dossier) = 'TEST'
>
> the Postgres service restarts.
>
> It seems that using UPPER() in the WHERE clause is causing this. The
> same statement without UPPER() works just fine.
>
> I have tried to emulate the issue with other tables, but
> f_gsxws_schedule seems to be the only one.
> The table also has another character field that is indexed, and the same
> problem occurs there. Whenever we use UPPER() or LOWER() to do a
> case-insensitive search, the service reboots.
>
> Looking at the table's definition, I don't see anything different with
> the other tables.
>
> Here is what is logged:
>

>
> Has anyone noticed anything like this before? Any idea how to fix this?

Was the upgrade on the same machine?

Or was the machine also upgraded/updated?

I ask as there have been similar reports having to with changes in glibc
version affecting collation.

>
>
> Best regards,
>
> Nick Renders
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com