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

ROW_FORMAT column in I_S.INNODB_SYS_TABLESPACES is NULL for innodb_checksum_algorithm=full_crc32 tablespaces

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5, 10.6, 10.11, 11.1(EOL), 11.2, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.3(EOL)
    • N/A
    • None

    Description

      ROW_FORMAT column is NULL in information_schema.innodb_sys_tablespaces starting from 10.6. Should be documented

      I think it is related to MDEV-22343

      "Remove SYS_TABLESPACES and SYS_DATAFILES"
      "For compatibility with older versions, we might want to preserve the INFORMATION_SCHEMA views, but make them reflect the fil_system cache."

      It should be documented, that the value of column ROW_FORMAT in information_schema.innodb_sys_tablespaces is always "NULL" in 10.6

      MariaDB [d1]> create table t1 (id int);
      Query OK, 0 rows affected (0.061 sec)
       
      MariaDB [d1]> select * from information_schema.innodb_sys_tablespaces where name = "d1/t1";
      +-------+-------+------+------------+-----------+-------------+---------------+-----------+----------------+
      | SPACE | NAME  | FLAG | ROW_FORMAT | PAGE_SIZE | FILENAME    | FS_BLOCK_SIZE | FILE_SIZE | ALLOCATED_SIZE |
      +-------+-------+------+------------+-----------+-------------+---------------+-----------+----------------+
      |    20 | d1/t1 |   21 |       NULL |     16384 | ./d1/t1.ibd |          4096 |     65536 |          65536 |
      +-------+-------+------+------------+-----------+-------------+---------------+-----------+----------------+
      1 row in set (0.002 sec) 
      

      Attachments

        Issue Links

          Activity

            People

              greenman Ian Gilfillan
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.