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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions