On Sat, Jan 15, 2011 at 8:07 AM, Jørn Dahl-Stamnes <sq...@dahl-stamnes.net>wrote:
> 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? > Most likely (too lazy to actually check :-p ) your SQL was syntacticlaly correct, so it tried to answer the question you asked. Which, unfortunately, was not the question you wanted to ask :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
