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

Result wrong for query select TABLE_SCHEMA from information_schema.tables where TIDB_TABLE_ID= xx #57657

Closed
lilinghai opened this issue Nov 25, 2024 · 0 comments · Fixed by #57746
Closed

Result wrong for query select TABLE_SCHEMA from information_schema.tables where TIDB_TABLE_ID= xx #57657

lilinghai opened this issue Nov 25, 2024 · 0 comments · Fixed by #57746
Assignees
@tiancaiamao
Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. impact/wrong-result severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@lilinghai
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

image

-- return all schema names
select TABLE_SCHEMA from information_schema.tables where TIDB_TABLE_ID=4611686018427387967;

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

8.5 master
@lilinghai lilinghai added the type/bug The issue is confirmed as a bug. label Nov 25, 2024
@tiancaiamao tiancaiamao self-assigned this Nov 25, 2024
@jebter jebter added the sig/sql-infra SIG: SQL Infra label Nov 26, 2024
@tiancaiamao tiancaiamao mentioned this issue Nov 27, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Nov 27, 2024
@tiancaiamao
executor: fix query infoschema.tables table_schema/table_name with fi…
09d12f0 
…lter condition (#57746)

close #57657
@ti-chi-bot ti-chi-bot mentioned this issue Nov 27, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Nov 29, 2024
@ti-chi-bot
executor: fix query infoschema.tables table_schema/table_name with fi…
bfa61d2 
…lter condition (#57746) (#57771)

close #57657
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tiancaiamao tiancaiamao

Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. impact/wrong-result 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.

executor: fix query infoschema.tables table_schema/table_name with filter condition tiancaiamao/tidb
3 participants
@tiancaiamao @jebter @lilinghai