A bit more simplified test case to reproduce this problem
CREATE COMPRESSION_DICTIONARY d0(''); CREATE TABLE t0(id INT, a BLOB COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY d0) ENGINE=InnoDB; CREATE TABLE t1(id INT, a BLOB) SELECT * FROM t0;
A bit more simplified test case to reproduce this problem
CREATE COMPRESSION_ DICTIONARY d0(''); DICTIONARY d0) ENGINE=InnoDB;
CREATE TABLE t0(id INT, a BLOB COLUMN_FORMAT COMPRESSED WITH COMPRESSION_
CREATE TABLE t1(id INT, a BLOB) SELECT * FROM t0;