-
Notifications
You must be signed in to change notification settings - Fork 129
Closed
Labels
bugSomething isn't workingSomething isn't workingincorrect resultBugs that return incorrect dataBugs that return incorrect datatypesIssues related to type conversionsIssues related to type conversions
Description
Description
create table t(ts timestamp, d date);
insert into t values ('infinity', 'infinity'), ('-infinity', '-infinity');
select isfinite(ts), isfinite(d) from t; -- returns false everywhere (as it should)
set duckdb.force_execution = true;
select isfinite(ts), isfinite(d) from t; -- returns true everywhere (wrong)
This is also clearly wrong:
> select * from duckdb.query($$ select 'infinity'::timestamp, 'infinity'::date $$);
CAST('infinity' AS TIMESTAMP) │ CAST('infinity' AS DATE)
───────────────────────────────┼──────────────────────────
294247-01-10 04:00:54.775807 │ 5881580-07-11
Might be related to #595
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't workingincorrect resultBugs that return incorrect dataBugs that return incorrect datatypesIssues related to type conversionsIssues related to type conversions