Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5, 10.6, 10.0.2, 5.5.31, 5.1.67, 5.2.14, 5.3.12, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL)
-
Gentoo linux - Mariadb-5.5.31-log
Windows 7 - MariaDB-5.5.28
Description
Hi,
I'm trying to get index info from information_schema.statistics
but, if I try to get collation field, it always returns null.
Test case
create table test.some_table (field1 int unsigned not null, field2 varchar(64), primary key (field1), key(field2)); |
|
/* collation with their correct value */
|
select * from information_schema.STATISTICS where table_name='some_table' and table_schema='test'; |
|
/* collation is null here */
|
select table_schema, table_name, index_name, column_name, collation |
from information_schema.STATISTICS |
where table_schema='test' and table_name='some_table'; |
|
/* collation (quoted) is null here */
|
select table_schema, table_name, index_name, column_name, `collation` |
from information_schema.STATISTICS |
where table_schema='test' and table_name='some_table'; |
Attachments
Issue Links
- relates to
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
- Closed
- links to