| Bug #65995 | MySQL 5.5.20 sql_select.cc has error | ||
|---|---|---|---|
| Submitted: | 24 Jul 2012 10:49 | Modified: | 30 Jan 2013 0:38 |
| Reporter: | henry king | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
| Version: | 5.5.20, 5.5.28 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[24 Jul 2012 12:49]
Sveta Smirnova
Thank you for the report. Verified as described using code analysis.
[30 Jan 2013 0:38]
Omer Barnir
This issue is fixed in 5.6.
Description: When i research the optimizer of mysql server, find a error in line 5439 of sql/sql_select.cc. The error will not bring any questions for applications, but will mislead developers when debugging the source or analyzing the trace information of mysql debug version. The details: DBUG_EXECUTE("opt", print_plan(join, idx, read_time, record_count, idx, "SOFAR:");); The sequence of variables of read_time and record_count is reversed. How to repeat: Check the source of MySQL 5.5.20, in the line 5439 of sql/sql_select.cc. Suggested fix: The modification is as follows: DBUG_EXECUTE("opt", print_plan(join, idx, record_count, read_time, idx, "SOFAR:"););