Re: how to use HA_NO_COPY_ON_ALTER on my storage engine?

[Stewart Smith]

On Mon, 2006-11-13 at 12:47 +0100, Sergei Golubchik wrote:
> On Nov 13, xiao.feng wrote:
> > Hi,
> >  My storage engine kernel support add/drop column without copy data from one to
> one;
> >  I set HA_NO_COPY_ON_ALTER on table flag.
> >  when I add a column an table abc.
> >  it create temptable t1 with new table flags, and then rename abc to t2.
> >  then rename t1 to abc, at last it drop t2.
> >  these doesn't remain any data on table abc.
> > 
> >  how to use HA_NO_COPY_ON_ALTER on my storage engine?
> 
> You use it correctly. But HA_NO_COPY_ON_ALTER is mainly useful for MERGE
> storage engine, where dropping the table does not delete the data.
> That is, HA_NO_COPY_ON_ALTER works as it should, it's simply the wrong
> flag for you.
> 
> Unfortunately, MySQL currently does not support adding a column without
> copying the data :(

Although this will be tackled "soon" as Kristian is working on add/drop
attribute for MySQL Cluster. Somewhere between him and Mikael there is
going to be some work for being able to do this from SQL. Perhaps ask
them.
-- 
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: [phone] Ext: 6616
VoIP: 6616@stripped
Mobile: [phone]

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc

Attachment: [application/pgp-signature]