Red Hat Bugzilla – Bug 654000
Mysql bug 54488 - crash when using explain and prepared statements with subqueries
Last modified: 2013-07-02 23:33:22 EDT
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
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
Created attachment 464657 [details] Proposed patch Patch backported from upstream (pretty much verbatim -- only the line numbers changed). Resolve the issue in my testing.
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.
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.
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