diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/default_row_format_compatibility.result')
-rw-r--r-- | mysql-test/suite/innodb/r/default_row_format_compatibility.result | 38 |
1 files changed, 12 insertions, 26 deletions
diff --git a/mysql-test/suite/innodb/r/default_row_format_compatibility.result b/mysql-test/suite/innodb/r/default_row_format_compatibility.result index e9c82d225b4..5070fa33a2e 100644 --- a/mysql-test/suite/innodb/r/default_row_format_compatibility.result +++ b/mysql-test/suite/innodb/r/default_row_format_compatibility.result @@ -1,9 +1,4 @@ SET @row_format = @@GLOBAL.innodb_default_row_format; -SET @large_prefix = @@GLOBAL.innodb_large_prefix; -SET @file_format = @@GLOBAL.innodb_file_format; -SET GLOBAL innodb_file_format = barracuda; -Warnings: -Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/ # ########################################################### # Check with Import/Export tablespace with Default_row_format SET GLOBAL innodb_default_row_format=Compact; @@ -15,8 +10,8 @@ SELECT @@innodb_file_per_table; 1 CREATE TABLE tab(a INT) ENGINE=InnoDB; SHOW TABLE STATUS LIKE 'tab'; -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment -tab InnoDB # Compact # # # # # # NULL # NULL NULL latin1_swedish_ci NULL +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary +tab InnoDB # Compact # # # # # # NULL # NULL NULL latin1_swedish_ci NULL 0 N INSERT INTO tab VALUES(1); INSERT INTO tab VALUES(2); SELECT * FROM tab; @@ -38,8 +33,8 @@ SELECT @@innodb_default_row_format; compact CREATE TABLE tab(a INT) ENGINE=InnoDB; SHOW TABLE STATUS LIKE 'tab'; -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment -tab InnoDB # Compact # # # # # # NULL # NULL NULL latin1_swedish_ci NULL +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary +tab InnoDB # Compact # # # # # # NULL # NULL NULL latin1_swedish_ci NULL 0 N ALTER TABLE tab DISCARD TABLESPACE; call mtr.add_suppression("InnoDB: Tried to read .* bytes at offset 0"); ALTER TABLE tab IMPORT TABLESPACE; @@ -52,16 +47,13 @@ a DROP TABLE tab; # ########################################################### SET GLOBAL innodb_default_row_format=Dynamic; -SET GLOBAL innodb_large_prefix=ON; -Warnings: -Warning 131 Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/ SELECT @@innodb_default_row_format; @@innodb_default_row_format dynamic CREATE TABLE tab(a INT PRIMARY KEY, b VARCHAR(5000), KEY idx1(b(3070))) ENGINE= InnoDB; SHOW TABLE STATUS LIKE 'tab'; -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment -tab InnoDB # Dynamic # # # # # # NULL # NULL NULL latin1_swedish_ci NULL +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary +tab InnoDB # Dynamic # # # # # # NULL # NULL NULL latin1_swedish_ci NULL 0 N INSERT INTO tab(a,b) VALUES(1,'Check with max column size'); SELECT * FROM tab; a b @@ -80,16 +72,16 @@ SELECT @@innodb_default_row_format; dynamic CREATE TABLE tab(a INT PRIMARY KEY, b VARCHAR(5000), KEY idx1(b(767))) ENGINE= InnoDB; SHOW TABLE STATUS LIKE 'tab'; -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment -tab InnoDB # Dynamic # # # # # # NULL # NULL NULL latin1_swedish_ci NULL +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary +tab InnoDB # Dynamic # # # # # # NULL # NULL NULL latin1_swedish_ci NULL 0 N INSERT INTO tab(a,b) VALUES(1,'Check with max column size'); SELECT * FROM tab; a b 1 Check with max column size ALTER TABLE tab ROW_FORMAT=COMPACT; SHOW TABLE STATUS LIKE 'tab'; -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment -tab InnoDB # Compact # # # # # # NULL # NULL NULL latin1_swedish_ci NULL row_format=COMPACT +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary +tab InnoDB # Compact # # # # # # NULL # NULL NULL latin1_swedish_ci NULL row_format=COMPACT 0 N SELECT * FROM tab; a b 1 Check with max column size @@ -99,13 +91,7 @@ a b 1 Check with max column size ALTER TABLE tab ROW_FORMAT=Dynamic; SHOW TABLE STATUS LIKE 'tab'; -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment -tab InnoDB # Dynamic # # # # # # NULL # NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary +tab InnoDB # Dynamic # # # # # # NULL # NULL NULL latin1_swedish_ci NULL row_format=DYNAMIC 0 N DROP TABLE tab; SET GLOBAL innodb_default_row_format = @row_format; -SET GLOBAL innodb_large_prefix = @large_prefix; -Warnings: -Warning 131 Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/ -SET GLOBAL innodb_file_format = @file_format; -Warnings: -Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/ |