Re: Incorrect key file for table

[Jørn Dahl-Stamnes]

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/