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

Fail to analyze table after creating index #55438

Closed
Nickelth opened this issue Aug 15, 2024 · 0 comments · Fixed by #55447
Closed

Fail to analyze table after creating index #55438

Nickelth opened this issue Aug 15, 2024 · 0 comments · Fixed by #55447
Assignees
Labels
affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@Nickelth
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE t0(c0 NUMERIC , c1 BIGINT UNSIGNED  AS ((CASE 0 WHEN false THEN 1358571571 ELSE TRIM(c0) END )));

CREATE INDEX i0 ON t0(c1);
ANALYZE TABLE t0;

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

mysql> ANALYZE TABLE t0;
Query OK, 0 rows affected, 2 warnings (0.08 sec)

3. What did you see instead (Required)

mysql> ANALYZE TABLE t0;
ERROR 1054 (42S22): Unknown column 'c0' in 'expression'

4. What is your TiDB version? (Required)

 Release Version: v8.3.0-alpha-50-gb59f5ecb47-dirty
Edition: Community
Git Commit Hash: b59f5ecb472d831f867b079e0a409caef9f4a290
Git Branch: master
UTC Build Time: 2024-07-31 18:41:32
GoVersion: go1.22.5
Race Enabled: false
Check Table Before Drop: false
Store: tikv

tikv sets up with partitioned raft kv

@Nickelth Nickelth added the type/bug The issue is confirmed as a bug. label Aug 15, 2024
@hawkingrei hawkingrei self-assigned this Aug 15, 2024
@ti-chi-bot ti-chi-bot bot closed this as completed in db54a3b Aug 19, 2024
@ti-chi-bot ti-chi-bot added affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. labels Aug 20, 2024
@winoros winoros removed the affects-6.5 This bug affects the 6.5.x(LTS) versions. label Sep 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants