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

auto analyze of partition table is not triggered after adding index #41638

Closed
xuyifangreeneyes opened this issue Feb 21, 2023 · 0 comments · Fixed by #41639
Closed

auto analyze of partition table is not triggered after adding index #41638

xuyifangreeneyes opened this issue Feb 21, 2023 · 0 comments · Fixed by #41639

Comments

@xuyifangreeneyes
Copy link
Contributor

xuyifangreeneyes commented Feb 21, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
create table t (a int, b int) partition by range (a) (PARTITION p0 VALUES LESS THAN (2000), PARTITION p1 VALUES LESS THAN MAXVALUE);
-- insert more than 1000 rows into each partition
analyze table t;
alter table t add index idx(a);
show analyze status; -- observe whether auto analyze is triggered after adding the index

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

Auto analyze is triggered after adding the index.

3. What did you see instead (Required)

Auto analyze is not triggered after adding the index.

4. What is your TiDB version? (Required)

master

@xuyifangreeneyes xuyifangreeneyes added the type/bug This issue is a bug. label Feb 21, 2023
@xuyifangreeneyes xuyifangreeneyes self-assigned this Feb 21, 2023
@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 labels Feb 22, 2023
@chrysan chrysan removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 labels Feb 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
4 participants