Re: Problem with indexes

Yes. [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]> wrot

Re: Problem with indexes

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, Jam

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 <<

Re: Problem with indexes

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 follow