diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-system-table-view.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-system-table-view.result | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-system-table-view.result b/mysql-test/suite/innodb/r/innodb-system-table-view.result index 85f0563437b..e8d21703844 100644 --- a/mysql-test/suite/innodb/r/innodb-system-table-view.result +++ b/mysql-test/suite/innodb/r/innodb-system-table-view.result @@ -81,17 +81,17 @@ CREATE TABLE t_compact (a INT KEY, b TEXT) ROW_FORMAT=COMPACT ENGINE=innodb; CREATE TABLE t_compressed (a INT KEY, b TEXT) ROW_FORMAT=COMPRESSED ENGINE=innodb KEY_BLOCK_SIZE=2; CREATE TABLE t_dynamic (a INT KEY, b TEXT) ROW_FORMAT=DYNAMIC ENGINE=innodb; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === -Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type -test/t_compact test/t_compact 1 5 Compact 0 Single -test/t_compressed test/t_compressed 37 5 Compressed 2048 Single -test/t_dynamic test/t_dynamic 33 5 Dynamic 0 Single -test/t_redundant test/t_redundant 0 5 Redundant 0 Single +Table Name Tablespace Table Flags Columns Row Format Zip Size +test/t_compact test/t_compact 1 5 Compact 0 +test/t_compressed test/t_compressed 37 5 Compressed 2048 +test/t_dynamic test/t_dynamic 33 5 Dynamic 0 +test/t_redundant test/t_redundant 0 5 Redundant 0 === information_schema.innodb_sys_tablespaces and innodb_sys_datafiles === -Space_Name Space_Type Page_Size Zip_Size Path -test/t_redundant Single DEFAULT DEFAULT MYSQLD_DATADIR/test/t_redundant.ibd -test/t_compact Single DEFAULT DEFAULT MYSQLD_DATADIR/test/t_compact.ibd -test/t_compressed Single DEFAULT 2048 MYSQLD_DATADIR/test/t_compressed.ibd -test/t_dynamic Single DEFAULT DEFAULT MYSQLD_DATADIR/test/t_dynamic.ibd +Space_Name Page_Size Zip_Size Path +test/t_redundant DEFAULT DEFAULT MYSQLD_DATADIR/test/t_redundant.ibd +test/t_compact DEFAULT DEFAULT MYSQLD_DATADIR/test/t_compact.ibd +test/t_compressed DEFAULT 2048 MYSQLD_DATADIR/test/t_compressed.ibd +test/t_dynamic DEFAULT DEFAULT MYSQLD_DATADIR/test/t_dynamic.ibd DROP TABLE t_redundant, t_compact, t_compressed, t_dynamic; SELECT count(*) FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS; count(*) |