List:Cluster« Previous MessageNext Message »
From:Pascal Gauthier Date:August 4 2004 7:59pm
Subject:Question about creation of table
View as plain text  
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

Thread
Question about creation of tablePascal Gauthier4 Aug
RE: Question about creation of tableLuke H. Crouch4 Aug
  • RE: Question about creation of tablePascal Gauthier4 Aug
RE: Question about creation of tableLuke H. Crouch4 Aug
  • RE: Question about creation of tablePascal Gauthier4 Aug
RE: Question about creation of tableLuke H. Crouch4 Aug
  • RE: Question about creation of tablePascal Gauthier4 Aug