mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
4c8d2410b6
The warning is given in case of table not found or if there is a lock timeout. The warning is needed as in case of a lock timeout then the persistent table stats are going to be wrong.
14 lines
595 B
Text
14 lines
595 B
Text
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);
|
|
Warnings:
|
|
Warning 1177 Got error 1146 when trying to open statistics table `table_stats` for updating statistics
|
|
Warning 1177 Got error 1146 when trying to open statistics table `table_stats` for updating statistics
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`b` varchar(100) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
alter table mysql.column_stats1 rename to mysql.column_stats;
|
|
drop table t1;
|