mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
973b281e59
if columns or indexes are modified/renamed/dropped in an ALTER TABLE, stat tables must be updated accordingly (e.g. all statistics for a column should be dropped). But if a stat table doesn't exist, it's not a reason to fail the whole ALTER TABLE operation - such an error should be ignored.
10 lines
385 B
Text
10 lines
385 B
Text
#
|
|
# MDEV-18788 Live upgrade from MySQL 5.6/5.7 to MariaDB 10.4 fails with "Event Scheduler: An error occurred when initializing system tables"
|
|
#
|
|
create table t1 (a int);
|
|
alter table mysql.column_stats rename to mysql.column_stats1;
|
|
flush tables;
|
|
alter table t1 change a b varchar(100);
|
|
show create table t1;
|
|
alter table mysql.column_stats1 rename to mysql.column_stats;
|
|
drop table t1;
|