Create table queries fail when COMPRESSION='lz4' & ROW_FORMAT=COMPRESSED are used together
General
Escalation
General
Escalation
Description
pstress generates tables which has incorrect SQLs semantically. For instance, as per PS and PXC behavior, we cannot use: COMPRESSION=lz4/zlib with ROW_FORMAT=COMPRESSED/DYNAMIC (see https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html) etc This causes a lot of table creation DDL to fail.
Medium
pstress generates tables which has incorrect SQLs semantically. For instance,
as per PS and PXC behavior, we cannot use:
COMPRESSION=lz4/zlib with ROW_FORMAT=COMPRESSED/DYNAMIC (see https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html) etc
This causes a lot of table creation DDL to fail.
Example of failing DDL:
In addition the following DDL is also failing:
Based on tests due to usage of COMPRESSION and KEY_BLOCK_SIZE. Based on https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html KEY_BLOCK_SIZE implies
ROW_FORMAT=COMPRESSED .The DDLs are run ok separately:{{}}