Edit File: ndb_autoinc.result
DROP TABLE IF EXISTS t1,t2,t3; USE test; CREATE TABLE t1 ( id INT AUTO_INCREMENT, PRIMARY KEY(id) ) ENGINE=NDBCLUSTER; CREATE TABLE t2 ( id INT AUTO_INCREMENT, KEY(id) ) ENGINE=NDBCLUSTER; ERROR HY000: Can't create table 'test.t2' (errno: 4335) SHOW TABLES; Tables_in_test t1 CREATE TABLE t3 ( id INT AUTO_INCREMENT, KEY(id) ) ENGINE=MYISAM; ALTER TABLE t3 ENGINE NDBCLUSTER; SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `id` int(11) NOT NULL AUTO_INCREMENT, KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE t3 ADD PRIMARY KEY (id); SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DROP TABLE t1, t3; End of 5.1 tests