Bug #2215 some subselect queries crashes mysqld in case of innodb tables
Submitted: 25 Dec 2003 19:43 Modified: 26 Dec 2003 7:22
Reporter: Igor Blagodetelev Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.0.0 OS:Linux (Slackware)
Assigned to: Assigned Account CPU Architecture:Any

[25 Dec 2003 19:43] Igor Blagodetelev
In the MySQL 5.0.0 exists bug described here: http://bugs.mysql.com/bug.php?id=2048

How to repeat:
When I run query:
select (select max(id) from bench6 where b=1 group by b) as x,b from bench5
where b=1 server died, but if I use begin/commit query works right.

Suggested fix:
Need fix unlocking tables during subquery execution
[26 Dec 2003 7:22] Dean Ellis
As you note, this is a duplicate of bug 2048.

Once it has been corrected, the fix will eventually be merged into 5.0 also.

Thank you.