|
--source include/have_innodb.inc
|
|
SET @file_format= @@innodb_file_format;
|
SET GLOBAL innodb_file_format= Barracuda;
|
|
CREATE TABLE t1 (a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
|
SHOW WARNINGS;
|
query_vertical SHOW TABLE STATUS LIKE 't1';
|
|
# Cleanup
|
DROP TABLE t1;
|
SET GLOBAL innodb_file_format= @file_format;
|
|
10.1 f1bcfbb4373
|
CREATE TABLE t1 (a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
|
Warnings:
|
Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=COMPACT.
|
|
SHOW TABLE STATUS LIKE 't1';
|
Name t1
|
Engine InnoDB
|
Version 10
|
Row_format Dynamic
|
...
|
So, the warning says that the assumed format is COMPACT, but the created table has format Dynamic (or pretends to, see MDEV-17161).
|