Skip to content

rename tables causes duplicated row in information_schema.columns  #47064

@wjhuang2016

Description

@wjhuang2016

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t1(a int);
create table t2(a int);
create table t3(a int);
create database test1;
rename table test.t1 to test1.t1, test.t2 to test1.t2, test.t3 to test1.t3;
select column_name from information_schema.columns where table_name = 't1';

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

+-------------+
| column_name |
+-------------+
| a           |
+-------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

+-------------+
| column_name |
+-------------+
| a           |
| a           |
+-------------+

4. What is your TiDB version? (Required)

master

Metadata

Metadata

Assignees

Labels

affects-5.3This bug affects 5.3.x versions.affects-5.4This bug affects the 5.4.x(LTS) versions.affects-6.1This bug affects the 6.1.x(LTS) versions.affects-6.5This bug affects the 6.5.x(LTS) versions.affects-7.1This bug affects the 7.1.x(LTS) versions.component/ddlThis issue is related to DDL of TiDB.report/customerCustomers have encountered this bug.severity/moderatetype/bugThe issue is confirmed as a bug.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions