Re: Possible bug in UPDATE that covers multiple InnoDB tables - Heikki Tuuri - com.mysql.lists.bugs

5 messages in com.mysql.lists.bugsRe: Possible bug in UPDATE that cover...

From	Sent On	Attachments
Jacob Friis Larsen	04 Feb 2003 08:23
Heikki Tuuri	04 Feb 2003 13:05
Heikki Tuuri	04 Feb 2003 13:14
Heikki Tuuri	04 Feb 2003 13:42
Sinisa Milivojevic	08 Feb 2003 09:13

Subject:	Re: Possible bug in UPDATE that covers multiple InnoDB tables
From:	Heikki Tuuri (Heik...@innodb.com)
Date:	02/04/2003 01:14:45 PM
List:	com.mysql.lists.bugs

Jacob,

----- Original Message ----- From: "Heikki Tuuri" <Heik...@innodb.com> To: <bu...@lists.mysql.com> Sent: Tuesday, February 04, 2003 11:05 PM Subject: Re: Possible bug in UPDATE that covers multiple InnoDB tables

Jacob,

what do

SHOW CREATE TABLE questions;

and

SHOW CREATE TABLE q_list;

print?

The assertion which fails is:

ut_a(cursor->old_stored == BTR_PCUR_OLD_STORED);

What does

shell> resolve_stack_trace mysqld.sym

sorry, it is spelled resolve_stack_dump. It is in the 'bin dir' of your MySQL distro.

print?

Regards,

Heikki

Best regards,

Heikki Tuuri Innobase Oy

--- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

sql query

.................... Subject: Possible bug in UPDATE that covers multiple InnoDB tables From: Jacob Friis Larsen Date: Tue, 4 Feb 2003 17:24:08 +0100

--------------------------------------------------------------------------

----

Regarding the bug I submitted earlier, I have som more info here: http://test.webalogic.net/~jacob/mysql_bug/

How-To-Repeat: The bug happens when I use a query like "UPDATE questions, q_list SET questions.point = 150, q_list.point = questions.point WHERE q_list.qid = questions.qid AND questions.qid = 310756" on an InnoDB table as you can see in the file "mysql_bug-error_log". It does not happen on MyISAM tables.

Please let me know how I can assist you further.