ClickHouse / ClickHouse/ClickHouse

`select toDateTime64(Inf, 6)` throw exception even if `date_time_overflow_behavior` is 'ignore'

Open
#69,280 0 comments 0 reactions 0 assignees View on GitHub
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:
```

image

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.