List:Bugs« Previous MessageNext Message »
From:Thimble Smith Date:November 7 2000 2:43pm
Subject:Re: Unknown error
View as plain text  
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
Thread
Re: Unknown errorThimble Smith7 Nov
  • Patch: Re: Unknown errorMichael Widenius8 Nov
Re: Patch: Re: Unknown errorsasha8 Nov
  • Re: Patch: Re: Unknown errorMichael Widenius9 Nov