git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 7f1da18) | patch
Fix Assert failure in XMLTABLE parser
2025年5月15日 08:09:04 +0000 (17:09 +0900)
2025年5月15日 08:26:13 +0000 (17:26 +0900)
commit 666103090f1d18e26388aef1ee5840d86cb8604b
Fix Assert failure in XMLTABLE parser

In an XMLTABLE expression, columns can be marked NOT NULL, and the
parser internally fabricates an option named "is_not_null" to
represent this. However, the parser also allows users to specify
arbitrary option names. This creates a conflict: a user can
explicitly use "is_not_null" as an option name and assign it a
non-Boolean value, which violates internal assumptions and triggers an
assertion failure.

To fix, this patch checks whether a user-supplied name collides with
the internally reserved option name and raises an error if so.
Additionally, the internal name is renamed to "__pg__is_not_null" to
further reduce the risk of collision with user-defined names.

Reported-by: Евгений Горбанев <gorbanyoves@basealt.ru>
Author: Richard Guo <guofenglinux@gmail.com>
Reviewed-by: Alvaro Herrera <alvherre@kurilemu.de>
Discussion: https://postgr.es/m/6bac9886-65bf-4cec-96bd-e304159f28db@basealt.ru
Backpatch-through: 15
src/backend/parser/gram.y diff | blob | blame | history
src/test/regress/expected/xml.out diff | blob | blame | history
src/test/regress/expected/xml_1.out diff | blob | blame | history
src/test/regress/expected/xml_2.out diff | blob | blame | history
src/test/regress/sql/xml.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /