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:
None 
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 10:49] henry king
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:"););
[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.