Query generates infinite loop

From: Richard Wesley <richard(at)duckdblabs(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Query generates infinite loop
Date: 2022-04-20 16:17:32
Message-ID: 91B44E7B-68D5-448F-95C8-B4B3B0F5DEAF@duckdblabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi All -

I was implementing the infinity time constants in DuckDB when I ran into an infinite loop. It seems that PG has the same problem for the same reason (adding an interval to an infinite timestamp produces the same timestamp, so the increment operation never goes anywhere.) Here is the query:
select COUNT(*)
FROM generate_series('-infinity'::TIMESTAMP, 'epoch'::TIMESTAMP, INTERVAL '1 DAY');

This seems like a DoS great attack, so we are disallowing infinities as bounds for both table and scalar series generation. As an upper bound, it eventually gives an error, so it seems there is not much utility anyway.

Met vriendelijke groet, best regards, mit freundlichen Grüßen,
Richard Wesley
Group-By Therapist
richard(at)duckdblabs(dot)com <mailto:richard(at)duckdblabs(dot)com>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2022-04-20 16:21:50 Re: BUG #17466: Is it possible to supplement the default compilation options of CFLAGS in configure file?
Previous Message Julien Rouhaud 2022-04-20 09:18:47 Re: Help Me! ^^ "must be superuser to make network requests"

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2022-04-20 16:53:33 Re: Query generates infinite loop
Previous Message Alvaro Herrera 2022-04-20 16:07:55 Re: generalized conveyor belt storage