List:Internals« Previous MessageNext Message »
From:sasha Date:November 23 2000 7:37pm
Subject:Re: Assuming compressed tables as read-only is wrong?
View as plain text  
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
       <___/
Thread
Assuming compressed tables as read-only is wrong?Paul Cadach23 Nov
  • Re: Assuming compressed tables as read-only is wrong?sasha23 Nov