MySQL Forums
Forum List  »  Quality Assurance

CREATE TEMPORARY TABLE LIKE [ ...a partitioned table... ]
Posted by: Gérard LEMENN
Date: February 13, 2008 04:28AM

Hye,

T is a "partitioned (by key, say)" MyISAM-table.
I do : CREATE TEMPORARY TABLE TMPTABLE LIKE T;

ok : although a temporary table cannot be partitioned, TMPTABLE is actually created.
Now I can populate it : f.ex. : INSERT INTO TMPTABLE SELECT * FROM T;

And now it becomes interesting, when I do :
ALTER TABLE TMPTABLE DISABLE KEYS;
-------> "Cannot create temporary table with partitions"

Why doesn't mysql just REMOVE PARTITIONING from TMPTABLE at creation time, if it can't manage partitions of temporary tables (which is rather understandable since they are not written on files).

Options: ReplyQuote


Subject
Views
Written By
Posted
CREATE TEMPORARY TABLE LIKE [ ...a partitioned table... ]
5999
February 13, 2008 04:28AM


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.