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.
