From: Jørn Dahl-Stamnes
Date: January 15 2011 7:07am
Subject: Re: Incorrect key file for table
List-Archive: http://lists.mysql.com/mysql/224072
Message-Id: <201101150807.44681.sql06@dahl-stamnes.net>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 th=
e=20
server processed the query. Would it not be more appropriate with an error=
=20
message saying that this query contain an error?

=2D-=20
J=F8rn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/