Hello.
You may use some recommendations from: http://dev.mysql.com/doc/mysql/en/Full_table.html "Jocelyn Fournier" <[EMAIL PROTECTED]> wrote: > Hi, > > I've just encountered a strange problem when trying to update a table : > > UPDATE searchmainhardwarefr0, searchjoinhardwarefr0 SET > searchmainhardwarefr0.numeropost=searchjoinhardwarefr0.topic WHERE > searchmainhardwarefr0.numreponse=searchjoinhardwarefr0.numreponse; > ERROR 1114 (HY000): The table '#sql_11be_0' is full > > searchjoinhardwarefr0 contains only 70624 rows, and searchmainhardwarefr0 > contains 946113 rows. > > However I succeed in updating the table with the following query : > > UPDATE searchmainhardwarefr0, threadhardwarefr0 SET > searchmainhardwarefr0.numeropost=threadhardwarefr0.numeropost WHERE > searchmainhardwarefr0.numreponse=threadhardwarefr0.numreponse; > > threadhardwarefr0 contains 76291 ans is also larger on the disk. > > This sounds like a bug for me, but I want to be sure I didn't miss anything. > > I'm using MySQL-4.1.8 > > Thanks, > Jocelyn > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
