Paul Cadach wrote:
>
> Hi,
>
> When I'm trying to realize my idea to have compressed
> tables without shutting down the server, I got a message
> that table is read-only. An idea is looks like:
> 1) Create (temporary) table aaa_tmp from aaa (or get it from
> scratch, not
> depends)
> 2) Compress (temporary) table aaa_tmp with
> *isampack/*isamchk
> 3) Drop original table aaa
> 4) Do: ALTER TABLE aaa_tmp RENAME AS aaa
>
> At step 4) I got "table aaa_tmp is read-only". Does
> compressed
> tables required to be "non-updateable" rather than
> "read-only"?
This is a bug - there is no reason to not allow a rename of a compressed table.
We will take a look at how easy it is to fix it and see if we can sneak it into
3.23 version (we are currently about to start developing only in 4.0 to keep
3.23 stable)
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
