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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ed345c2) | patch
MERGE ... DO NOTHING: require SELECT privileges
2024年2月21日 16:18:52 +0000 (17:18 +0100)
2024年2月21日 16:18:52 +0000 (17:18 +0100)
commit 4989ce72644b9d636b9b23c7a1719a405e62670b
MERGE ... DO NOTHING: require SELECT privileges

Verify that a user running MERGE with a DO NOTHING clause has
privileges to read the table, even if no columns are referenced. Such
privileges were already required if the ON clause or any of the WHEN
conditions referenced any column at all, so there's no functional change
in practice.

This change fixes an assertion failure in the case where no column is
referenced by the command and the WHEN clauses are all DO NOTHING.

Backpatch to 15, where MERGE was introduced.

Reported-by: Alena Rybakina <a.rybakina@postgrespro.ru>
Reported-by: Alexander Lakhin <exclusion@gmail.com>
Discussion: https://postgr.es/m/4d65a385-7efa-4436-a825-0869f89d9d92@postgrespro.ru
src/backend/parser/parse_merge.c diff | blob | blame | history
src/test/regress/expected/merge.out diff | blob | blame | history
src/test/regress/sql/merge.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

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