different results from plpgsql functions related to last changes in master

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: different results from plpgsql functions related to last changes in master
Date: 2018-02-18 04:58:39
Message-ID: CAFj8pRAkpDBkgAUAsdWC+e3iVWSM12FHVQAWT0R10zxs2QyWuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Seltenreich 2018-02-18 11:18:43 Re: [HACKERS] MERGE SQL Statement for PG11
Previous Message David Rowley 2018-02-18 04:22:53 Re: ALTER TABLE ADD COLUMN fast default