Re: Pg17 Crash in Planning (Arrays + Casting + UDF)

On 10/9/24 14:52, Paul Ramsey wrote:
> Hackers,
>
> This extremely odd case [2] came in via a report using a lot of PostGIS functions, but it can be reconfigured into a pure-PostgreSQL crasher [1].
>
> CREATE TABLE n (i integer);
>
> CREATE OR REPLACE FUNCTION add(integer)
> RETURNS integer
> AS 'SELECT 2 * $1 + 4 * $1'
> LANGUAGE 'sql' IMMUTABLE STRICT PARALLEL SAFE;
>
> SELECT add(array_length(array_agg(i)::numeric[],1)::integer) FROM n;
>
> The stack trace shows it doesn’t get past planning, and in fact it doesn’t care if the table has data in it or not.

I can duplicate the crash on master and 17 stable branches, but not pg16
FWIW. That is as far as I have looked so far.

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com