Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4621

select returns null for information_schema.statistics.collation field.

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.2, 5.5.31, 5.1.67, 5.2.14, 5.3.12
        • Fix Version/s: 10.0, 5.5
        • Component/s: None
        • Labels:
        • Environment:
          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';

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #65121 - Inconsistent results for select on INFORMATION_SCHEMA.STATISTICS

                  Activity

                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Also reproducible on all of MySQL 5.1 - 5.7 (MySQL bug #65121)

                  Show
                  elenst Elena Stepanova added a comment - Also reproducible on all of MySQL 5.1 - 5.7 (MySQL bug #65121)

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      lucianobarcaro Luciano Barcaro
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated: