different results from plpgsql functions related to last changes in master

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема different results from plpgsql functions related to last changes in master
Дата
Msg-id CAFj8pRAkpDBkgAUAsdWC+e3iVWSM12FHVQAWT0R10zxs2QyWuA@mail.gmail.com
обсуждение исходный текст
Ответы Re: different results from plpgsql functions related to last changes in master
Список 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 по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: ALTER TABLE ADD COLUMN fast default
Следующее
От: Andreas Seltenreich
Дата:
Сообщение: Re: [HACKERS] MERGE SQL Statement for PG11