Re: Query generates infinite loop

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: Query generates infinite loop
Дата
Msg-id CADkLM=dDM4TjiiBop4JWKz0jGk-XRX1nAovQd5cmzTODNbCr-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query generates infinite loop  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: Query generates infinite loop  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, May 4, 2022 at 3:01 PM Jeff Janes <jeff.janes@gmail.com> wrote:
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: should check interrupts in BuildRelationExtStatistics ?
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: bogus: logical replication rows/cols combinations