ClickHouse / ClickHouse/ClickHouse
`select toDateTime64(Inf, 6)` throw exception even if `date_time_overflow_behavior` is 'ignore'
Open
comp-datetime
external
unexpected behaviour
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
(you don't have to strictly follow this form)
**Company or project name**
BIGO. Apache Gluten
**Describe the unexpected behaviour**
Summary: CH `select toDateTime64(Inf, 6)` throws exception while spark `select timestamp_seconds(1/0)` returns null.
`select toDateTime64(Inf, 6)` throw exception even if `date_time_overflow_behavior` is 'ignore'
```
Code: 407. DB::Exception: Received from localhost:9001. DB::Exception: DateTime64 convert overflow. Cannot convert infinity or NaN to decimal: In scope SELECT toDateTime64(nan, 6). Stack trace:
```
Contributor guide
Assessment
This issue has not been assessed yet.