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
