The syntax we are using for table creation is:
create table bench1 (a int NOT NULL,i int,s char(10),primary key (a)) ENGINE=NDB
so maybe try to replace 'TYPE' with 'ENGINE' ?
-L
> -----Original Message-----
> From: Pascal Gauthier [mailto:pgauthier@stripped]
> Sent: Wednesday, August 04, 2004 3:00 PM
> To: cluster@stripped
> Subject: Question about creation of table
>
>
> Hi all,
>
> When I try the sql-bench test script, I have many errors, one of them
> is:
>
> --------------------------------------------------------------
> ----------
> Can't execute command 'create table bench1 (a int NOT NULL,i int,s
> char(10),primary key (a)) TYPE=NDB'
> Error: Can't create table './test/bench1.frm' (errno: 701)
> --------------------------------------------------------------
> ----------
>
> When I try to create it manually I have:
>
> --------------------------------------------------------------
> ----------
> mysql> create table bench1 (a int NOT NULL,i int,s
> char(10),primary key
> (a)) TYPE=NDB;
> ERROR 1005 (HY000): Can't create table './test/bench1.frm'
> (errno: 701)
> --------------------------------------------------------------
> ----------
>
> If I create the same table but without the NDB type, it work. Someone
> known why? is it a bug?
>
> I have MySQL 4.1.4-beta (from bitkeeper)
>
> Thanks
>
> --
> Pascal Gauthier
> Cel: 514-668-9966
> http://www.nihilisme.ca
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=1
>
>
