Wrong CREATE_TIME for partitioned table
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
Medium
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned | |||
8.0 |
Triaged
|
Medium
|
Unassigned |
Bug Description
information_
How to repeat.
CREATE TABLE t1 (
id INT,
year_col INT
)
PARTITION BY RANGE (year_col) (
PARTITION p0 VALUES LESS THAN (1991),
PARTITION p1 VALUES LESS THAN (1995),
PARTITION p2 VALUES LESS THAN (1999)
);
select TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME, CREATE_TIME, UPDATE_TIME from information_
TABLE_SCHEMA TABLE_NAME PARTITION_NAME CREATE_TIME UPDATE_TIME
test t1 p0 2017-11-06 23:11:28 NULL
test t1 p1 2017-11-06 23:11:28 NULL
test t1 p2 2017-11-06 23:11:28 NULL
ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002));
select TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME, CREATE_TIME, UPDATE_TIME from information_
TABLE_SCHEMA TABLE_NAME PARTITION_NAME CREATE_TIME UPDATE_TIME
test t1 p0 2017-11-06 23:11:39 NULL
test t1 p1 2017-11-06 23:11:39 NULL
test t1 p2 2017-11-06 23:11:39 NULL
test t1 p3 2017-11-06 23:11:39 NULL
You see what CREATE_TIME updated for all partitions when I added only one.
This can be result of bad fix for https:/
Suggested fix: display time when each of partitions was created
summary: |
- Wrong CREATE_TIME and UPDATE_TIME for partitioned table + Wrong CREATE_TIME for partitioned table |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-1825