Re: autoincrement of primary keys support for NDB tables - Olivier Kaloudoff - com.mysql.lists.cluster

3 messages in com.mysql.lists.clusterRe: autoincrement of primary keys sup...

From	Sent On	Attachments
Olivier Kaloudoff	09 Nov 2004 14:25
Olivier Kaloudoff	09 Nov 2004 14:48
Martin Skold	10 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:48:41 PM
List:	com.mysql.lists.cluster

ok.. just read the previous post about Nagios tables that have DEFAULT '0' in it. We have exactly the same here.. So I removed all occurences of the keyword DEFAULT and associated values.

Unfortunatelly, the problem still persists:

-- MySQL dump 9.09 -- Server version 4.0.16-log

(...)

mysql> CREATE TABLE affiliates_logs ( -> id_affiliates_logs mediumint(8) unsigned NOT NULL auto_increment, -> id_affiliates mediumint(5) unsigned NOT NULL, -> host varchar(32) NOT NULL , -> ip varchar(24) NOT NULL, -> date datetime NOT NULL, -> aff_liste tinyint(3) unsigned NOT NULL , -> aff_fiche tinyint(3) unsigned NOT NULL , -> aff_form tinyint(3) unsigned NOT NULL , -> aff_confirm tinyint(3) unsigned NOT NULL , -> KEY id_affiliates_logs (id_affiliates_logs) -> ) ;

ERROR 1005 (HY000): Can't create table './ta/affiliates_logs.frm' (errno: 4335) mysql>

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,