pgsql: Fix bug with whole-row references to append subplans.
От | Tom Lane |
---|---|
Тема | pgsql: Fix bug with whole-row references to append subplans. |
Дата | |
Msg-id | E1X5k0Q-0000Oj-1D@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Fix bug with whole-row references to append subplans. ExecEvalWholeRowVar incorrectly supposed that it could "bless" the source TupleTableSlot just once per query. But if the input is coming from an Append (or, perhaps, other cases?) more than one slot might be returned over the query run. This led to "record type has not been registered" errors when a composite datum was extracted from a non-blessed slot. This bug has been there a long time; I guess it escaped notice because when dealing with subqueries the planner tends to expand whole-row Vars into RowExprs, which don't have the same problem. It is possible to trigger the problem in all active branches, though, as illustrated by the added regression test. Branch ------ REL9_1_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/c45841f9e199a05c95cb8af51ebc97470fec17b8 Modified Files -------------- src/backend/executor/execQual.c | 33 ++++++++++++++++++------------- src/test/regress/expected/subselect.out | 18 +++++++++++++++++ src/test/regress/sql/subselect.sql | 10 ++++++++++ 3 files changed, 47 insertions(+), 14 deletions(-)
В списке pgsql-committers по дате отправления: