From: Jorgen Loland Date: January 14 2011 2:11pm Subject: bzr push into mysql-next-mr-bugfixing branch (jorgen.loland:3251 to 3252) WL#5741 List-Archive: http://lists.mysql.com/commits/128775 Message-Id: <20110114141102.568207A3@atum21.norway.sun.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3252 Jorgen Loland 2011-01-14 WL#5741: Add optimizer tracing to subqueries Fix tracepoints so that all mtr test cases can be traced without JSON syntax errors. Added DYNAMIC_RANGE and REPEATED_SUBSELECT tracing features to avoid repeated tracing of range analysis and execution, respectively, of subselects. @ sql/item_subselect.cc Added Item_subselect::executed_before used to avoid tracing of subquery execution when this happens repeatedly for each record in outer select. @ sql/item_subselect.h Added Item_subselect::executed_before used to avoid tracing of subquery execution when this happens repeatedly for each record in outer select. @ sql/opt_range.cc Add tracepoints to range optimizer @ sql/sql_select.cc Add tracepoints to range optimizer added: mysql-test/r/optimizer_trace_subquery.result mysql-test/t/optimizer_trace_subquery.test modified: mysql-test/include/optimizer_trace.inc mysql-test/r/mysqld--help-notwin.result mysql-test/r/optimizer_trace2.result mysql-test/r/optimizer_trace_charset.result mysql-test/r/optimizer_trace_no_prot.result mysql-test/r/optimizer_trace_ps_prot.result mysql-test/r/optimizer_trace_range.result mysql-test/suite/sys_vars/r/optimizer_trace_features_basic.result mysql-test/t/optimizer_trace_range.test sql/item_subselect.cc sql/item_subselect.h sql/opt_range.cc sql/opt_trace.cc sql/opt_trace.h sql/sql_select.cc sql/sys_vars.cc 3251 Guilhem Bichot 2011-01-13 less code duplication modified: sql/opt_range.cc Diff too large for email (13595 lines, the limit is 10000). No bundle (reason: useless for push emails).