MySQL Forums
Forum List  »  Memory Storage Engine

Advanced Search
New Topic

Re: Problem creating indices, autoincrement id's on HEAP engine.
Posted by: Michael Paik
Date: April 07, 2005 09:58AM

As it turns out, I can make this work if I run the ALTER TABLE before I load any data, but not if I do the ALTER TABLE after the rows are already loaded. Likely has something to do with the way the HEAP engine handles ALTER TABLE.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Problem creating indices, autoincrement id's on HEAP engine.
8606
Michael Paik
April 07, 2005 08:43AM
Re: Problem creating indices, autoincrement id's on HEAP engine.
4559
Michael Paik
April 07, 2005 08:50AM
Re: Problem creating indices, autoincrement id's on HEAP engine.
4677
Samuel Benzaquen
April 07, 2005 09:11AM
Re: Problem creating indices, autoincrement id's on HEAP engine.
4561
Michael Paik
April 07, 2005 09:23AM
Re: Problem creating indices, autoincrement id's on HEAP engine.
4289
Michael Paik
April 07, 2005 09:58AM
Re: Problem creating indices, autoincrement id's on HEAP engine.
4801
Ingo Strüwing
May 09, 2005 03:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.