Skip to content

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

@taiyang-li

Description

@taiyang-li

(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

Metadata

Metadata

Assignees

No one assigned

    Labels

    unexpected behaviourResult is unexpected, but not entirely wrong at the same time.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions