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

Add one more column in information_schema.indexes table to indicate it's a global index or not. #53342

Closed
Tracked by #45133
Defined2014 opened this issue May 17, 2024 · 2 comments · Fixed by #53345
Closed
Tracked by #45133

Add one more column in information_schema.indexes table to indicate it's a global index or not. #53342

Defined2014 opened this issue May 17, 2024 · 2 comments · Fixed by #53345
Assignees
@Defined2014
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@Defined2014
Copy link
Contributor

No description provided.

@Defined2014 Defined2014 mentioned this issue May 17, 2024
Open
20 tasks
@Defined2014 Defined2014 self-assigned this May 17, 2024
@Defined2014 Defined2014 added the type/enhancement The issue or PR belongs to an enhancement. label May 17, 2024
@Defined2014
Copy link
Contributor Author

Defined2014 commented May 17, 2024 •
edited
Loading

show index also could add this column, but doesn't it behave better like MySQL? If it's different with MySQL, maybe will make compatibility issues. /cc @mjonss

@Defined2014 Defined2014 mentioned this issue May 17, 2024
Merged
13 tasks
@mjonss
Copy link
Contributor

mjonss commented May 17, 2024

show index also could add this column, but doesn't it behave better like MySQL? If it's different with MySQL, maybe will make compatibility issues.

@Defined2014 I agree to not change show index to include this, we can reconsider if there are user/customer requests for it. Generally one should use information_schema.tidb_indexes, similar to one would use information_schema.innodb_indexes.

ti-chi-bot bot pushed a commit that referenced this issue May 17, 2024
@Defined2014
executor: add a new column is_global into `information_schema.tidb_…
f5ac93e 
…indexes` table (#53345)

close #53342
terry1purcell pushed a commit to terry1purcell/tidb that referenced this issue May 17, 2024
@Defined2014 @terry1purcell
executor: add a new column is_global into `information_schema.tidb_…
c9b77d4 
…indexes` table (pingcap#53345)

close pingcap#53342
RidRisR pushed a commit to RidRisR/tidb that referenced this issue May 23, 2024
@Defined2014 @RidRisR
executor: add a new column is_global into `information_schema.tidb_…
d40ce20 
…indexes` table (pingcap#53345)

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

@Defined2014 Defined2014

Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

executor: add a new column is_global into information_schema.tidb_indexes table Defined2014/tidb
2 participants
@mjonss @Defined2014