summaryrefslogtreecommitdiff
path: root/mysql-test/r/innodb_mysql.result
diff options
context:
space:
mode:
authorunknown <igor@olga.mysql.com>2007-08-04 22:36:54 -0700
committerunknown <igor@olga.mysql.com>2007-08-04 22:36:54 -0700
commit03e379d36f1b734a9433a796b653076f94633f11 (patch)
tree6c59e80772a05c48ffc8db3d039320e4f1507503 /mysql-test/r/innodb_mysql.result
parent78a52138c7aaee9ec67c1041d9b7ecd2e45fc79a (diff)
parent35249143023c2a59631a1b26759a56826852c149 (diff)
downloadmariadb-git-03e379d36f1b734a9433a796b653076f94633f11.tar.gz
Merge olga.mysql.com:/home/igor/mysql-5.1
into olga.mysql.com:/home/igor/dev-opt/mysql-5.1-opt-merge mysql-test/include/read_many_rows.inc: Auto merged mysql-test/r/events_bugs.result: Auto merged mysql-test/r/innodb_mysql.result: Auto merged mysql-test/r/read_many_rows_innodb.result: Auto merged sql/handler.cc: Auto merged sql/mysqld.cc: Auto merged sql/sp_head.cc: Auto merged sql/sp_rcontext.cc: Auto merged sql/sql_class.cc: Auto merged sql/sql_parse.cc: Auto merged sql/sql_select.cc: Auto merged sql/share/errmsg.txt: Auto merged sql/sql_select.h: Auto merged sql/sql_table.cc: Auto merged sql/sql_union.cc: Auto merged sql/sql_class.h: Manual merge. storage/innobase/handler/ha_innodb.cc: Manual merge.
Diffstat (limited to 'mysql-test/r/innodb_mysql.result')
-rw-r--r--mysql-test/r/innodb_mysql.result22
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/r/innodb_mysql.result b/mysql-test/r/innodb_mysql.result
index 26000fa27b7..ae442acd1b9 100644
--- a/mysql-test/r/innodb_mysql.result
+++ b/mysql-test/r/innodb_mysql.result
@@ -879,13 +879,13 @@ EXPLAIN SELECT * FROM t1 WHERE b BETWEEN 1 AND 2 ORDER BY a;
id 1
select_type SIMPLE
table t1
-type range
+type index
possible_keys bkey
-key bkey
-key_len 5
+key PRIMARY
+key_len 4
ref NULL
-rows 16
-Extra Using where; Using index; Using filesort
+rows 32
+Extra Using where
SELECT * FROM t1 WHERE b BETWEEN 1 AND 2 ORDER BY a;
a b
1 2
@@ -974,13 +974,13 @@ EXPLAIN SELECT * FROM t2 WHERE b=1 ORDER BY a;
id 1
select_type SIMPLE
table t2
-type ref
+type index
possible_keys bkey
-key bkey
-key_len 5
-ref const
-rows 8
-Extra Using where; Using index; Using filesort
+key PRIMARY
+key_len 4
+ref NULL
+rows 16
+Extra Using where; Using index
SELECT * FROM t2 WHERE b=1 ORDER BY a;
a b c
1 1 1