(at least since MySQL 5.1.42)
alter table t1 force;
Pretty neat huh? In fact, in Drizzle this will end up doing a copying alter table. Not useful.
There’s an over four year old bug report in MySQL (Bug#24091).
I’m just going to remove that bit from the parser in Drizzle – it makes no sense.
the force syntax will be used soon. see this:
http://lists.mysql.com/commits/132296
huh, interesting use of it.
At least for Drizzle, until we have something like that (and I’m not sure this shouldn’t just be a default REPAIR TABLE operation, or at ALTER TABLE with an ORDER BY) I’ll remove it.
http://bugs.mysql.com/bug.php?id=24091