Stewart Smith: Undocumented ALTER TABLE that does *nothing* (useful)
(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.
URL: http://www.flamingspork.com/blog/2011/03/03/undocumented-alter-table-that-does-nothing/
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp

