diff options
Diffstat (limited to 'mysql-test/suite/innodb_zip/r/page_size.result')
-rw-r--r-- | mysql-test/suite/innodb_zip/r/page_size.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/innodb_zip/r/page_size.result b/mysql-test/suite/innodb_zip/r/page_size.result index 3cf6e7a7a58..90018e2c8c2 100644 --- a/mysql-test/suite/innodb_zip/r/page_size.result +++ b/mysql-test/suite/innodb_zip/r/page_size.result @@ -39,11 +39,11 @@ test/t2 5 1 PRIMARY 3 3 1 50 test/t3 5 41 PRIMARY 3 3 1 50 test/t4 5 33 PRIMARY 3 3 1 50 === information_schema.innodb_sys_tablespaces and innodb_sys_datafiles === -Space_Name Space_Type Page_Size Zip_Size Formats_Permitted Path -test/t1 Single DEFAULT DEFAULT Compact or Redundant MYSQLD_DATADIR/test/t1.ibd -test/t2 Single DEFAULT DEFAULT Compact or Redundant MYSQLD_DATADIR/test/t2.ibd -test/t3 Single DEFAULT 8192 Compressed MYSQLD_DATADIR/test/t3.ibd -test/t4 Single DEFAULT DEFAULT Dynamic MYSQLD_DATADIR/test/t4.ibd +Space_Name Space_Type Page_Size Zip_Size Path +test/t1 Single DEFAULT DEFAULT MYSQLD_DATADIR/test/t1.ibd +test/t2 Single DEFAULT DEFAULT MYSQLD_DATADIR/test/t2.ibd +test/t3 Single DEFAULT 8192 MYSQLD_DATADIR/test/t3.ibd +test/t4 Single DEFAULT DEFAULT MYSQLD_DATADIR/test/t4.ibd DROP TABLE t1, t2, t3, t4; # Test 4) The maximum row size is dependent upon the page size. # Each row format has its own amount of overhead that @@ -373,7 +373,7 @@ Table Op Msg_type Msg_text test.t1 check status OK EXPLAIN SELECT * FROM t1 WHERE b LIKE 'adfd%'; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range b b 769 NULL 12 Using where +1 SIMPLE t1 range b b 769 NULL # Using where DROP TABLE t1; # Test 8) Test creating a table that could lead to undo log overflow. CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob, |