Bug #46860 | Crash / segfault using EXPLAIN EXTENDED on query using UNION in subquery | ||
---|---|---|---|
Submitted: | 21 Aug 2009 19:25 | Modified: | 14 Dec 2010 23:37 |
Reporter: | Patrick Crews | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 5.4/6.0 | OS: | Any |
Assigned to: | Tor Didriksen | CPU Architecture: | Any |
Tags: | crashing bug, explain extended, regression, segfault, subquery, UNION |
[21 Aug 2009 19:25]
Patrick Crews
[21 Aug 2009 19:27]
Patrick Crews
Full RQG-generated crash output
Attachment: bug46860_crash_output.txt (text/plain), 17.21 KiB.
[24 Aug 2009 12:51]
MySQL Verification Team
simplified testcase query #0; drop table if exists `t1`; create table `t1` (`a` int) engine=myisam; explain extended select 1 from `t1`,`t1` as `t2` where `t1`.`a` > all ( (select `a` from `t1` ) union (select `a`) );
[21 Sep 2009 10:46]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/83886 2827 Tor Didriksen 2009-09-21 Bug #46860 Crash/segfault using EXPLAIN EXTENDED on query using UNION in subquery EXPLAIN EXTENDED <query> will not generate a Note with extended information if EXPLAIN <query> returns an error. @ mysql-test/r/explain.result Add testcase based on bug report. @ mysql-test/r/subselect3.result Remove the extended Note, since explain returns error. @ mysql-test/r/subselect3_jcl6.result Remove the extended Note, since explain returns error. @ mysql-test/t/explain.test Add testcase based on bug report. @ sql/sql_parse.cc Skip the extended description if we have an error.
[21 Sep 2009 12:57]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/83930 2829 Tor Didriksen 2009-09-21 Bug #46860 Crash/segfault using EXPLAIN EXTENDED on query using UNION in subquery EXPLAIN EXTENDED <query> will not generate a Note with extended information if EXPLAIN <query> returns an error. @ mysql-test/r/explain.result Add testcase based on bug report. @ mysql-test/r/subselect3.result Remove the extended Note, since explain returns error. @ mysql-test/r/subselect3_jcl6.result Remove the extended Note, since explain returns error. @ mysql-test/t/explain.test Add testcase based on bug report. @ sql/sql_parse.cc Skip the extended description if we have an error.
[21 Sep 2009 13:14]
Tor Didriksen
bzr push into mysql-6.0-bugfixing
[30 Sep 2009 8:16]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20090929093622-1mooerbh12e97zux) (version source revid:alik@sun.com-20090923103200-kyo2bakdo6tfb2fb) (merge vers: 6.0.14-alpha) (pib:11)
[1 Oct 2009 17:47]
Paul DuBois
Noted in 6.0.14 changelog. EXPLAIN EXTENDED did not generate a Note with extended information if the query was malformed. Setting report to NDI pending push into 5.4.x.
[1 Oct 2009 18:15]
Guilhem Bichot
Actually, the bug was that a malformed query would make EXPLAIN EXTENDED crash when wanting to show the optimizer-transformed query. Tor's fix is that if the query is malformed, EXPLAIN EXTENDED does not try to show the optimizer-transformed query at all (avoids the crash).
[8 Oct 2009 0:33]
Paul DuBois
Revised changelog entry: A malformed query caused EXPLAIN EXTENDED to crash during the attempt to display the the optimizer-transformed query. Now if the query is malformed, EXPLAIN EXTENDED does not try to show the optimizer-transformed query. Setting report to NDI pending push into 5.4.x.
[13 Apr 2010 11:58]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/105496 3071 Tor Didriksen 2010-04-13 Bug #46860 Crash/segfault using EXPLAIN EXTENDED on query using UNION in subquery Backport of tor.didriksen@sun.com-20090921125638-vwidsxe77gf16qkl EXPLAIN EXTENDED <query> will not generate a Note with extended information if EXPLAIN <query> returns an error. @ mysql-test/r/explain.result Add testcase based on bug report. @ mysql-test/r/subselect3.result Remove the extended Note, since explain returns error. @ mysql-test/t/explain.test Add testcase based on bug report. @ sql/sql_parse.cc Skip the extended description if we have an error.
[16 Aug 2010 6:37]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100816062819-bluwgdq8q4xysmlg) (version source revid:alik@sun.com-20100816062612-enatdwnv809iw3s9) (pib:20)
[13 Nov 2010 16:07]
Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (merge vers: 5.6.99-m4) (pib:21)
[22 Nov 2010 0:51]
Paul DuBois
Noted in 5.6.1 changelog.
[14 Dec 2010 23:37]
Paul DuBois
Correction: No 5.6.1 changelog entry needed.