diff options
| author | unknown <lenz@mysql.com> | 2003-04-25 14:42:01 +0200 |
|---|---|---|
| committer | unknown <lenz@mysql.com> | 2003-04-25 14:42:01 +0200 |
| commit | a8d6374fef97a4fb8617880386e706b4856e807d (patch) | |
| tree | a7714b441c37d2890ab77970799a264c000c8cc0 /mysql-test | |
| parent | 616b717db5431924d92d57bd523c6beb330ccac5 (diff) | |
| download | mariadb-git-a8d6374fef97a4fb8617880386e706b4856e807d.tar.gz | |
- Updated innodb test results on Heikki's request (InnoDB now supports
ANALYZE TABLE)
BitKeeper/etc/ignore:
Added support-files/MacOSX/ReadMe.txt to the ignore list
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/innodb.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index 293519604dd..5049dec9ef1 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -208,7 +208,7 @@ create index skr on t1 (a); insert into t1 values (3,""), (4,"testing"); analyze table t1; Table Op Msg_type Msg_text -test.t1 analyze error The handler for the table doesn't support analyze +test.t1 analyze status OK show keys from t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment t1 1 skr 1 a A 3 NULL NULL YES BTREE @@ -1227,10 +1227,10 @@ count(*) 29267 explain select a from t1 where a between 1 and 10000; table type possible_keys key key_len ref rows Extra -t1 range PRIMARY PRIMARY 4 NULL 14790 Using where; Using index +t1 range PRIMARY PRIMARY 4 NULL 14745 Using where; Using index explain select * from t1 where a between 1 and 10000; table type possible_keys key key_len ref rows Extra -t1 range PRIMARY PRIMARY 4 NULL 14790 Using where +t1 range PRIMARY PRIMARY 4 NULL 14745 Using where explain select * from t1 where c between 1 and 10000; table type possible_keys key key_len ref rows Extra t1 range c c 5 NULL 1 Using where |