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
