Re: BUG #16242: convert_tuple_* not handling missing values correctly
От | Andres Freund |
---|---|
Тема | Re: BUG #16242: convert_tuple_* not handling missing values correctly |
Дата | |
Msg-id | 20200205021933.c4wtkpcx2li3um2k@alap3.anarazel.de обсуждение исходный текст |
Ответ на | Re: BUG #16242: convert_tuple_* not handling missing values correctly (Vik Fearing <vik@postgresfriends.org>) |
Ответы |
Re: BUG #16242: convert_tuple_* not handling missing values correctly
|
Список | pgsql-bugs |
On 2020-02-05 03:03:04 +0100, Vik Fearing wrote: > On 04/02/2020 03:24, PG Bug reporting form wrote: > > The following example shows a tuple appearing with NULLs in a column > > declared NOT NULL, because there is a missing default value not being filled > > in. The cause is that convert_tuples_by_name, or more precisely > > check_attrmap_match, thinks that it's enough for the tupdescs to match up as > > regards attnums/names/types, without considering that the source tupdesc > > might have missing values that the destination does not. So it incorrectly > > concludes that no conversion is needed, and the missing values become > > null. > > Here is a quick patch that fixes this on master. Should include a regression test... - Andres
В списке pgsql-bugs по дате отправления: