Re: Help with SQL DELETE issue

2006-01-16 Thread Pete Harlan
Agreed. OTOH, I would recommend 4.1.15 until they solve the problem with updates in 4.1.16 apparently not using index prefixes. --Pete On Sun, Jan 15, 2006 at 05:07:08PM +, Jocelyn Fournier wrote: > Hi, > > Excepted if he found a bug in an older version of MySQL, it's of course > false !

Re: Help with SQL DELETE issue

2006-01-15 Thread Jocelyn Fournier
Hi, Excepted if he found a bug in an older version of MySQL, it's of course false ! (it would be a major issue which would make MySQL just unusable) Regards, Jocelyn David Rabinowitz a écrit : Hi, We are using MySQL 4.1.16, recently upgraded from 4.0.18. On the old server we tried not t

Help with SQL DELETE issue

2006-01-15 Thread David Rabinowitz
Hi, We are using MySQL 4.1.16, recently upgraded from 4.0.18. On the old server we tried not to delete records, as their is a common belief that deleting records will corrupt the table's index and we will have to call repair table. I couldn't find any documentation on that. Unfortunately he