summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/innodb.result14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result
index a422f55767d..63674d050c1 100644
--- a/mysql-test/r/innodb.result
+++ b/mysql-test/r/innodb.result
@@ -111,11 +111,11 @@ id parent_id level
1010 102 2
1015 102 2
table type possible_keys key key_len ref rows Extra
-t1 index level level 1 NULL 39 where used; Using index
+t1 ref level level 1 const 12 where used; Using index
table type possible_keys key key_len ref rows Extra
-t1 index level level 1 NULL 39 where used; Using index
+t1 ref level level 1 const 12 where used; Using index
table type possible_keys key key_len ref rows Extra
-t1 ref level level 1 const 12
+t1 ref level level 1 const 12 where used
level id
1 1002
1 1003
@@ -133,9 +133,9 @@ level id parent_id
Table Op Msg_type Msg_text
test.t1 optimize error The handler for the table doesn't support check/repair
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
-t1 0 PRIMARY 1 id A 2 NULL NULL
-t1 1 parent_id 1 parent_id A 2 NULL NULL
-t1 1 level 1 level A 2 NULL NULL
+t1 0 PRIMARY 1 id A 87 NULL NULL
+t1 1 parent_id 1 parent_id A 21 NULL NULL
+t1 1 level 1 level A 4 NULL NULL
gesuchnr benutzer_id
1 1
2 1
@@ -438,7 +438,7 @@ hello 1
Table Op Msg_type Msg_text
test.t1 optimize error The handler for the table doesn't support check/repair
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
-t1 0 PRIMARY 1 a A 2 NULL NULL
+t1 0 PRIMARY 1 a A 1 NULL NULL
i j
1 2
i j