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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 84a3611) | patch
Mop-up for letting VOID-returning SQL functions end with a SELECT.
2018年3月16日 16:48:13 +0000 (12:48 -0400)
2018年3月16日 16:48:13 +0000 (12:48 -0400)
commit 877cdf11eaa9cabcb9b1e3c1bef0760fe08efdc3
Mop-up for letting VOID-returning SQL functions end with a SELECT.

Part of the intent in commit fd1a421fe was to allow SQL functions that are
declared to return VOID to contain anything, including an unrelated final
SELECT, the same as SQL-language procedures can. However, the planner's
inlining logic didn't get that memo. Fix it, and add some regression tests
covering this area, since evidently we had none.

In passing, clean up some typos in comments in create_function_3.sql,
and get rid of its none-too-safe assumption that DROP CASCADE notice
output is immutably ordered.

Per report from Prabhat Sahu.

Discussion: https://postgr.es/m/CANEvxPqxAj6nNHVcaXxpTeEFPmh24Whu+23emgjiuKrhJSct0A@mail.gmail.com
src/backend/optimizer/util/clauses.c diff | blob | blame | history
src/test/regress/expected/create_function_3.out diff | blob | blame | history
src/test/regress/sql/create_function_3.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

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