On Sat, Jan 15, 2011 at 8:07 AM, 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
> 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