[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-internals
Subject:    Re: Assuming compressed tables as read-only is wrong?
From:       sasha () mysql ! com
Date:       2000-11-23 19:37:28
[Download RAW message or body]

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@mysql.com>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
       <___/

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail internals-thread150@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail internals-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]