v.24.7Improvement
Result of SHOW INDEX now sorted by primary key column position
The result of SHOW INDEX | INDEXES | INDICES | KEYS was previously sorted by the primary key column names. Since this was unintuitive, the result is now sorted by the position of the primary key columns within the primary key. #61131 (Robert Schulze).Why it matters
Previously, the results of index listing queries were sorted by the primary key column names, which could be unintuitive for users. Sorting by the position of the columns within the primary key provides a clearer, more logical ordering that reflects the actual key structure.How to use it
Simply run the commandsSHOW INDEX, SHOW INDEXES, SHOW INDICES, or SHOW KEYS as before. The output will now be sorted by the primary key column positions automatically without requiring any additional configuration.