Locating Duplicate records always results in Error 127

2003-03-17 Thread mySQL list
I am locating 'duplicate entries in a table and updating a status field accordingly. The idea is to locate rows which have a matching 'Name' field, and mark them for subsequent processing. However, my update query *ALWAYS* returns Error 127, even on a newly created table if the matching name field

Re: Locating Duplicate records always results in Error 127

2003-03-17 Thread Sergei Golubchik
Hi! On Mar 17, mySQL list wrote: Below is a minimum script which always results in the error Got error 127 from table handler, with only two records in the table. Change the name fields from (8 chars) to AAA (7 chars) and no error. I tried it on both 4.0.11 and 4.0.12. It,