Re: Query generates infinite loop

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