3 messages in com.mysql.lists.clusterRe: autoincrement of primary keys sup...
FromSent OnAttachments
Olivier Kaloudoff09 Nov 2004 14:25 
Olivier Kaloudoff09 Nov 2004 14:48 
Martin Skold10 Nov 2004 04:02 
Subject:Re: autoincrement of primary keys support for NDB tables
From:Olivier Kaloudoff (kal@kalou.net)
Date:11/09/2004 02:25:31 PM
List:com.mysql.lists.cluster

Hi,

I'm sorry to raise this point after sending feedback to Tomas, but the following problem with autoincrement primary keys just arrised in the qualification phase to switch to MySQL cluster;

root@mapi0:/# mysql "beta" < simplified.sql ERROR 1005 (HY000) at line 105: Can't create table './beta/affiliates_logs.frm'
(errno: 4335)

as you can see, we're using auto_increment in each of our tables here:

CREATE TABLE affiliates ( id_affiliates smallint(5) unsigned NOT NULL auto_increment, (...)

root@mapi0:/# grep auto_increment simplified.sql | wc -l 40

As the following message states, as of September, there were no plans to implement this feature shortly with NDB tables;

http://lists.mysql.com/cluster/596

Are there any chances to change this ?

Best Regards,