summaryrefslogtreecommitdiff
path: root/mysql-test/r/myisam.result
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2001-11-18 14:08:17 +0200
committerunknown <monty@hundin.mysql.fi>2001-11-18 14:08:17 +0200
commit421595c12e731bb50e6fe6f9985d950e023e4667 (patch)
tree3d0563b3a96cfaa7e8b9b687efcb6f1407f7f58b /mysql-test/r/myisam.result
parent7803c4432cb392ad69dc292038118465c9616121 (diff)
downloadmariadb-git-421595c12e731bb50e6fe6f9985d950e023e4667.tar.gz
Fixed bug in OPTIMIZE TABLE that reset index cardinality if it
was up to date. Docs/manual.texi: ChangeLog configure.in: Version number change mysql-test/r/myisam.result: Test of optimize table mysql-test/t/myisam.test: Test of optimize table
Diffstat (limited to 'mysql-test/r/myisam.result')
-rw-r--r--mysql-test/r/myisam.result10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result
index 1152ca24f38..143802a4d05 100644
--- a/mysql-test/r/myisam.result
+++ b/mysql-test/r/myisam.result
@@ -10,3 +10,13 @@ Table Op Msg_type Msg_text
test.t1 repair status OK
Table Op Msg_type Msg_text
test.t1 check status OK
+Table Op Msg_type Msg_text
+test.t1 optimize status OK
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
+t1 0 PRIMARY 1 a A 5 NULL NULL
+t1 1 b 1 b A 1 NULL NULL
+Table Op Msg_type Msg_text
+test.t1 optimize status Table is already up to date
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
+t1 0 PRIMARY 1 a A 5 NULL NULL
+t1 1 b 1 b A 1 NULL NULL