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.

Sign up for GitHub

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

Jump to bottom

deleted system table still can be get from information_schema #43714

Closed
seiya-annie opened this issue May 11, 2023 · 2 comments · Fixed by #44585
Closed

deleted system table still can be get from information_schema #43714

seiya-annie opened this issue May 11, 2023 · 2 comments · Fixed by #44585
Assignees
@tangenta
Labels
affects-6.5 affects-7.1 priority/release-blocker This issue blocks a release. Please solve it ASAP. severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@seiya-annie
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table in mysql db
drop table
check with "select * from information_schema"

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

can't find this table in information_schema

3. What did you see instead (Required)

still exist

4. What is your TiDB version? (Required)

master
@seiya-annie seiya-annie added the type/bug The issue is confirmed as a bug. label May 11, 2023
@seiya-annie
Copy link
Author

20230511-151226

@ti-chi-bot ti-chi-bot bot added 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.1 may-affects-6.5 may-affects-7.1 labels May 11, 2023
@seiya-annie seiya-annie added sig/sql-infra SIG: SQL Infra affects-7.1 and removed 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.1 may-affects-6.5 may-affects-7.1 labels May 11, 2023
@tangenta tangenta changed the title deleted system table still can be get from infomationg_schema deleted system table still can be get from information_schema May 18, 2023
@seiya-annie
Copy link
Author

tried on master and v7.1.0, this issue has not existed.

@tangenta tangenta reopened this Jun 12, 2023
@tangenta tangenta mentioned this issue Jun 12, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jun 12, 2023
@tangenta
infoschema: update raw args to make it drop correct table in `RENAME …
5d05714 
…TABLE` (#44585)

close #43714
This was referenced Jun 12, 2023
Merged
Merged
@tangenta tangenta added the priority/release-blocker This issue blocks a release. Please solve it ASAP. label Jun 12, 2023
ti-chi-bot bot pushed a commit that referenced this issue Jun 12, 2023
@ti-chi-bot
infoschema: update raw args to make it drop correct table in `RENAME …
71e6696 
…TABLE` (#44585) (#44594)

close #43714
ti-chi-bot bot pushed a commit that referenced this issue Jun 14, 2023
@ti-chi-bot
infoschema: update raw args to make it drop correct table in `RENAME …
71d95dc 
…TABLE` (#44585) (#44595)

close #43714
@ti-chi-bot ti-chi-bot mentioned this issue Jun 29, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jun 29, 2023
@ti-chi-bot
infoschema: update raw args to make it drop correct table in `RENAME …
666df2d 
…TABLE` (#44585) (#45056)

close #43714
@tiancaiamao tiancaiamao mentioned this issue Jul 18, 2023
Merged
17 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tangenta tangenta

Labels
affects-6.5 affects-7.1 priority/release-blocker This issue blocks a release. Please solve it ASAP. severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

infoschema: update raw args to make it drop correct table in RENAME TABLE tangenta/tidb
3 participants
@jebter @tangenta @seiya-annie