Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache
Дата
Msg-id CAMkU=1xa0+0LKQj9JgpE8wsjp6X1-XdTCDvcJicEpbp_ocZE+g@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
On Tue, May 12, 2020 at 11:33 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

        MINVALUE 0
        MAXVALUE 79999
        CYCLE

... 
 
Additionally if CACHE is set to > 80000 (e.g. 100000) the query always
returns 0.

Since you told it the maxval was 79999 and to CYCLE, were you expecting something else to happen?  What do you think the desired behavior would be?

Cheers,

Jeff

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache
Следующее
От:
Дата:
Сообщение: RE: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache