Re: Query generates infinite loop

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Query generates infinite loop
Дата
Msg-id CAMkU=1yp1S5cwj_e762D_tNHT5w=ZKDB3k6UCmSaTkbnddSwOA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Query generates infinite loop  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Query generates infinite loop  (Corey Huinker <corey.huinker@gmail.com>)
Список pgsql-hackers
On Wed, Apr 20, 2022 at 5:43 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
I wrote:
> it's true that infinities as generate_series endpoints are going
> to work pretty oddly, so I agree with the idea of forbidding 'em.

> Numeric has infinity as of late, so the numeric variant would
> need to do this too.

Oh --- looks like numeric generate_series() already throws error for
this, so we should just make the timestamp variants do the same.

The regression test you added for this change causes an infinite loop when run against an unpatched server with --install-check.  That is a bit unpleasant.  Is there something we can and should do about that?  I was expecting regression test failures of course but not an infinite loop leading towards disk exhaustion.

Cheers,

Jeff

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: fix cost subqueryscan wrong parallel cost
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: SQL/JSON: FOR ORDINALITY bug