different results from plpgsql functions related to last changes in master - Mailing list pgsql-hackers

From Pavel Stehule
Subject different results from plpgsql functions related to last changes in master
Date
Msg-id CAFj8pRAkpDBkgAUAsdWC+e3iVWSM12FHVQAWT0R10zxs2QyWuA@mail.gmail.com
Whole thread Raw
Responses Re: different results from plpgsql functions related to last changes in master
List pgsql-hackers
Hi

I did update of plpgsql_check and I see, so some functions returns different result than on older posgresql. Probably this is wanted behave, but It should be mentioned as partial compatibility break, because some regress test can be broken too.

create table t(i int);
create function test_t(OUT t) returns t AS $$
begin
    $1 := null;
end;
$$ language plpgsql;

select test_t();

result on PostgreSQL11 is null, on older is empty record "()"

Regards

Pavel

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: ALTER TABLE ADD COLUMN fast default
Next
From: Andreas Seltenreich
Date:
Subject: Re: [HACKERS] MERGE SQL Statement for PG11