Bug with INSERT and SUBSELECT in mysql-4.1

Hi,

How-to-repeat :

CREATE TABLE `forumconthardwarefr7` (
`numeropost` mediumint(8) unsigned NOT NULL auto_increment,
`maxnumrep` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`numeropost`),
UNIQUE KEY `maxnumrep` (`maxnumrep`)) TYPE=MyISAM ROW_FORMAT=FIXED

mysql> INSERT INTO forumconthardwarefr7 (numeropost) VALUES
(dontcare=(SELECT 1 FROM dontmind));
ERROR 2013: Lost connection to MySQL server during query

Stack trace :

0x80a1971 handle_segfault(int) + 481
0x8286968 pthread_sighandler + 176
0x80c3c56 setup_tables(st_table_list*) + 38
0x80d977c mysql_insert(THD*, st_table_list*, List&, List
>&, enum_duplicates, thr_lock_type) + 364
0x80acbe9 mysql_execute_command(THD*) + 4681
0x80b0585 mysql_parse(THD*, char*, unsigned) + 149
0x80aab27 dispatch_command(enum_server_command, THD*, char*, unsigned) + 855
0x80aa7b6 do_command(THD*) + 118
0x80aa08f handle_one_connection(void*) + 895
0x82841fa pthread_start_thread + 218
0x82b86aa thread_start + 4

Regards,
Jocelyn


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12941@lists.mysql.com
To unsubscribe, e-mail

Re: Bug with INSERT and SUBSELECT in mysql-4.1

Hi!

On Mon, Nov 11, 2002 at 08:58:52AM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> CREATE TABLE `forumconthardwarefr7` (
> `numeropost` mediumint(8) unsigned NOT NULL auto_increment,
> `maxnumrep` int(10) unsigned NOT NULL default '0',
> PRIMARY KEY (`numeropost`),
> UNIQUE KEY `maxnumrep` (`maxnumrep`)) TYPE=MyISAM ROW_FORMAT=FIXED
>
> mysql> INSERT INTO forumconthardwarefr7 (numeropost) VALUES
> (dontcare=(SELECT 1 FROM dontmind));
> ERROR 2013: Lost connection to MySQL server during query

Thank you for bug report. It is known bug. I already fix it for update (not
pushed yet) for delete/replace/insert it will be done soon.

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12942@lists.mysql.com
To unsubscribe, e-mail