Subtraction from infinity of TIMESTAMPTZ returns a finite value #5971
Description
What happens?
Subtraction from infinity of TIMESTAMPTZ returns a finite value.
To Reproduce
D select 'infinity'::timestamptz - '1 second'::interval;
┌───────────────────────────────────────────────────────────────────────────────┐
│ (CAST('infinity' AS TIMESTAMP WITH TIME ZONE) - CAST('1 second' AS INTERVAL)) │
│ timestamp with time zone │
├───────────────────────────────────────────────────────────────────────────────┤
│ 294247-01-10 04:00:53.776807+00 │
└───────────────────────────────────────────────────────────────────────────────┘OS:
Ubuntu 22.04 on WSL2 of Windows 11 Home
DuckDB Version:
v0.6.2-dev1283 99681d8
DuckDB Client:
CLI
Full Name:
Koki Ueha
Affiliation:
None
Have you tried this on the latest master branch?
- I agree
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- I agree