Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17860

CREATE SEQUENCE .. ENGINE=InnoDB interprets all ROW_FORMAT values except for DYNAMIC as FIXED

    XMLWordPrintable

    Details

      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")
      

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: