Details
-
Bug
-
Status: Stalled (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 11.6, 11.7, 11.8, 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 11.0(EOL), 11.3(EOL), 11.5(EOL)
Description
create table extralongname_extralongname_extralongname_extralongname_ext ( |
id int(10) unsigned not null, |
created_date date not null, |
created timestamp not null, |
primary key (created,id,created_date) |
) engine=innodb stats_persistent=1 default charset=latin1 |
partition by range (year(created_date)) |
subpartition by hash (month(created_date)) |
subpartitions 2 (
|
partition p2007 values less than (2008), |
partition p2008 values less than (2009) |
);
|
select length(table_name) from mysql.innodb_table_stats; |
The last statement returns 79, even though the column is defined as varchar(64).
This can potentially fail in the upper layer in many different ways. For example, it makes copying ALTER TABLE to fail with "duplicate key value".
The same applies to innodb_index_stats too.
Attachments
Issue Links
- causes
-
MDEV-13274 mysql_upgrade fails if dbname+tablename+partioname > 64 chars
- Closed
- relates to
-
MDEV-14637 Latching order violation during btr_cur_pessimistic_delete()
- Closed
-
MDEV-15020 Server hangs due to InnoDB persistent statistics or innodb_stats_auto_recalc
- Closed
- links to