summaryrefslogtreecommitdiff
path: root/mysql-test/r/show_check.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/show_check.result')
-rw-r--r--mysql-test/r/show_check.result36
1 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result
new file mode 100644
index 00000000000..63a9f4a8aad
--- /dev/null
+++ b/mysql-test/r/show_check.result
@@ -0,0 +1,36 @@
+Table Op Msg_type Msg_text
+test.t1 optimize status OK
+Table Op Msg_type Msg_text
+test.t1 check status OK
+test.t2 check error The handler for the table doesn't support check/repair
+Table Op Msg_type Msg_text
+test.t1 repair status OK
+test.t2 repair error The handler for the table doesn't support check/repair
+Table Op Msg_type Msg_text
+test.t2 check error The handler for the table doesn't support check/repair
+test.t1 check status OK
+Table Op Msg_type Msg_text
+test.t2 check error Table 't2' was not locked with LOCK TABLES
+test.t1 check status OK
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
+t1 0 PRIMARY 1 a A 4 NULL NULL
+t1 1 b 1 b A 1 NULL NULL
+t1 1 b 2 c A 2 NULL NULL
+Table Op Msg_type Msg_text
+test.t1 check status Table is already up to date
+Table Op Msg_type Msg_text
+test.t1 check status Table is already up to date
+Table Op Msg_type Msg_text
+test.t1 check status OK
+Table Op Msg_type Msg_text
+test.t1 check status OK
+Table Op Msg_type Msg_text
+test.t1 check 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
+t1 1 b 2 c A 2 NULL NULL
+Table Op Msg_type Msg_text
+test.t1 optimize status OK
+Table Op Msg_type Msg_text
+test.t1 optimize status Table is already up to date