Undocumented ALTER TABLE that does *nothing* (useful)

Posted on by

(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.

3 thoughts on “Undocumented ALTER TABLE that does *nothing* (useful)”

  2. 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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.