From: Thimble Smith
Date: November 7 2000 2:43pm
Subject: Re: Unknown error
List-Archive: http://lists.mysql.com/bugs/518
Message-Id: <20001107094356.B639@threads.polyesthetic.msg>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Tue, Nov 07, 2000 at 09:23:46AM +0100, Frank Heckenbach wrote:
> The following code produces an "Unknown error" message. I'm using
> MySQL 3.23.25 (I apologize if this has been fixed in a later
> release).
> 
> USE test;
> DROP TABLE IF EXISTS test;
> CREATE TABLE test (x INT);
> INSERT INTO test VALUES (1), (2), (3);
> 
> # This works
> SELECT *, NULL FROM test;
> 
> # ERROR 1105 at line 10: Unknown error
> CREATE TEMPORARY TABLE tmp SELECT *, NULL FROM test;

Thanks for the bug report, Frank.  A related (I guess) bug that
is more serious:

mysql> create temporary table foo select 1 as 'x';
Query OK, 1 row affected (0.20 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> Nov  7 09:42:04 threads /kernel: pid 865 (mysqld), uid 1000: exited on signal 10 (core dumped)


We'll fix these bugs for the next release.

Tim

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Tim Smith <tim@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Development Team
/_/  /_/\_, /___/\___\_\___/   Boone, NC  USA
       <___/   www.mysql.com