List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 8 2000 1:19pm
Subject:Patch: Re: Unknown error
View as plain text  
Hi!

Here is a patch that fixes both of these (unrelated) problems.



Regards,
Monty

>>>>> "Thimble" == Thimble Smith <tim@stripped> writes:

Thimble> 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;

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

mysql> create temporary table foo select 1 as 'x';
Thimble> Query OK, 1 row affected (0.20 sec)
Thimble> 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)

Thimble> We'll fix these bugs for the next release.


Thread
Scheduled queriesJuan Riera18 Mar
  • Patch: Re: Unknown errorMichael Widenius8 Nov
Re: Scheduled queriesEd Carp18 Mar
RE: if existsemierzwa5 May
  • Re: if existsMichael Stassen5 May