Skip to content

Cast int as time may produce wront result #1764

@leiysky

Description

@leiysky

Minimal reproduce:

create table t (a int);
insert into t values(65535);
alter table t set tiflash replica 1;
set session tidb_isolation_read_engines='tiflash';
select * from t where cast(a as datetime);
# expect empty but get 65535

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions