Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Duration filter push down cause query fail #7455

Closed
Lloyd-Pottiger opened this issue May 11, 2023 · 0 comments · Fixed by #7469
Closed

Duration filter push down cause query fail #7455

Lloyd-Pottiger opened this issue May 11, 2023 · 0 comments · Fixed by #7469
Assignees
Labels
affects-7.1 severity/major type/bug The issue is confirmed as a bug.

Comments

@Lloyd-Pottiger
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table if not exists test.t(a time(4), I int);
insert into test.t values('-700:10:10.123456', 1);
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
insert into test.t select * from test.t;
alter table test.t set tiflash replica 1;
explain analyze select * from test.t where a = '700:11:11.123500';

2. What did you expect to see? (Required)

mysql> explain analyze select * from test.t where a = '700:11:11.123500';
ERROR 1105 (HY000): other error for mpp stream: From MPP<query:<query_ts:1683783901339381008, local_query_id:3, server_id:1814245, start_ts:441393847025532929>,task_id:1>: Code: 49, e.displayText() = DB::Exception: Check schema[i].type->equals(*storage_schema[i].type) failed, schema[i].name = table_scan_0, schema[i].type->getName() = Nullable(MyDuration(4)), storage_schema[i].name = a, storage_schema[i].type->getName() = Nullable(Int64), e.what() = DB::Exception,

3. What did you see instead (Required)

success

4. What is your TiFlash version? (Required)

master

@Lloyd-Pottiger Lloyd-Pottiger added type/bug The issue is confirmed as a bug. severity/moderate affects-7.1 labels May 11, 2023
@Lloyd-Pottiger Lloyd-Pottiger self-assigned this May 11, 2023
ti-chi-bot bot pushed a commit that referenced this issue May 16, 2023
ti-chi-bot bot pushed a commit that referenced this issue May 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.1 severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
1 participant