Bug #46797 | Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on | ||
---|---|---|---|
Submitted: | 18 Aug 2009 22:04 | Modified: | 17 Nov 2009 21:15 |
Reporter: | Patrick Crews | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 6.0 | OS: | Any |
Assigned to: | Øystein Grøvlen | CPU Architecture: | Any |
Tags: | crashing bug, optimizer_switch, outerjoin, semijoin, subquery |
[18 Aug 2009 22:04]
Patrick Crews
[18 Aug 2009 22:06]
Patrick Crews
Full crash output
Attachment: bug46797_crash_output.txt (text/plain), 18.69 KiB.
[17 Nov 2009 14:33]
Øystein Grøvlen
I have so far not been able to repeat this bug. I am currently checking whether I am able to repeat it on older versions.
[17 Nov 2009 21:15]
Øystein Grøvlen
I have not been able to repeat this on earlier versions of the 6.0 branch either.
[19 Nov 2009 10:00]
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/90939 3718 oystein.grovlen@sun.com 2009-11-19 Bug#46797 - Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on Adding test case from this bug report. Has not been able to reproduce the failure, not even on a few older versions of the code. @ mysql-test/r/subselect_sj.result Updated result file with new test for Bug#46797 @ mysql-test/r/subselect_sj_jcl6.result Updated result file with new test for Bug#46797 @ mysql-test/t/subselect_sj.test Added test case from Bug#46797
[19 Nov 2009 14:20]
Jørgen Løland
Regression test approved with minor changes.
[20 Nov 2009 11:49]
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/91058 3714 oystein.grovlen@sun.com 2009-11-20 Bug#46797 - Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on Adding test case from this bug report. Has not been able to reproduce the failure, not even on a few older versions of the code. @ mysql-test/r/subselect_sj.result Updated result file with new test for Bug#46797 @ mysql-test/r/subselect_sj_jcl6.result Updated result file with new test for Bug#46797 @ mysql-test/t/subselect_sj.test Added test case from Bug#46797
[20 Nov 2009 12:03]
Øystein Grøvlen
Test case pushed to mysql-6.0-codebase-bugfixing with revid oystein.grovlen@sun.com-20091120114850-lkzdwni27ug1eq6k
[11 Dec 2009 6:02]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091211055901-yp18b3c7xuhl87rf) (version source revid:alik@sun.com-20091211055401-43rjwq7gjed6ds83) (merge vers: 6.0.14-alpha) (pib:13)
[6 Apr 2010 13:34]
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/105084 3062 oystein.grovlen@sun.com 2010-04-06 Bug#46797 - Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on Adding test case from this bug report. Has not been able to reproduce the failure, not even on a few older versions of the code. @ mysql-test/r/subselect_sj.result Updated result file with new test for Bug#46797 @ mysql-test/t/subselect_sj.test Added test case from Bug#46797
[6 Apr 2010 13:39]
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/105085 3062 oystein.grovlen@sun.com 2010-04-06 Bug#46797 - Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on (Backporting of revid:oystein.grovlen@sun.com-20091120114850-lkzdwni27ug1eq6k) Adding test case from this bug report. Has not been able to reproduce the failure, not even on a few older versions of the code. @ mysql-test/r/subselect_sj.result Updated result file with new test for Bug#46797 @ mysql-test/t/subselect_sj.test Added test case from Bug#46797
[16 Aug 2010 6:36]
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:06]
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)