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

              Assignee:
              serg Sergei Golubchik
              Reporter:
              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.