pgsql: Dept of second thoughts: don't try to push LIMIT below a SRF.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Dept of second thoughts: don't try to push LIMIT below a SRF.
Дата
Msg-id E1PJ7lJ-0006xI-Mx@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Dept of second thoughts: don't try to push LIMIT below a SRF.

If we have Limit->Result->Sort, the Result might be projecting a tlist
that contains a set-returning function.  If so, it's possible for the
SRF to sometimes return zero rows, which means we could need to fetch
more than N rows from the Sort in order to satisfy LIMIT N.
So top-N sorting cannot be used in this scenario.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=48c348f86ce09c668af7cf271757c3f156f28344

Modified Files
--------------
src/backend/executor/nodeLimit.c |   15 ++++++++++++++-
1 files changed, 14 insertions(+), 1 deletions(-)


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: pgsql: Minor corrections to dummy_seclabel documentation.
Следующее
От: nanardon@pgfoundry.org (User Nanardon)
Дата:
Сообщение: pgrpm - pgrpm: - fix tag name detection