diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-11-26 16:39:36 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-11-26 16:41:09 +0200 |
| commit | 971e1d8677be58cd51e558ef80042c76a5c21e1a (patch) | |
| tree | 17ec5fd316269be69bf98eca71f95f34e40cc5c0 /mysql-test/suite/innodb/r/truncate.result | |
| parent | 9669536c2355efb6f71babc9d2e615e9125c816b (diff) | |
| download | mariadb-git-971e1d8677be58cd51e558ef80042c76a5c21e1a.tar.gz | |
MDEV-17831 TRUNCATE TABLE removes ROW_FORMAT=COMPRESSED
If a table had a KEY_BLOCK_SIZE attribute, but no ROW_FORMAT,
it would be created as ROW_FORMAT=COMPRESSED in InnoDB.
However, TRUNCATE TABLE would lose the KEY_BLOCK_SIZE attribute
and create the table with the innodb_default_row_format (DYNAMIC).
This is a regression that was introduced by MDEV-13564.
update_create_info_from_table(): Copy also KEY_BLOCK_SIZE.
Diffstat (limited to 'mysql-test/suite/innodb/r/truncate.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/truncate.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/truncate.result b/mysql-test/suite/innodb/r/truncate.result index c8a81256d79..e25cd6a0bea 100644 --- a/mysql-test/suite/innodb/r/truncate.result +++ b/mysql-test/suite/innodb/r/truncate.result @@ -18,3 +18,12 @@ SELECT * FROM t1; c character DROP TABLE t1; +# +# MDEV-17831 TRUNCATE TABLE removes ROW_FORMAT=COMPRESSED +# +CREATE TABLE t1 (a SERIAL) ENGINE=InnoDB KEY_BLOCK_SIZE=4; +TRUNCATE TABLE t1; +SHOW TABLE STATUS; +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment +t1 InnoDB # Compressed # # # # # # 1 # # NULL latin1_swedish_ci NULL key_block_size=4 +DROP TABLE t1; |