Bug #56254 | Assertion tab->ref.use_count fails in join_read_key_unlock_row() on 4-way JOIN | ||
---|---|---|---|
Submitted: | 25 Aug 2010 14:16 | Modified: | 22 Nov 2010 1:21 |
Reporter: | John Embretsen | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S1 (Critical) |
Version: | bzr_mysql-next-mr-opt-team | OS: | Any |
Assigned to: | Guilhem Bichot | CPU Architecture: | Any |
[25 Aug 2010 14:16]
John Embretsen
[25 Aug 2010 14:19]
John Embretsen
Verified with debug builds on OpenSolaris 2009.06 snv_111b X86_64 and Ubuntu 9.04 x86_64.
[26 Aug 2010 13:26]
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/116887 3232 Guilhem Bichot 2010-08-26 Fix for BUG#56254 "Assertion tab->ref.use_count fails in join_read_key_unlock_row() on 4-way JOIN" now that evaluate_null_complemented_join_record() cascades into evaluate_join_record() (after fix for BUG 54437), this started unlocking a NULL-complemented (thus non-locked) row... @ mysql-test/t/join_outer.test test for bug, used to assert in join_read_key_unlock_row() @ sql/sql_select.cc don't unlock NULL-complemented rows, they are not in table, they are not locked. For the test to be reliable, not_null_compl needs to be properly set: we set it to true at start of sub_select(), before we read rows from the table; if we find no matching row, sub_select() calls evaluate_null_complemented_join_record() which sets it to false. Next time we read the table in the nested loop join, sub_select() sets it to true again.
[1 Sep 2010 7:49]
Guilhem Bichot
queued to next-mr-opt-backporting
[2 Oct 2010 18:14]
Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101002181053-6iotvl26uurcoryp) (version source revid:alexander.nozdrin@oracle.com-20101002180917-h0n62akupm3z20nt) (pib:21)
[13 Nov 2010 16:22]
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 1:21]
Paul DuBois
Bug is not in any released 5.6.x version. No changelog entry needed.