[planner:1054]Unknown column 'test.t2.name' in 'expression'

[yilongrong]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
CREATE TABLE `t2` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`name` varchar(30) DEFAULT NULL ,
`create_time` datetime NOT NULL ,
PRIMARY KEY (`id`) ,
KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

create index idx_t2_name on test.t2((lower(test.t2.name)));

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

create index success

3. What did you see instead (Required)

1. ["[ddl] run DDL job error"] [worker="worker 8, tp add index"] [error="[planner:1054]Unknown column 'test.t2.name' in 'expression'"]
2. can't cancel create ddl job success.
3. we could use different index name create same column again.

4. What is your TiDB version? (Required)

v5.2.2, v6.4.0, master