Bug #89169 ROW_FORMAT Inconsistence.

• Submitted: 10 Jan 2018 13:54
• Modified: 10 Jan 2018 16:01
• Reporter: Divya Madhiyazhagan
• Status: Not a Bug
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.5.50
• OS: Any
• CPU Architecture: Any

[10 Jan 2018 13:54] Divya Madhiyazhagan

Description:
I have created a table with ROW_FORMAT=DYNAMIC. When I execute "show create table tableName", it displays "ROW_FORMAT=DYNAMIC" which is good. whereas when I execute "show table status where name = tableName", it shows the value of Row_Format column as "Compact".

How to repeat:
Step 1 - Execute "create table test_format(fId BIGINT) ROW_FORMAT=DYNAMIC;"
Step 2 - Execute "show create table test_format;" - works good.
Step 3 - Execute "show table status where name = 'test_format';" - shows row_format as 'Compact'

[10 Jan 2018 16:01] MySQL Verification Team

Thank you for the bug report.

Your MySQL connection id is 1
Server version: 5.5.60 Source distribution 2018-JAN-03

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.5 > CREATE DATABASE k;
Query OK, 1 row affected (0.05 sec)

mysql 5.5 > USE k
Database changed
mysql 5.5 > create table test_format(fId BIGINT) ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected, 2 warnings (0.20 sec)

mysql 5.5 > SHOW WARNINGS;
+---------+------+--------------------------------------------------------------------+
| Level   | Code | Message                                                            |
+---------+------+--------------------------------------------------------------------+
| Warning | 1478 | InnoDB: ROW_FORMAT=DYNAMIC requires innodb_file_format > Antelope. |
| Warning | 1478 | InnoDB: assuming ROW_FORMAT=COMPACT.                               |
+---------+------+--------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql 5.5 > show variables like 'innodb_file_format';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| innodb_file_format | Antelope |
+--------------------+----------+
1 row in set (0.00 sec)

mysql 5.5 > DROP table test_format;
Query OK, 0 rows affected (0.06 sec)

mysql 5.5 > SET GLOBAL innodb_file_format=Barracuda;
Query OK, 0 rows affected (0.00 sec)

mysql 5.5 > create table test_format(fId BIGINT) ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.21 sec)

mysql 5.5 > show create table test_format;
+-------------+----------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table                                                                                                         |
+-------------+----------------------------------------------------------------------------------------------------------------------+
| test_format | CREATE TABLE `test_format` (
  `fId` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC |
+-------------+----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql 5.5 > show table status where name = 'test_format'\G
*************************** 1. row ***************************
           Name: test_format
         Engine: InnoDB
        Version: 10
     Row_format: Dynamic
           Rows: 0
 Avg_row_length: 0
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2018-01-10 13:55:23
    Update_time: NULL
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options: row_format=DYNAMIC
        Comment:
1 row in set (0.00 sec)

mysql 5.5 >