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: +14082136540 Ext: 6616
VoIP: 6616@stripped
Mobile: +61 4 3 8844 332
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] This is a digitally signed message part signature.asc
