Concurrent ALTER and ANALYZE collecting statistics can result in stale statistical data

--source include/have_sequence.inc

CREATE TABLE t (a INT, b VARCHAR(128));

INSERT INTO t SELECT seq, CONCAT('s',seq) FROM seq_1_to_100;

--connect (con1,localhost,root,,)

--send ALTER TABLE t MODIFY b BLOB

--connection default

ANALYZE TABLE t PERSISTENT FOR ALL;

--connection con1

--reap

ANALYZE TABLE t PERSISTENT FOR ALL;

--connection default

--disconnect con1

select db_name,table_name,column_name from mysql.column_stats;

drop table t;

select db_name,table_name,column_name from mysql.column_stats;

db_name	table_name	column_name

test	t	a

test	t	b