[EMAIL PROTECTED] wrote:
I am assuming that the Memo field is a text datatype and you were encountering the duplicate key bug.
Original Message <<<<<<<<<<<<<<<<<<
On 2/25/04, 3:28:58 PM, James Lamanna <[EMAIL PROTECTED]> wrote regarding Re: Problem with indexes:
Found out that the problem was actually a bug in 4.0.17. Upgrading to 4.0.18 seems to have fixed the problem.
Noted here: http://bugs.mysql.com/bug.php?id=2446
[EMAIL PROTECTED] wrote:
Can you do a show create table Table1 and see how the index is defined?
Original Message <<<<<<<<<<<<<<<<<<
On 2/25/04, 12:02:43 PM, James Lamanna <[EMAIL PROTECTED]> wrote regarding Problem with indexes:
So I'm having issues with indexes in mysql 4.0
I issue the following: Create Index Index1 on Table1 (ParentID,ClassID,Amount,Memo(20));
That works fine. However I'm running into problems when I'm trying to
insert into this table using INSERT I'm receiving errors about
duplicate
keys against this Index.
I thought this Index should be non-unique since I didn't specify the UNIQUE keyword.
This table does not have a Primary Key either. Kinda need help ASAP, so any ideas would be appreciated.
-- James Lamanna Applied Minds, Inc. 1209 Grand Central Ave. Glendale, CA 91201 (818) 332-5214
-- James Lamanna Applied Minds, Inc. 1209 Grand Central Ave. Glendale, CA 91201 (818) 332-5214
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]