Skip to content

[CH] Incorrect result when in-filter timestamp column with string values. #7032

@lwz9103

Description

@lwz9103

Backend

CH (ClickHouse)

Bug description

create table filter_test (account_id int, record_time date, account_user_country string, account_date date, account_time timestamp);

insert into filter_test values
(20201001, 2020-10-01, shanghai, 2020-10-01, 2020-10-01 10:10:10),  
(20201005, 2020-10-05, shanghai, 2020-10-05, 2020-10-05 10:10:10),
(20201008, 2020-10-08, beijing, 2020-10-08, 2020-10-08 10:10:10);

select * from filter_timestamp where account_time in ('2020-10-01 10:10:10', '2020-10-01 10:10:11')

gluten result is empty but spark result has 1 row.
image

image

Spark version

None

Spark configurations

No response

System information

No response

Relevant logs

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingtriage

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions