diff options
Diffstat (limited to 'mysql-test/main/myisam-optimize.result')
-rw-r--r-- | mysql-test/main/myisam-optimize.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/main/myisam-optimize.result b/mysql-test/main/myisam-optimize.result index 9de3c24301f..63cdcd9f248 100644 --- a/mysql-test/main/myisam-optimize.result +++ b/mysql-test/main/myisam-optimize.result @@ -10,7 +10,7 @@ t1 CREATE TABLE `t1` ( `pk` int(11) NOT NULL, `i` int(11) DEFAULT NULL, PRIMARY KEY (`pk`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci OPTIMIZE TABLE t1; Table Op Msg_type Msg_text test.t1 optimize status OK @@ -22,7 +22,7 @@ t1 CREATE TABLE `t1` ( `pk` int(11) NOT NULL, `i` int(11) DEFAULT NULL, PRIMARY KEY (`pk`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci OPTIMIZE TABLE t1; Table Op Msg_type Msg_text test.t1 optimize status Table is already up to date @@ -34,7 +34,7 @@ t1 CREATE TABLE `t1` ( `pk` int(11) NOT NULL, `i` int(11) DEFAULT NULL, PRIMARY KEY (`pk`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci OPTIMIZE TABLE t1; Table Op Msg_type Msg_text test.t1 optimize status Table is already up to date @@ -50,7 +50,7 @@ t1 CREATE TABLE `t1` ( `pk` int(11) NOT NULL, `i` int(11) DEFAULT NULL, PRIMARY KEY (`pk`) -) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 OPTIMIZE TABLE t1; Table Op Msg_type Msg_text test.t1 optimize status OK @@ -62,7 +62,7 @@ t1 CREATE TABLE `t1` ( `pk` int(11) NOT NULL, `i` int(11) DEFAULT NULL, PRIMARY KEY (`pk`) -) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 OPTIMIZE TABLE t1; Table Op Msg_type Msg_text test.t1 optimize status Table is already up to date @@ -74,7 +74,7 @@ t1 CREATE TABLE `t1` ( `pk` int(11) NOT NULL, `i` int(11) DEFAULT NULL, PRIMARY KEY (`pk`) -) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 OPTIMIZE TABLE t1; Table Op Msg_type Msg_text test.t1 optimize status Table is already up to date |