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

INFORMATION_SCHEMA.INNODB_SYS_TABLES - N_COLS is incorrect

    XMLWordPrintable

Details

    Description

      MariaDB [information_schema]> create table test.t( i int);
      Query OK, 0 rows affected (0.007 sec)
       
      MariaDB [information_schema]> create table test.t1( i int primary key);
      Query OK, 0 rows affected (0.005 sec)
       
      MariaDB [information_schema]> select * from INNODB_SYS_TABLES;
      +----------+----------------------------+------+--------+-------+------------+---------------+------------+
      | TABLE_ID | NAME                       | FLAG | N_COLS | SPACE | ROW_FORMAT | ZIP_PAGE_SIZE | SPACE_TYPE |
      +----------+----------------------------+------+--------+-------+------------+---------------+------------+
      |       20 | test/t                     |   33 |      4 |     5 | Dynamic    |             0 | Single     |
      |       21 | test/t1                    |   33 |      4 |     6 | Dynamic    |             0 | Single     |
      

      Attachments

        Issue Links

          Activity

            People

              greenman Ian Gilfillan
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.