Below is the list of changes that have just been committed into a local
5.1 repository of mattiasj. When mattiasj does a push these changes
will be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
ChangeSet@stripped, 2008-02-24 19:13:18+01:00, mattiasj@witty. +6 -0
Pre push fixes
Test file fixes for bugs 20129, 31931 and 34225
mysql-test/suite/parts/r/partition_basic_symlink_innodb.result@stripped, 2008-02-24
19:13:16+01:00, mattiasj@witty. +237 -237
Manual merge, new test case to be modified for Bug#20129
mysql-test/suite/parts/r/partition_basic_symlink_myisam.result@stripped, 2008-02-24
19:13:16+01:00, mattiasj@witty. +188 -188
Manual merge, new test case to be modified for Bug#20129
mysql-test/suite/parts/r/partition_engine_innodb.result@stripped, 2008-02-24 19:13:16+01:00,
mattiasj@witty. +10 -0
Manual merge, fix for bug#31931
mysql-test/suite/parts/r/partition_engine_myisam.result@stripped, 2008-02-24 19:13:17+01:00,
mattiasj@witty. +10 -0
Manual merge, fix for bug#31931
mysql-test/suite/parts/t/disabled.def@stripped, 2008-02-24 19:13:17+01:00, mattiasj@witty.
+0 -7
These should work now since Bug#34225 is fixed
sql/ha_partition.cc@stripped, 2008-02-24 19:13:17+01:00, mattiasj@witty. +4 -2
Bug#20129: partition maintenance command not working with crashed tables
Fix for compiler warnings.
diff -Nrup a/mysql-test/suite/parts/r/partition_basic_symlink_innodb.result
b/mysql-test/suite/parts/r/partition_basic_symlink_innodb.result
--- a/mysql-test/suite/parts/r/partition_basic_symlink_innodb.result 2008-02-06 15:13:52
+01:00
+++ b/mysql-test/suite/parts/r/partition_basic_symlink_innodb.result 2008-02-24 19:13:16
+01:00
@@ -469,16 +469,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -914,16 +914,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -1359,16 +1359,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -1802,16 +1802,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -2247,16 +2247,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -2690,16 +2690,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -3135,16 +3135,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -3580,16 +3580,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -4026,16 +4026,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -4471,16 +4471,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -4916,16 +4916,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -5359,16 +5359,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -5804,16 +5804,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -6247,16 +6247,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -6692,16 +6692,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -7137,16 +7137,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -7583,16 +7583,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -8028,16 +8028,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -8473,16 +8473,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -8916,16 +8916,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -9361,16 +9361,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -9804,16 +9804,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -10249,16 +10249,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -10705,16 +10705,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -11153,16 +11153,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -11609,16 +11609,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -12061,16 +12061,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -12511,16 +12511,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -12965,16 +12965,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -13421,16 +13421,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -13873,16 +13873,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -14355,16 +14355,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -14837,16 +14837,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -15319,16 +15319,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -15799,16 +15799,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -16281,16 +16281,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -16761,16 +16761,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -17243,16 +17243,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -17725,16 +17725,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -18208,16 +18208,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -18690,16 +18690,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -19172,16 +19172,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -19652,16 +19652,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -20134,16 +20134,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -20614,16 +20614,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -21096,16 +21096,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -21578,16 +21578,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -22077,16 +22077,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -22575,16 +22575,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -23073,16 +23073,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -23569,16 +23569,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -24067,16 +24067,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -24563,16 +24563,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -25061,16 +25061,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -25559,16 +25559,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -26056,16 +26056,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -26541,16 +26541,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -27034,16 +27034,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -27523,16 +27523,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -28010,16 +28010,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -28501,16 +28501,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -28994,16 +28994,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -29483,16 +29483,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -29969,16 +29969,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -30454,16 +30454,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -30947,16 +30947,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -31436,16 +31436,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -31923,16 +31923,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -32414,16 +32414,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -32907,16 +32907,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -33396,16 +33396,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -33898,16 +33898,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -34399,16 +34399,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -34908,16 +34908,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -35413,16 +35413,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -35916,16 +35916,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -36423,16 +36423,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -36932,16 +36932,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
@@ -37437,16 +37437,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
diff -Nrup a/mysql-test/suite/parts/r/partition_basic_symlink_myisam.result
b/mysql-test/suite/parts/r/partition_basic_symlink_myisam.result
--- a/mysql-test/suite/parts/r/partition_basic_symlink_myisam.result 2008-02-06 15:13:52
+01:00
+++ b/mysql-test/suite/parts/r/partition_basic_symlink_myisam.result 2008-02-24 19:13:16
+01:00
@@ -479,20 +479,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
# check layout success: 1
TRUNCATE t1;
@@ -934,20 +934,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
# check layout success: 1
TRUNCATE t1;
@@ -1395,20 +1395,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
# check layout success: 1
TRUNCATE t1;
@@ -1850,20 +1850,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
# check layout success: 1
TRUNCATE t1;
@@ -2311,20 +2311,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
# check layout success: 1
TRUNCATE t1;
@@ -2770,20 +2770,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
# check layout success: 1
TRUNCATE t1;
@@ -3231,20 +3231,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
# check layout success: 1
TRUNCATE t1;
@@ -3694,20 +3694,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
# check layout success: 1
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
# check layout success: 1
TRUNCATE t1;
@@ -4148,16 +4148,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION p1
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI MYSQLTEST_VARDIR/master-data/test/t1.frm
MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -4167,7 +4167,7 @@ File list MYSQLTEST_VARDIR/master-data/t
# check layout success: 0
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION p1
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI MYSQLTEST_VARDIR/master-data/test/t1.frm
MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -4631,16 +4631,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION p1
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p3 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p4 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p5 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/tes
t/data' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYI MYSQLTEST_VARDIR/master-data/test/t1.frm
MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -4650,7 +4650,7 @@ File list MYSQLTEST_VARDIR/master-data/t
# check layout success: 0
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (f_int1) (PARTITION p1
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p3 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p4 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION p5 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/tes
t/data' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p3.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p4.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#p5.MYI MYSQLTEST_VARDIR/master-data/test/t1.frm
MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -5126,16 +5126,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4))
(PARTITION part_3 VALUES IN (-3) DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part_2 VALUES IN
(-2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part_1 VALUES IN
(-1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part_N VALUES IN
(NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/in
dex' ENGINE = MyISAM, PARTITION part0 VALUES IN (0) DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part1 VALUES IN (1)
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part2 VALUES IN (2)
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part3 VALUES IN (3)
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYI
MYSQLTEST_VARDIR/master-data/test/t1.frm MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -5145,7 +5145,7 @@ File list MYSQLTEST_VARDIR/master-data/t
# check layout success: 0
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (MOD(f_int1,4))
(PARTITION part_3 VALUES IN (-3) DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part_2 VALUES IN
(-2) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part_1 VALUES IN
(-1) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part_N VALUES IN
(NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/in
dex' ENGINE = MyISAM, PARTITION part0 VALUES IN (0) DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part1 VALUES IN (1)
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part2 VALUES IN (2)
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part3 VALUES IN (3)
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part_1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part_2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part_3.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part_N.MYI
MYSQLTEST_VARDIR/master-data/test/t1.frm MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -5611,16 +5611,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION
parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data'
INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION
partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data'
INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION
partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data'
INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION
partd VALUES LESS THAN (15) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data'
INDEX DIRECTORY = 'MYSQLTEST_VARDIR/maste
r-data/test/index' ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) DATA DIRECTORY
= 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION partf VALUES LESS
THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYI MYSQLTEST_VARDIR/master-data/test/t1.frm
MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -5630,7 +5630,7 @@ File list MYSQLTEST_VARDIR/master-data/t
# check layout success: 0
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) (PARTITION
parta VALUES LESS THAN (0) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data'
INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION
partb VALUES LESS THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data'
INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION
partc VALUES LESS THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data'
INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION
partd VALUES LESS THAN (15) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data'
INDEX DIRECTORY = 'MYSQLTEST_VARDIR/maste
r-data/test/index' ENGINE = MyISAM, PARTITION parte VALUES LESS THAN (20) DATA DIRECTORY
= 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION partf VALUES LESS
THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#parta.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partb.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partc.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partd.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#parte.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partf.MYI MYSQLTEST_VARDIR/master-data/test/t1.frm
MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -6106,16 +6106,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2)
SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION partb VALUES LESS
THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION partc VALUES LESS
THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION partd VALUES LESS
THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mast
er-data/test/data' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE =
MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYI MYS
QLTEST_VARDIR/master-data/test/t1.frm MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -6125,7 +6125,7 @@ File list MYSQLTEST_VARDIR/master-data/t
# check layout success: 0
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1 DIV 2)
SUBPARTITION BY HASH (f_int1) SUBPARTITIONS 2 (PARTITION parta VALUES LESS THAN (0) DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION partb VALUES LESS
THAN (5) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION partc VALUES LESS
THAN (10) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION partd VALUES LESS
THAN (2147483646) DATA DIRECTORY = 'MYSQLTEST_VARDIR/mast
er-data/test/data' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE =
MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#parta#SP#partasp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partb#SP#partbsp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partc#SP#partcsp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#partd#SP#partdsp1.MYI MYS
QLTEST_VARDIR/master-data/test/t1.frm MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -6599,16 +6599,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION
BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION subpart12 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part2 VALUES LESS
THAN (5) (SUBPARTITION subpart21 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION subpart22 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test
/data' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM),
PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION subpart32 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part4 VALUES LESS
THAN (2147483646) (SUBPARTITION subpart41 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION subpart42 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM)) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#s
ubpart42.MYI MYSQLTEST_VARDIR/master-data/test/t1.frm
MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -6618,7 +6618,7 @@ File list MYSQLTEST_VARDIR/master-data/t
# check layout success: 0
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (f_int1) SUBPARTITION
BY KEY (f_int1) (PARTITION part1 VALUES LESS THAN (0) (SUBPARTITION subpart11 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION subpart12 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part2 VALUES LESS
THAN (5) (SUBPARTITION subpart21 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION subpart22 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test
/data' INDEX DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM),
PARTITION part3 VALUES LESS THAN (10) (SUBPARTITION subpart31 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION subpart32 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part4 VALUES LESS
THAN (2147483646) (SUBPARTITION subpart41 DATA DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION subpart42 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM)) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart11.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#subpart12.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart21.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#subpart22.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart31.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#subpart32.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart41.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#subpart42.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#s
ubpart42.MYI MYSQLTEST_VARDIR/master-data/test/t1.frm
MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -7094,16 +7094,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION sp12 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part2 VALUES IN (1)
(SUBPARTITION sp21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION sp22
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIREC
TORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part3 VALUES
IN (2) (SUBPARTITION sp31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION sp32
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part4 VALUES IN
(NULL) (SUBPARTITION sp41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION sp42
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM)) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYI
MYSQLTEST_VARDIR/master-data/test/t1.frm MYSQLTEST_VARDIR/master-da
ta/test/t1.par
@@ -7113,7 +7113,7 @@ File list MYSQLTEST_VARDIR/master-data/t
# check layout success: 0
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3)))
SUBPARTITION BY HASH (f_int1 + 1) (PARTITION part1 VALUES IN (0) (SUBPARTITION sp11 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION sp12 DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part2 VALUES IN (1)
(SUBPARTITION sp21 DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION sp22
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIREC
TORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part3 VALUES
IN (2) (SUBPARTITION sp31 DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION sp32
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM), PARTITION part4 VALUES IN
(NULL) (SUBPARTITION sp41 DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, SUBPARTITION sp42
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM)) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp11.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#sp12.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp21.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#sp22.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp31.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#sp32.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp41.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part4#SP#sp42.MYI
MYSQLTEST_VARDIR/master-data/test/t1.frm MYSQLTEST_VARDIR/master-da
ta/test/t1.par
@@ -7593,16 +7593,16 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
+test.t1 analyze note The storage engine for the table doesn't support analyze
CHECK TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check note The storage engine for the table doesn't support check
CHECKSUM TABLE t1 EXTENDED;
Table Checksum
test.t1 <some_value>
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 optimize status OK
+test.t1 optimize note The storage engine for the table doesn't support optimize
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part2 VALUES IN (1)
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part3 VALUES IN
(NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYI MYS
QLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYI
MYSQLTEST_VARDIR/master-data/test/t1.frm MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -7612,7 +7612,7 @@ File list MYSQLTEST_VARDIR/master-data/t
# check layout success: 0
REPAIR TABLE t1 EXTENDED;
Table Op Msg_type Msg_text
-test.t1 repair status OK
+test.t1 repair note The storage engine for the table doesn't support repair
state new
Table definition SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` (
`f_int1` int(11) DEFAULT NULL, `f_int2` int(11) DEFAULT NULL, `f_char1` char(20)
DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY LIST (ABS(MOD(f_int1,2)))
SUBPARTITION BY KEY (f_int1) SUBPARTITIONS 3 (PARTITION part1 VALUES IN (0) DATA
DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part2 VALUES IN (1)
DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM, PARTITION part3 VALUES IN
(NULL) DATA DIRECTORY = 'MYSQLTEST_VARDIR/master-data/test/data' INDEX DIRECTORY =
'MYSQLTEST_VARDIR/master-data/test/index' ENGINE = MyISAM) */
File list MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part1#SP#part1sp2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp1.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part2#SP#part2sp2.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp0.MYI
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp1.MYI MYS
QLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYD
MYSQLTEST_VARDIR/master-data/test/t1#P#part3#SP#part3sp2.MYI
MYSQLTEST_VARDIR/master-data/test/t1.frm MYSQLTEST_VARDIR/master-data/test/t1.par
@@ -8061,20 +8061,20 @@ AND f_int2 <> CAST(f_char1 AS SIGNED INT
AND f_charbig = '####updated per insert trigger####';
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
-test.t1 analyze status OK
