pgsql: Fix crash when using COLLATE in partition bound expressions

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема pgsql: Fix crash when using COLLATE in partition bound expressions
Дата
Msg-id E1jM3q3-0004pF-2D@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix crash when using COLLATE in partition bound expressions

Attempting to use a COLLATE clause with a type that it not collatable in
a partition bound expression could crash the server.  This commit fixes
the code by adding more checks similar to what is done when computing
index or partition attributes by making sure that there is a collation
iff the type is collatable.

Backpatch down to 12, as 7c079d7 introduced this problem.

Reported-by: Alexander Lakhin
Author: Dmitry Dolgov
Discussion: https://postgr.es/m/16325-809194cf742313ab@postgresql.org
Backpatch-through: 12

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c0187869a0f6eb05135d388462522a593ced1b88

Modified Files
--------------
src/backend/parser/parse_utilcmd.c         | 24 ++++++++++++++++++++++++
src/test/regress/expected/create_table.out |  6 ++++++
src/test/regress/sql/create_table.sql      |  2 ++
3 files changed, 32 insertions(+)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: pgsql: Remove testing for precise LSN/reserved bytes in newTAP test
Следующее
От: David Rowley
Дата:
Сообщение: pgsql: Modify additional power 2 calculations to use new helper functio