Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3
-
None
Description
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") |