From: Marc Alff Date: August 26 2010 9:22pm Subject: bzr push into mysql-5.5-bugfixing branch (marc.alff:3193) List-Archive: http://lists.mysql.com/commits/116942 Message-Id: <20100826212216.1DB0045E80@linux-su11.site> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5614374773088990376==" --===============5614374773088990376== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline 3193 Marc Alff 2010-08-26 [merge] local merge added: mysql-test/r/mysql_not_windows.result mysql-test/suite/perfschema/r/bad_option_3.result mysql-test/suite/perfschema/r/bad_option_4.result mysql-test/suite/perfschema/r/bad_option_5.result mysql-test/suite/perfschema/r/short_option_1.result mysql-test/suite/perfschema/r/short_option_2.result mysql-test/suite/perfschema/t/bad_option_3.test mysql-test/suite/perfschema/t/bad_option_4.test mysql-test/suite/perfschema/t/bad_option_5.test mysql-test/suite/perfschema/t/short_option_1-master.opt mysql-test/suite/perfschema/t/short_option_1.test mysql-test/suite/perfschema/t/short_option_2-master.opt mysql-test/suite/perfschema/t/short_option_2.test mysql-test/t/mysql_not_windows.test modified: mysql-test/mysql-test-run.pl mysql-test/r/ctype_utf32.result mysql-test/r/mysql.result mysql-test/suite/ndb/r/ndb_binlog_ddl_multi.result mysql-test/suite/ndb/r/ndb_binlog_ignore_db.result mysql-test/suite/ndb/r/ndb_binlog_log_bin.result mysql-test/suite/ndb/r/ndb_binlog_multi.result mysql-test/suite/rpl_ndb/r/rpl_ndb_log.result mysql-test/suite/rpl_ndb/r/rpl_truncate_7ndb.result mysql-test/t/ctype_utf32.test mysql-test/t/mysql.test mysys/my_getopt.c sql/set_var.cc storage/myisam/mi_key.c storage/perfschema/pfs.cc storage/perfschema/pfs_stat.h === modified file 'mysql-test/r/create.result' --- a/mysql-test/r/create.result 2010-08-18 09:35:41 +0000 +++ b/mysql-test/r/create.result 2010-08-25 19:00:38 +0000 @@ -1542,6 +1542,7 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 === added file 'mysql-test/r/handler_read_last.result' --- a/mysql-test/r/handler_read_last.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/r/handler_read_last.result 2010-08-25 19:00:38 +0000 @@ -0,0 +1,60 @@ +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 (a INT, INDEX (a)); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +FLUSH STATUS; +SELECT a FROM t1 ORDER BY a LIMIT 1; +a +NULL +SHOW STATUS LIKE 'HANDLER_READ%'; +Variable_name Value +Handler_read_first 1 +Handler_read_key 0 +Handler_read_last 0 +Handler_read_next 0 +Handler_read_prev 0 +Handler_read_rnd 0 +Handler_read_rnd_next 0 +FLUSH STATUS; +SELECT a FROM t1 ORDER BY a DESC LIMIT 1; +a +NULL +SHOW STATUS LIKE 'HANDLER_READ%'; +Variable_name Value +Handler_read_first 0 +Handler_read_key 0 +Handler_read_last 1 +Handler_read_next 0 +Handler_read_prev 0 +Handler_read_rnd 0 +Handler_read_rnd_next 0 +FLUSH STATUS; +SELECT a FROM t1 ORDER BY a LIMIT 3; +a +NULL +NULL +NULL +SHOW STATUS LIKE 'HANDLER_READ%'; +Variable_name Value +Handler_read_first 1 +Handler_read_key 0 +Handler_read_last 0 +Handler_read_next 2 +Handler_read_prev 0 +Handler_read_rnd 0 +Handler_read_rnd_next 0 +FLUSH STATUS; +SELECT a FROM t1 ORDER BY a DESC LIMIT 3; +a +NULL +NULL +NULL +SHOW STATUS LIKE 'HANDLER_READ%'; +Variable_name Value +Handler_read_first 0 +Handler_read_key 0 +Handler_read_last 1 +Handler_read_next 0 +Handler_read_prev 2 +Handler_read_rnd 0 +Handler_read_rnd_next 0 +DROP TABLE t1; === modified file 'mysql-test/r/insert_select.result' --- a/mysql-test/r/insert_select.result 2009-09-22 21:41:37 +0000 +++ b/mysql-test/r/insert_select.result 2010-08-25 19:00:38 +0000 @@ -694,6 +694,7 @@ show status like 'Handler_read%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 === modified file 'mysql-test/r/join.result' --- a/mysql-test/r/join.result 2010-04-29 20:33:06 +0000 +++ b/mysql-test/r/join.result 2010-08-25 19:00:38 +0000 @@ -854,6 +854,7 @@ show status like 'Handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 === modified file 'mysql-test/r/join_outer.result' --- a/mysql-test/r/join_outer.result 2010-06-01 07:57:23 +0000 +++ b/mysql-test/r/join_outer.result 2010-08-25 19:00:38 +0000 @@ -1238,6 +1238,7 @@ show status like 'Handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 5 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 === modified file 'mysql-test/r/null_key.result' --- a/mysql-test/r/null_key.result 2008-03-11 12:47:16 +0000 +++ b/mysql-test/r/null_key.result 2010-08-25 19:00:38 +0000 @@ -424,6 +424,7 @@ SHOW STATUS LIKE "handler_read%"; Variable_name Value Handler_read_first 0 Handler_read_key 6 +Handler_read_last 0 Handler_read_next 2 Handler_read_prev 0 Handler_read_rnd 0 === modified file 'mysql-test/r/partition.result' --- a/mysql-test/r/partition.result 2010-05-28 05:47:58 +0000 +++ b/mysql-test/r/partition.result 2010-08-25 19:00:38 +0000 @@ -359,6 +359,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 2 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -377,6 +378,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 2 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -407,6 +409,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 2 Handler_read_prev 0 Handler_read_rnd 0 @@ -423,6 +426,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 2 Handler_read_prev 0 Handler_read_rnd 0 @@ -439,6 +443,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 2 Handler_read_prev 0 Handler_read_rnd 0 @@ -455,6 +460,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 2 Handler_read_prev 0 Handler_read_rnd 0 === modified file 'mysql-test/r/select.result' --- a/mysql-test/r/select.result 2010-07-15 13:47:50 +0000 +++ b/mysql-test/r/select.result 2010-08-25 19:00:38 +0000 @@ -4338,6 +4338,7 @@ SHOW STATUS LIKE 'Handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 2 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 === modified file 'mysql-test/r/single_delete_update.result' --- a/mysql-test/r/single_delete_update.result 2010-06-22 20:32:29 +0000 +++ b/mysql-test/r/single_delete_update.result 2010-08-25 19:00:38 +0000 @@ -25,6 +25,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -41,6 +42,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -74,6 +76,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -90,6 +93,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 5 @@ -120,6 +124,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -136,6 +141,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -170,6 +176,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -186,6 +193,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -214,6 +222,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -230,6 +239,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -256,6 +266,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -272,6 +283,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -301,6 +313,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 2 +Handler_read_last 0 Handler_read_next 7 Handler_read_prev 0 Handler_read_rnd 4 @@ -322,6 +335,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 2 +Handler_read_last 0 Handler_read_next 7 Handler_read_prev 0 Handler_read_rnd 8 @@ -357,6 +371,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 4 Handler_read_rnd 0 @@ -373,6 +388,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 4 Handler_read_rnd 0 @@ -406,6 +422,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -422,6 +439,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 5 @@ -464,6 +482,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -486,6 +505,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 1 Handler_read_next 0 Handler_read_prev 4 Handler_read_rnd 0 @@ -502,6 +522,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 1 Handler_read_next 0 Handler_read_prev 4 Handler_read_rnd 0 @@ -536,6 +557,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -552,6 +574,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 5 @@ -590,6 +613,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -606,6 +630,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 5 @@ -641,6 +666,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -657,6 +683,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -691,6 +718,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -707,6 +735,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 5 @@ -735,6 +764,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -751,6 +781,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -778,6 +809,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -794,6 +826,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -824,6 +857,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 2 +Handler_read_last 0 Handler_read_next 7 Handler_read_prev 0 Handler_read_rnd 4 @@ -845,6 +879,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 2 +Handler_read_last 0 Handler_read_next 7 Handler_read_prev 0 Handler_read_rnd 8 @@ -884,6 +919,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 4 Handler_read_rnd 0 @@ -900,6 +936,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 4 Handler_read_rnd 5 @@ -938,6 +975,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -954,6 +992,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 5 @@ -990,6 +1029,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 4 Handler_read_prev 0 Handler_read_rnd 0 @@ -1012,6 +1052,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 1 Handler_read_next 0 Handler_read_prev 4 Handler_read_rnd 0 @@ -1028,6 +1069,7 @@ SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 1 Handler_read_next 0 Handler_read_prev 4 Handler_read_rnd 5 === modified file 'mysql-test/r/subselect3.result' --- a/mysql-test/r/subselect3.result 2010-03-24 15:03:44 +0000 +++ b/mysql-test/r/subselect3.result 2010-08-25 19:00:38 +0000 @@ -113,6 +113,7 @@ show status like '%Handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 === modified file 'mysql-test/r/update.result' --- a/mysql-test/r/update.result 2010-07-19 09:21:24 +0000 +++ b/mysql-test/r/update.result 2010-08-25 19:00:38 +0000 @@ -273,6 +273,7 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -284,6 +285,7 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 2 @@ -294,6 +296,7 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 1 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -304,6 +307,7 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 1 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -315,6 +319,7 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 0 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 1 @@ -368,6 +373,7 @@ show status like 'handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 1 Handler_read_prev 0 Handler_read_rnd 1 @@ -405,6 +411,7 @@ show status like '%Handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 1 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -415,6 +422,7 @@ show status like '%Handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 2 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -424,6 +432,7 @@ show status like '%Handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 3 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 @@ -433,6 +442,7 @@ show status like '%Handler_read%'; Variable_name Value Handler_read_first 0 Handler_read_key 3 +Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 === added file 'mysql-test/t/handler_read_last.test' --- a/mysql-test/t/handler_read_last.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/t/handler_read_last.test 2010-08-25 19:00:38 +0000 @@ -0,0 +1,40 @@ +# Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software Foundation, +# 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +CREATE TABLE t1 (a INT, INDEX (a)); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); + +FLUSH STATUS; +SELECT a FROM t1 ORDER BY a LIMIT 1; +SHOW STATUS LIKE 'HANDLER_READ%'; + +FLUSH STATUS; +SELECT a FROM t1 ORDER BY a DESC LIMIT 1; +SHOW STATUS LIKE 'HANDLER_READ%'; + +FLUSH STATUS; +SELECT a FROM t1 ORDER BY a LIMIT 3; +SHOW STATUS LIKE 'HANDLER_READ%'; + +FLUSH STATUS; +SELECT a FROM t1 ORDER BY a DESC LIMIT 3; +SHOW STATUS LIKE 'HANDLER_READ%'; + +DROP TABLE t1; + === modified file 'sql/mysqld.cc' --- a/sql/mysqld.cc 2010-08-20 08:24:32 +0000 +++ b/sql/mysqld.cc 2010-08-25 19:00:38 +0000 @@ -6439,6 +6439,7 @@ SHOW_VAR status_vars[]= { {"Handler_prepare", (char*) offsetof(STATUS_VAR, ha_prepare_count), SHOW_LONG_STATUS}, {"Handler_read_first", (char*) offsetof(STATUS_VAR, ha_read_first_count), SHOW_LONG_STATUS}, {"Handler_read_key", (char*) offsetof(STATUS_VAR, ha_read_key_count), SHOW_LONG_STATUS}, + {"Handler_read_last", (char*) offsetof(STATUS_VAR, ha_read_last_count), SHOW_LONG_STATUS}, {"Handler_read_next", (char*) offsetof(STATUS_VAR, ha_read_next_count), SHOW_LONG_STATUS}, {"Handler_read_prev", (char*) offsetof(STATUS_VAR, ha_read_prev_count), SHOW_LONG_STATUS}, {"Handler_read_rnd", (char*) offsetof(STATUS_VAR, ha_read_rnd_count), SHOW_LONG_STATUS}, --===============5614374773088990376== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/marc.alff@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: marc.alff@stripped # target_branch: file:///home/malff/BZR_TREE/mysql-5.5-bugfixing-\ # 52312/ # testament_sha1: 7124f2a1e7d6bb5449ac64431197904ce63fc8ee # timestamp: 2010-08-26 15:22:16 -0600 # base_revision_id: chris.powers@stripped\ # zb7xchdw4adbtt0x # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWfMxcckADStfgAQwWvf//3/v 3+C////6YBUOpz7YL3qe+2r74+y7Z3dJ1ju7rLLY2ItmTXPr1detu+92rYaKEgGhqvpvNqWgro6V UElE0KeE0aYmJiAKeVP1PJopmSeoeoNNqND0gBKEA1GJJoTxEanqYgA0aDIaAbUDTQ0EoAiNQmk8 FT1T1PQj1HqAyMhiMQAAAEmpEJkJT8in6mnqaelGmJo00AMgD1GhiNABFSp41JtR6h6TQNGnqAA0 AaABoNAABJIBATJkAE0ZMhJpqGTQGgAAAe/gQB/YMR9F5g0Q38A07qWyO9XkOz4Gm7DB2mA3YntU isFBkKYQRhytQKSPq7M8fV6PScFmg3/OqJzODX2vFSyZK/TWmuwLrokk3OyKxsr7zLmt3thx5Ge/ SyqtmtoZlCEkRgxE3osmB+h5hVoIhlQDJOtnMkUAm1gsk1ajDrgQOvExXPCcFZT1O/PWsK2mWsmj dicC4UtZussOuZu3shLVmY3y1rlXUdbw2MtlSlMrLNsNGLyEunmrr5ZfiA+8ofuOLvCF6JGKQyZg ZhCkFFAUgsUIsFkFk9zw+mAQyvdKMh59+knR4fxPZ0fA3daqHB8U5Qpa+Fcq5t5MivTDtnKu01F2 rYxQ9Wt4VraZZM2NX7A5ezUlYfUPDLrLssMyNUVEwMrLrUD6alnD2NWLuFLlsKmGIxm9ByrCLhlp t1dU2wyDS2Y23i1Ue3PYufgztFrMNjTVLJSlbs871WqTSypVVfK9jRwxpqimObe1i1DhQpXeOz2O c6rAd3f2h5j1dcAOk5lCf5o3LwDlDBYBvOKqquUrN9AG4Y/qT3yA8wN8Rrf/QnGEpdiPSlzQpAYH HgnNlmrLtGH98emtFrH/IoJEXbyfIRjF2+NWIr6iF9NPFlj4kEzbiJCDnRBChPhJa0eSUdL8oyny znoB+w03EFUghNPCqoLJyfLD6snY6xjC3E5/1dGzX29dnXb3vvOf1dT4Npm7T+T5v7y02MCjcx9r IPsPVCvdXsK6Mdnf4lYfvQKexk/sqC84ub5gdoERLYhpYCdkOirKuWSm8IbWHcfTj/26zmZ/Ac3s k9/l4vOEFxo4jOykeIBBB0RQMAwMAjweNulkAMdD9Ufc9w6H8IjexfHYOJCuhTTkC7iNdXBGGZpc QtMr7RhCdejwSpDw0gsx5rVX0s+1xK6hVwSQa6lmja1rM5MIRa8YXdOoZnko9UDkEDEDEEnh0+8g mSatBGbYvIecJJ29O1YkLBuvXCmqrXAlVUlmQxQslMgdLCXYWSQ9lgWcDxc3Cxpg9wk0MAmsMe3A BxDEoRgsFCQdhepCTELhFgRrO0DUE4lhS7p5ExAlcccxDSCGijYZWga2HQA3M7ycXaXLRgp4HG2b bY2HEjc4ll71kXORZNMTV3gUQEc3IDQ+pk23KJwFQCzoRGHLEiAxq0Dx90CBUbUYftt16poUVSAH ad25WakeRZnrAM8WkPQAMOtxqNFG0aMgPd9bmMKMYwILwKnmtJvx6HLdREROleYrg4wMp3g4bjvl 5Gu/F8z1sVTeKJQ2kfxc45HerVsXBdgRkGSGNIHMTvSZDLvHhmPKkNjpkXVqnNcHtXrW3jKoHOra 4BtqG66zYP9nQbDDTAJ6k5QZaVaJbDuEEIhjfZrreSD5tExHOGYLqPBynYGYyKSWMqcRtXvqzKYv 4ORnogBbT1LTQ0SVQwMuATDFCrLSRtKtJIebTI2ITx5jCW3hMEZGJvH7b4+Wt/I0hvZXl4zm2DXV yI7mibZ+o+O664b9cBqUQNLhRBExraUc3NhUs0zhAVvi8jHY6QX5Y4WbI9UCTsSRchrsOkFzeYyT F02dNRcxkjrMkdVC5ZENp4UVKoIFX9NGjTH5inpLDYUOEBMsiQqeWgTVHP0HLtX47R9ka7BPgb8S sVwguNRXE7FhEyIk/UyOxI6pFDQW0HEdp/w5mj03mORwyOepPwcbNeOyFxlpm/Ig0aqGU+FCKGAs 81dcppxUPmbx1MCY6c4wU3SirXilW23svE5yi9zfAzL21O5jgGeRm8rJbswaU3lPDce67bimDFMr VUkSNYTlCFlF3jGxDC1vcoAVSUUoy5VpGOK9F33oGKNrLg3gYZbw59tx/3FI8irPG5rlpMR9HGb3 5zeNGqkoOCPTLq0Oq4rI7ScxemEAo0ZOaAG7Lssa+Ftnq1Iw7WZJjSQWsVm4RuKnFUNuBwIaVfwR QzfshsUjhrSUVxhuQtylsnQbh1NhdbXdNiRMimk1qTWTlXUXJR/7tHDptpNefGH9RiElvIFLymqJ gYe4crElQgbUwTOWRaQuIjDER5MokPHkiI8gSSOK0nwazaGdKgwvtLn43GLptGbR2PdQg5hzPuJQ lPsHWlcLNA6mw3LwZFUjge27jj4jdAB0GOUGPPktqj9JYOsdOd680rpeP35IV32RL1ccvS9EbCZX BVmzzwWvJp1TMS8FGVjLSPnLEpFzh8caNWNSBzKKhPM7pHI1art5IxMCUtBQ5nYvPM/QXpDzoXlw aTyIq3JtXGagwMwtjKTLWxPPZPiUuBTLVkxL5bM4t8vhc7TUyStC47mPtHrK0PYXQ01S2pygfBZd SAOkjLmBi19JAlIpEUiGhye8Qkr1IHXa8F61KJf3VkquUFHNxSQs5mxeMkjCtSUxUr2EADBfPeIm Que8dBexsO7leFLOeiD19T8JwIk4+4svHKesLu56Kruo/vedzEJ1xlcqKZdu2xQ9YNoLyQQmwMzZ jp09mMKcGLE9PCIcJ3ko9RwJKPLa5YglYbyOXiGcXuX1IkovFiBeLs1CtCuSqIFTiXJGDYsVQA33 IFKx5quLOHPQeZzLuIMeC4ZAG1W2GWeO3F7m2TWahp7YxjtZDs0UswgBgW5BKXuxeDnF2SPi7WE4 kOgISqJkbbsaJJ24EGA0ZorQoxM1XiV1KpNaFoFLS0Orjwrk2K2fOIGuouORQcr0EDnNSRqOMlam /jyJFQxbbCm2NiBpg57TVqutPxqFeJSCUAMDg+CLrIpknqt5zhl9DlnNk8S5XmUbFnCcEvvD8cjY of3SOV376Ivc9utBCo0mwNyq0m2JaWvGGNkNRiqHerbrrxqHJFHjphO6dynVUVLMDNQXKoYIREwU OgCklMyTnyIGrMTE/efE0VPvAystwoo7/g7OHyyTiY+IuQpGLBZ00oZQlFArJBOv+IR0LZFiWkA3 WA1Z5qwo3rN6m6vGB/Hihyze8t+/WMEgdzKcShZFEUIrPRJYDC1eTmDZcwA/2dAJAMHsEJh7AMmo oPQQ1gBADuA5qLAesuGiazaOwBgF2ZAeAD17bQL4wiAvaMARgaAfQoDERQ9ZgDp9c8AKBtYTqBzA 2AKkD+PYyBIf6AUoDwKSB5S4QUX2JuAaRwAyoO4HLrEG0BZKDbAWIueBeBsKgMQxpMZhGx4F4yB4 VaANxABgLyUA/e+8nFBWAXJkCySE1EC5SayIIEB33oZPMwwHnyAJkBjk5w/mGQgCBsAq1gUI99uI GzT5nNSBjwM9CYQ8PzpwgoAgggXiF5DzyQh4xAPHcD38CSZQoCYFeMFE06HU7x0ZE2NAeAxC+weI ZXjxIj0mfsImvmPKZMH3H2xM/tuMurn1ET0+gm5+QHVzNxx1F7ISItsNrIELUmtBxP98CqhQQb4D ltsQB9Z+aSBk2OPyD5EScgLZSRxCvBAIrEwAe4DeRRR+4+9JB/FaQA/UGANlBQVw5sDuAIpGwwDM mKp4aUj5gkZwiTz/OUNnxVbG7jeDC41HImd0/c8JYY2LHfIHRoeKh40cpQiZFKMcxoUIDFS0GBht 32jguOzz+GPr37E0j2DVEcslQtqOBaPlqOXwJAriifuokfDiKSDdQfmaxxAgbRxqMRuBUbhxMl0H Dj9o2CuOJ5Wnxr5h3TXHJjPoUMzoS4UfoDkFRjM6qO/+K8uizJyMQAchIbSkhPlBh4n5ZDeaihBI ZSstKUPhxYiWG1CeconbqTnIyZ38h5cHA9VebBl6V9POBMxMACB8hxMeYoChs3uIkjQWULR1wksU CRIGAIKPp8kolmZNVFpkdjcX6C0u6vLDNVkjnzWGh9Zikr+GmWDzaFCRGkgXsqHWGYk2m5Z+YbXt sgcco4UpIlByE6Cj5yeZunGumDwgcIVsCRBJkL0MjgZmXikDmchyEx8GCm/kPLc4eWi2xu99JNfd ckRLi4MzuHbsQ7EzI2WIXFCmpjIyZJnaAC8QMD0w+hRAhcNpwHqrQYkSFSDbwzr4XrylxG1GwkiC 9q79BuwnoKSl3CzJb2E2po4mqad8o/mNHbHnIoNBS60vZOTQtOjdR/g4JUEyxqgYoVHf7lOFSScJ kB06p9dSa9xikgWlO7pGrAeeFU9dhqNHsX11EEJhniSzuoFIB8UtHpByJESIFQJcgjsHK09+Zocj oCPB409fq3exImSGG7jzyNpI9DqWnasoWWtkeC40pIOxgcLOoe44weSMYj8NZqLi1JWzLDkgRNJT 2dJn/UL3QuiFZCh8wgeR0N6RdYOx4nnoL6y5lwO5R+H1lFOZsOWWJ7Ey/2ZQ9XTOhoNx0SGEDVjV FhocVJj6O99PfBQNOAdYY3mnIyPLEq6xPcSW0xP5dxmI2ZkrSkVEFi9/uXMnQXsQoeZ1F3kjWUd3 lOAOiGE9oU8XzC9guT20gRZ5nrW9TMfb0ESu83j13X3g/qRPYEpDhrDZQ+aSvGqPrN5qDAzs4gIl 7PMi8Lx7UXBMmEFNncpyWGo66iw+36jsWFWDDJhmSXsXnkahwVuGZbVoz3JA4ivOO0tUPU89fyLj sxaYoV+4gdwv9qRI8MN2iIfwwGMLjJSRRER0slpLS3gxhUSwhrIoApo/9X3S3yC9oKAgwtMOsT1S HHwbSZYQOgcn6DIdEAVFK0sY0Sy3pNQsQFsZQMSTlCbUiRUgCtwEFqAEWWK6ptqEw4EhyFYaeoyI zDOhGhUGSR2sQukFQsVV6zOVo0GdM+VXsYIh2Ng8t8EfFUUJWgtY6IaJyOJ3SIk5fQZ5mvCEKhN5 CB9D2EmQtAMOd8jgiSA2GV8kCQ3mMbiWBMbIiRRpJ0cusjb2Rrd3KI4hl1CmrXsdrpe4cZEq9Ih1 CSVEZhfvhvhOgtxNDSwVNQB1CWC8vJAml05a5lprAxxYorisq4mo2Hzr5SPBSpXhYnYD0k8YTMgJ ZxICzlmYvSMlNZe4a4emnRAzkeBU4fXHqcZDtFx5CEsipiAyEbuJO229ir9mRjl4GOoJGgQT1QFk 9r4nNHE3jO5bOVfzo9CYb7FxMY9GqT3E5YICg317EAchqExAb95wSiSWbkMK8hpXMgMsJMuajf1h kYLAikdTqQ1mP2DKBiHOYbrj5FkkjekeBCeThidIbTghany8JCweFzE+gZIE3HZmERgwggrl8jtf maECGJuGOA7QgQuy3lDHZIAITQk2YcD8Q9JYCUkDTLPEdy478EY1XD3WVgMbbZKDE1wCUw3AyHKr 0B+od0gLnvqahcNWFfDk9QiRmvd1clmROKnXHvYdKGSRYZBQtrB1vrqWZ0XIqVdflBBJkzKaFq06 Tj8rjVFIJoVh0n09EnJiycDumzvbITaqqqqqq7uXP7cEe5rWgElkMkwxiz2EMJWm6ajWIMyVtg4V uLNrFrHMNqBWkIBBghDfqplpxYSSV5SOipBQvxgIOECJtGYGW5XgD18rS6RNCZI2LAQnfF7goYUa o4DJcqiilCmoZaVBYF+DTs0goJCY7mo3YRSTfFC3M3A+KZ6yI9zKpuhkkGItBb3OHUTZXTVhAgN6 gJzeh24ymeg+K14lBRbOGlI+mBrMDwGvoaEAawrzyzTj6zShB7xOLHY8NmfVPFI5sHT1GuLN+y6b hy1+EgLj0CHuM1ptKHchVKhWJEqm2W7dRNjziZFdWTXpGKBCNY4aczgazNAGjurLA04rkVZG5eRk cwukWG1dzImpmsdpMZAgDF3vG0HoUKJIdDpUJyZAWFRrvURqJCKsofd1cCC8KHLqQD0s0nHppeNI TiB6XlC02FRRrMoUFr+1CME0qCspxF5Ia9Wo2zK3iWXoUgxXJ82EJeMNxpcWmRAFCRMFBZw/8Xck U4UJDzMXHJA= --===============5614374773088990376==--