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

select returns null for information_schema.statistics.collation field

    XMLWordPrintable

Details

    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

          Activity

            People

              serg Sergei Golubchik
              lucianobarcaro Luciano Barcaro
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.