Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.8(EOL)
-
None
Description
When a partition with partition-level options is added by ALTER, it shows the correct definition in SHOW CREATE, but the actual values get inherited from the previous partition.
At least that's my guess of what's happening with the flag, see details below.
MTR test case is at the end of the description.
The test will be using PAGE_COMPRESSED as an example. I have no information whether the problem affects other options.
Since I don't have the flag decoder handy, let's create a dictionary first.
drop database if exists db; |
create database db; |
use db; |
create table t_not_compressed (a int) engine=InnoDB page_compressed=0; |
# Default level is 6 |
create table t_compressed (a int) engine=InnoDB page_compressed=1; |
create table t_compressed_level_3 (a int) engine=InnoDB page_compressed=1 page_compression_level=3; |
 |
select name, flag from information_schema.innodb_sys_tablespaces where name like 'db%'; |
+-------------------------+------------+ |
| name | flag | |
+-------------------------+------------+ |
| db/t_not_compressed | 21 |
|
| db/t_compressed | 1610612789 |
|
| db/t_compressed_level_3 | 805306421 |
|
+-------------------------+------------+ |
3 rows in set (0.001 sec) |
So, these are the expected flag values.
Let's check that they are the same for partitions, just in case.
create table t_parts (a int) engine=InnoDB partition by hash(a) ( |
partition p_not_compressed page_compressed=0,
|
partition p_compressed page_compressed=1,
|
partition p_compressed_level_3 page_compressed=1 page_compression_level=3
|
);
|
select name, flag from information_schema.innodb_sys_tablespaces where name like 'db/t_parts%'; |
+-----------------------------------+------------+ |
| name | flag | |
+-----------------------------------+------------+ |
| db/t_parts#P#p_not_compressed | 21 |
|
| db/t_parts#P#p_compressed | 1610612789 |
|
| db/t_parts#P#p_compressed_level_3 | 805306421 |
|
+-----------------------------------+------------+ |
So far so good.
Now let's create the same structure but in steps.
create table t_alter (a int) engine=InnoDB partition by hash(a) (partition p_not_compressed page_compressed=0); |
select name, flag from information_schema.innodb_sys_tablespaces where name like 'db/t_alter%'; |
 |
alter table t_alter add partition (partition p_compressed page_compressed=1); |
select name, flag from information_schema.innodb_sys_tablespaces where name like 'db/t_alter%'; |
 |
alter table t_alter add partition (partition p_compressed_level_3 page_compressed=1 page_compression_level=3); |
select name, flag from information_schema.innodb_sys_tablespaces where name like 'db/t_alter%'; |
|
10.8 050508672 |
MariaDB [db]> select name, flag from information_schema.innodb_sys_tablespaces where name like 'db/t_alter%'; |
+-------------------------------+------+ |
| name | flag | |
+-------------------------------+------+ |
| db/t_alter#P#p_not_compressed | 21 |
|
+-------------------------------+------+ |
1 row in set (0.001 sec) |
MariaDB [db]> alter table t_alter add partition (partition p_compressed page_compressed=1); |
Query OK, 0 rows affected (0.111 sec) |
Records: 0 Duplicates: 0 Warnings: 0
|
 |
MariaDB [db]> select name, flag from information_schema.innodb_sys_tablespaces where name like 'db/t_alter%'; |
+-------------------------------+------+ |
| name | flag | |
+-------------------------------+------+ |
| db/t_alter#P#p_not_compressed | 21 |
|
| db/t_alter#P#p_compressed | 21 |
|
+-------------------------------+------+ |
2 rows in set (0.001 sec) |
MariaDB [db]> alter table t_alter add partition (partition p_compressed_level_3 page_compressed=1 page_compression_level=3); |
Query OK, 0 rows affected (0.269 sec) |
Records: 0 Duplicates: 0 Warnings: 0
|
 |
MariaDB [db]> select name, flag from information_schema.innodb_sys_tablespaces where name like 'db/t_alter%'; |
+-----------------------------------+------------+ |
| name | flag | |
+-----------------------------------+------------+ |
| db/t_alter#P#p_not_compressed | 21 |
|
| db/t_alter#P#p_compressed | 1610612789 |
|
| db/t_alter#P#p_compressed_level_3 | 1610612789 |
|
+-----------------------------------+------------+ |
3 rows in set (0.001 sec) |
Not so good.
The initial partition was created all right.
The "compressed" partition is actually added with the non-compressed flag – that is, the flag from the previous partition.
When the "compressed-level-3" partition is added, the previous "compressed" partition is recalculated/rebuilt to use its correct flag, but the new one is added with a wrong one – again, with the one from the previous partition.
SHOW CREATE TABLE shows the intended values though.
MariaDB [db]> show create table t_alter \G |
*************************** 1. row ***************************
|
Table: t_alter |
Create Table: CREATE TABLE `t_alter` ( |
`a` int(11) DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
PARTITION BY HASH (`a`) |
(PARTITION `p_not_compressed` ENGINE = InnoDB page_compressed = 0,
|
PARTITION `p_compressed` ENGINE = InnoDB page_compressed = 1,
|
PARTITION `p_compressed_level_3` ENGINE = InnoDB page_compressed = 1 page_compression_level = 3)
|
1 row in set (0.000 sec) |
|
MTR |
--source include/have_innodb.inc
|
--source include/have_partition.inc
|
 |
--let $restart_parameters= --innodb-sys-tablespaces
|
--source include/restart_mysqld.inc
|
 |
create table t (a int) engine=InnoDB partition by hash(a) (partition p_not_compressed page_compressed=0); |
alter table t add partition (partition p_compressed page_compressed=1); |
select name, flag from information_schema.innodb_sys_tablespaces where name like 'test/t%'; |
 |
# Cleanup
|
drop table t; |
Attachments
Issue Links
- is caused by
-
MDEV-5271 Support engine-defined attributes per partition
-
- Closed
-