pgsql: tablefunc: Reject negative number of tuples passed to normal_ran

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема pgsql: tablefunc: Reject negative number of tuples passed to normal_ran
Дата
Msg-id E1khvp1-0002nB-An@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
tablefunc: Reject negative number of tuples passed to normal_rand()

The function converted the first argument i.e. the number of tuples to
return into an unsigned integer which turns out to be huge number when
a negative value is passed.  This causes the function to take much
longer time to execute.  Instead, reject a negative value.

(If someone really wants to generate many more result rows, they
should consider adding a bigint or numeric variant.)

While at it, improve SQL test to test the number of tuples returned by
this function.

Author: Ashutosh Bapat <ashutosh.bapat@2ndquadrant.com>
Discussion: https://www.postgresql.org/message-id/CAG-ACPW3PUUmSnM6cLa9Rw4BEC5cEMKjX8Gogc8gvQcT3cYA1A@mail.gmail.com

Branch
------
master

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

Modified Files
--------------
contrib/tablefunc/expected/tablefunc.out | 11 +++++++----
contrib/tablefunc/sql/tablefunc.sql      |  4 +++-
contrib/tablefunc/tablefunc.c            |  9 ++++++++-
3 files changed, 18 insertions(+), 6 deletions(-)


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: doc: Fix typos
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Avoid spamming the client with multiple ParameterStatus messages