Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
For bugs related to Red Hat Enterprise Linux 5 product line. The current stable release is 5.10. For Red Hat Enterprise Linux 6 and above, please visit Red Hat JIRA https://issues.redhat.com/secure/CreateIssue!default.jspa?pid=12332745 to report new issues.

Bug 654000

Summary: Mysql bug 54488 - crash when using explain and prepared statements with subqueries
Product: Red Hat Enterprise Linux 5 Reporter: Kal McFate <kmcfate>
Component: mysqlAssignee: Tom Lane <tgl>
Status: CLOSED ERRATA QA Contact: qe-baseos-daemons
Severity: high Docs Contact:
Priority: high    
Version: 5.5CC: azelinka, byte, hhorak, kvolny, rchidamb
Target Milestone: rcKeywords: Patch
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-01-08 04:54:27 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 743405    
Attachments:
Description Flags
Proposed patch none

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