|
MariaDB [test]> create sequence s engine=InnoDB;
|
Query OK, 0 rows affected (0.11 sec)
|
|
MariaDB [test]> show table status like 's' \G
|
*************************** 1. row ***************************
|
Name: s
|
Engine: InnoDB
|
Version: 10
|
Row_format: Fixed
|
Rows: 1
|
Avg_row_length: 16384
|
Data_length: 16384
|
Max_data_length: 0
|
Index_length: 0
|
Data_free: 0
|
Auto_increment: NULL
|
Create_time: 2018-11-28 10:44:19
|
Update_time: NULL
|
Check_time: NULL
|
Collation: latin1_swedish_ci
|
Checksum: NULL
|
Create_options:
|
Comment:
|
Max_index_length: 0
|
Temporary: N
|
1 row in set (0.00 sec)
|
MariaDB [test]> create sequence s2 engine=InnoDB row_format=COMPACT;
|
Query OK, 0 rows affected (0.13 sec)
|
|
MariaDB [test]> show table status like 's2' \G
|
*************************** 1. row ***************************
|
Name: s2
|
Engine: InnoDB
|
Version: 10
|
Row_format: Fixed
|
Rows: 1
|
Avg_row_length: 16384
|
Data_length: 16384
|
Max_data_length: 0
|
Index_length: 0
|
Data_free: 0
|
Auto_increment: NULL
|
Create_time: 2018-11-28 10:44:40
|
Update_time: NULL
|
Check_time: NULL
|
Collation: latin1_swedish_ci
|
Checksum: NULL
|
Create_options: row_format=COMPACT
|
Comment:
|
Max_index_length: 0
|
Temporary: N
|
1 row in set (0.09 sec)
|
MariaDB [test]> create sequence s3 engine=InnoDB row_format=REDUNDANT;
|
Query OK, 0 rows affected (0.09 sec)
|
|
MariaDB [test]> show table status like 's3' \G
|
*************************** 1. row ***************************
|
Name: s3
|
Engine: InnoDB
|
Version: 10
|
Row_format: Fixed
|
Rows: 1
|
Avg_row_length: 16384
|
Data_length: 16384
|
Max_data_length: 0
|
Index_length: 0
|
Data_free: 0
|
Auto_increment: NULL
|
Create_time: 2018-11-28 10:45:04
|
Update_time: NULL
|
Check_time: NULL
|
Collation: latin1_swedish_ci
|
Checksum: NULL
|
Create_options: row_format=REDUNDANT
|
Comment:
|
Max_index_length: 0
|
Temporary: N
|
1 row in set (0.08 sec)
|
MariaDB [test]> create sequence s4 engine=InnoDB row_format=COMPRESSED;
|
Query OK, 0 rows affected (0.13 sec)
|
|
MariaDB [test]> show table status like 's4' \G
|
*************************** 1. row ***************************
|
Name: s4
|
Engine: InnoDB
|
Version: 10
|
Row_format: Fixed
|
Rows: 1
|
Avg_row_length: 8192
|
Data_length: 8192
|
Max_data_length: 0
|
Index_length: 0
|
Data_free: 0
|
Auto_increment: NULL
|
Create_time: 2018-11-28 10:45:25
|
Update_time: NULL
|
Check_time: NULL
|
Collation: latin1_swedish_ci
|
Checksum: NULL
|
Create_options: row_format=COMPRESSED
|
Comment:
|
Max_index_length: 0
|
Temporary: N
|
1 row in set (0.07 sec)
|
MariaDB [test]> create sequence s5 engine=InnoDB row_format=DYNAMIC;
|
Query OK, 0 rows affected (0.11 sec)
|
|
MariaDB [test]> show table status like 's5' \G
|
*************************** 1. row ***************************
|
Name: s5
|
Engine: InnoDB
|
Version: 10
|
Row_format: Dynamic
|
Rows: 1
|
Avg_row_length: 16384
|
Data_length: 16384
|
Max_data_length: 0
|
Index_length: 0
|
Data_free: 0
|
Auto_increment: NULL
|
Create_time: 2018-11-28 10:45:39
|
Update_time: NULL
|
Check_time: NULL
|
Collation: latin1_swedish_ci
|
Checksum: NULL
|
Create_options: row_format=DYNAMIC
|
Comment:
|
Max_index_length: 0
|
Temporary: N
|
1 row in set (0.07 sec)
|
So, most of ROW_FORMAT values are converted to Fixed (or at least are displayed as such). However, the explicit FIXED value is expectedly rejected:
MariaDB [test]> create sequence s7 engine=InnoDB row_format=FIXED;
|
ERROR 1005 (HY000): Can't create table `test`.`s7` (errno: 140 "Wrong create options")
|
|