Re: ERROR 1005 (HY000): Can't create table '.\testDataBase\#sql-ec4_c.frm' (errno: 139)

2005-10-25 Thread Heikki Tuuri 

Sunil,

in InnoDB, the maximum indexed column length is 767 bytes.

Osku is improving the error message:
http://bugs.mysql.com/bug.php?id=13315

Regards,

Heikki
Oracle/Innobase

- Original Message - 
From: Sunil Vishwas [EMAIL PROTECTED]

Newsgroups: mailing.database.myodbc
Sent: Tuesday, October 25, 2005 5:33 AM
Subject: ERROR 1005 (HY000): Can't create table 
'.\testDataBase\#sql-ec4_c.frm' (errno: 139)




--_=_NextPart_001_01C5D90C.62DB5CF5
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

(I am using mysql-5.0.15-win32)
Why I am getting this error and is there any way I can fix it, or is it
a bug?
Between I don't get this error if I change the field size to 767 or
below:
=20
drop table Address;

CREATE TABLE `Address`=20
(
`RecId` CHAR(32) NOT NULL,=20
`WebAddress` VARCHAR(1000),=20
CONSTRAINT PKAddress PRIMARY KEY(RecId)
);
=20
CREATE INDEX AddressWebAddressWebAddress ON Address (WebAddress);
=20

--_=_NextPart_001_01C5D90C.62DB5CF5-- 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERROR 1005 (HY000): Can't create table '.\testDataBase\#sql-ec4_c.frm' (errno: 139)

2005-10-24 Thread Sunil Vishwas 
(I am using mysql-5.0.15-win32)
Why I am getting this error and is there any way I can fix it, or is it
a bug?
Between I don't get this error if I change the field size to 767 or
below:
 
drop table Address;

CREATE TABLE `Address` 
(
 `RecId` CHAR(32) NOT NULL, 
 `WebAddress` VARCHAR(1000), 
 CONSTRAINT PKAddress PRIMARY KEY(RecId)
);
 
CREATE INDEX AddressWebAddressWebAddress ON Address (WebAddress);