Re: Mysql 5.0 ARCHIVE and auto_increment question.
Posted by:
Brian Aker
Date: December 23, 2005 02:09PM
The problem is that archive doesn't support indexes, so it can not support auto increments since they require indexes.
I have two thoughts on this.
1) Fake indexes, and error if someone tries to insert against an archive table anything other then an autoincrement.
2) Fix it so that autoincrements don't have to be on unique indexes.
I've not made up my mind about this. The actual code for this is pretty trivial, its just not been an issue. Archive has an internal row_id, but currently you can't get at it. Row_id today is hard coded to PRIMARY KEY and you can not use it for hidden keys (NDB, BDB, and Archive all have them depending on the situation).
What are you doing with archive?
-Brian
Subject
Views
Written By
Posted
11792
December 23, 2005 01:33PM
Re: Mysql 5.0 ARCHIVE and auto_increment question.
4694
December 23, 2005 02:09PM
4489
December 23, 2005 04:09PM
4248
December 23, 2005 04:11PM
4236
December 25, 2005 12:25PM
4115
January 10, 2006 03:30PM
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.