Re: alter table rebuild partition locks reads

[Chris C]

More info:

Appears any alter table on a partition table will lock it:

alter table <table_name> engine = innodb;

Same thing.

The documentation clearly states that sessions can read a table while it is rebuilding the temporary table. So, something is up.

Note, if I take a non-partitioned table and do:

alter table <table_name> engine = innodb;

I can query all I want.