On Saturday 15 January 2011 00:28, Johnny Withers wrote: > The result of your query without the join > probably exceeded your tmp_table_size variable. When this > occurs, MySQL quit writing the temp table to disk thus producing an > incorrect table file. (I think).
Yes, part of this was my fault (the missing join) but I still wonder why the server processed the query. Would it not be more appropriate with an error message saying that this query contain an error? -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org