Bug 654000 - Mysql bug 54488 - crash when using explain and prepared statements with subqueries
Summary: Mysql bug 54488 - crash when using explain and prepared statements with subqu...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Linux 5
Classification: Red Hat
Component: mysql
Version: 5.5
Hardware: x86_64
OS: Linux
high
high
Target Milestone: rc
: ---
Assignee: Tom Lane
QA Contact: qe-baseos-daemons
URL:
Whiteboard:
Depends On:
Blocks: 743405
TreeView+ depends on / blocked
 
Reported: 2010-11-16 15:48 UTC by Kal McFate
Modified: 2018-12-01 19:02 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-01-08 04:54:27 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
Proposed patch (1.57 KB, patch)
2010-12-03 21:27 UTC, Bryan Mason
no flags Details | Diff


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2013:0121 0 normal SHIPPED_LIVE Low: mysql security and bug fix update 2013-01-08 09:10:21 UTC

Description Kal McFate 2010-11-16 15:48:32 UTC
Description of problem:
crash when using explain and prepared statements with subqueries

Version-Release number of selected component (if applicable):
mysql-5.0.77-4.el5_5.4

How reproducible:
drop table if exists `t1`;
create table `t1`(`a` int)engine=myisam;
insert into `t1` values (1),(1);
prepare `stmt` from 'explain 
select 1 from `t1`
where(select(select 1 from `t1` group by `a`))'; 
execute `stmt` ;

 
Actual results:
mysql crashes

Expected results:
should not crash

Additional info:
Please see http://bugs.mysql.com/bug.php?id=54488

Comment 1 Bryan Mason 2010-12-03 18:14:03 UTC
I believe the upstream fix for this in MySQL 5.1 is here:

http://bazaar.launchpad.net/~mysql/mysql-server/mysql-5.1/revision/3461.1.32

Comment 2 Bryan Mason 2010-12-03 21:27:16 UTC
Created attachment 464657 [details]
Proposed patch

Patch backported from upstream (pretty much verbatim -- only the line numbers changed).

Resolve the issue in my testing.

Comment 5 RHEL Program Management 2011-05-31 14:42:52 UTC
This request was evaluated by Red Hat Product Management for
inclusion in the current release of Red Hat Enterprise Linux.
Because the affected component is not scheduled to be updated in the
current release, Red Hat is unfortunately unable to address this
request at this time. Red Hat invites you to ask your support
representative to propose this request, if appropriate and relevant,
in the next release of Red Hat Enterprise Linux.

Comment 6 RHEL Program Management 2011-09-23 00:37:21 UTC
This request was evaluated by Red Hat Product Management for
inclusion in the current release of Red Hat Enterprise Linux.
Because the affected component is not scheduled to be updated in the
current release, Red Hat is unfortunately unable to address this
request at this time. Red Hat invites you to ask your support
representative to propose this request, if appropriate and relevant,
in the next release of Red Hat Enterprise Linux.

Comment 8 RHEL Program Management 2012-04-19 11:47:53 UTC
This request was evaluated by Red Hat Product Management for inclusion
in a Red Hat Enterprise Linux release.  Product Management has
requested further review of this request by Red Hat Engineering, for
potential inclusion in a Red Hat Enterprise Linux release for currently
deployed products.  This request is not yet committed for inclusion in
a release.

Comment 13 errata-xmlrpc 2013-01-08 04:54:27 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHSA-2013-0121.html


Note You need to log in before you can comment on or make changes to this bug.