Re: Crash in UPDATE with subqueries with MySQL-4.1 - jocelyn fournier - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsRe: Crash in UPDATE with subqueries w...

From	Sent On	Attachments
Jocelyn Fournier	28 Nov 2002 16:34
Sanja Byelkin	01 Dec 2002 01:46
jocelyn fournier	01 Dec 2002 09:13

Subject:	Re: Crash in UPDATE with subqueries with MySQL-4.1
From:	jocelyn fournier (jo...@presence-pc.com)
Date:	12/01/2002 09:13:48 AM
List:	com.mysql.lists.bugs

Hi,

That's odd, this query is still crashing for me. (with latest changeset 1.1409)

mysql> CREATE TABLE `t10` ( -> `id` int(11) default NULL, -> KEY `id` (`id`) -> ) TYPE=MyISAM CHARSET=latin1; Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO t10 VALUES (1); Query OK, 1 row affected (0.01 sec)

mysql> UPDATE t10 SET id=(SELECT id FROM (SELECT 1) a HAVING id=2); ERROR 2013: Lost connection to MySQL server during query

Stack trace :

0x80a2d11 handle_segfault + 481 0x828de98 pthread_sighandler + 176 0x82703fd hashcmp + 93 0x82702f0 hash_search + 112 0x812e8ac Query_cache::invalidate(THD*, st_table_list*, char) + 172 0x80e2662 mysql_update(THD*, st_table_list*, List<Item>&, List<Item>&, Item*, st_order*, unsigned long, enum_duplicates) + 3234 0x80aff51 mysql_execute_command(THD*) + 3473 0x80b41d8 mysql_parse(THD*, char*, unsigned) + 248 0x80ae314 dispatch_command(enum_server_command, THD*, char*, unsigned) + 852 0x80adfa6 do_command(THD*) + 118 0x80ad88e handle_one_connection + 910 0x828b8ba pthread_start_thread + 218 0x82bfbda thread_start + 4

Seems to be linked with the query cache according to the stack trace ?

Regards, Jocelyn

----- Original Message ----- From: "Sanja Byelkin" <san...@mysql.com> To: "Jocelyn Fournier" <jo...@presence-pc.com> Cc: <bu...@lists.mysql.com> Sent: Sunday, December 01, 2002 10:46 AM Subject: Re: Crash in UPDATE with subqueries with MySQL-4.1

Hi!

On Fri, Nov 29, 2002 at 12:34:29AM -0000, Jocelyn Fournier wrote:

Hi,

How-to-repeat :

CREATE TABLE `t` ( `id` int(11) default NULL, KEY `id` (`id`) ) TYPE=MyISAM CHARSET=latin1

INSERT INTO t VALUES (1);

mysql> UPDATE t SET id=(SELECT id FROM (SELECT 1) HAVING id=2); ERROR 2013: Lost connection to MySQL server during query

This bug is gone: + drop table if exists t; + CREATE TABLE ( + d int(11) default NULL, + KEY d ( d) + ) TYPE=MyISAM CHARSET=latin1; + INSERT INTO t VALUES (1); + select * from t; + id + 1 + UPDATE t SET id=(SELECT id FROM (SELECT 1) s HAVING id=2); + select * from t; + id + NULL + drop table t;

[skip]