Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: Need new accessors to THD internals

From: Marko Mäkelä <marko.makela(at)oracle.com>
Date: Fri Aug 31 2007 - 03:11:22 EDT


On Fri, Aug 31, 2007 at 02:00:14PM +1000, Stewart Smith wrote:
> On Thu, 2007-08-30 at 16:33 +0300, Marko Mäkelä wrote:
> > I guess InnoDB doesn't support DROP TABLE ... CASCADE then. On a
> > related note, while testing smart ALTER TABLE, I found out that
> > ALTER TABLE ... DROP FOREIGN KEY is not too smart: it will rebuild
> > the table and all indexes in the old-fashioned way. This is a MySQL
> > limitation.
>
> I guess the new generic ALTER TABLE code that (i think) has now been
> merged into 5.2 (at least it's in the NDB telco tree) should work for
> this?

I can see the constant ALTER_FOREIGN_KEY in the 5.2 sql_table.cc, but it doesn't seem to be a constant for handlerton::alter_table_flags in handler.h. Is there some documentation on the generic ALTER TABLE?

        Marko

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com
Received on Fri Aug 31 03:21:22 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 07:59:17 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library