diff options
Diffstat (limited to 'mysql-test/suite/parts/r/alter_table.result')
| -rw-r--r-- | mysql-test/suite/parts/r/alter_table.result | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/mysql-test/suite/parts/r/alter_table.result b/mysql-test/suite/parts/r/alter_table.result index 7f81eb17944..53eb482d85d 100644 --- a/mysql-test/suite/parts/r/alter_table.result +++ b/mysql-test/suite/parts/r/alter_table.result @@ -5,7 +5,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (`a`) SUBPARTITION BY KEY (`a`) (PARTITION `p0` VALUES LESS THAN (10) @@ -48,7 +48,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (`a`) (PARTITION `p0` VALUES LESS THAN (0) ENGINE = X, PARTITION `p1` VALUES LESS THAN (10) ENGINE = X) @@ -59,12 +59,12 @@ show create table tp2; Table Create Table tp2 CREATE TABLE `tp2` ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (`a`) (PARTITION `p0` VALUES LESS THAN (0) ENGINE = X, PARTITION `p1` VALUES LESS THAN (10) ENGINE = X) @@ -89,7 +89,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (`a`) (PARTITION `p0` VALUES LESS THAN (0) ENGINE = X, PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, @@ -179,7 +179,7 @@ show create table tp2; Table Create Table tp2 CREATE TABLE `tp2` ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci select * from tp2; x 12 @@ -187,7 +187,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (`x`) (PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, PARTITION `p3` VALUES LESS THAN (30) ENGINE = X, @@ -209,7 +209,7 @@ show create table EXISTENT.TP3; Table Create Table TP3 CREATE TABLE `TP3`-ok ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci select * from EXISTENT.TP3 order by x; x 22 @@ -217,7 +217,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (`x`) (PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, PARTITION `p4` VALUES LESS THAN (40) ENGINE = X, @@ -239,7 +239,7 @@ show create table tp4; Table Create Table tp4 CREATE TABLE `tp4` ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci select * from tp4; x 32 @@ -247,7 +247,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (`x`) (PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, PARTITION `p5` VALUES LESS THAN (50) ENGINE = X, @@ -264,7 +264,7 @@ show create table tp5; Table Create Table tp5 CREATE TABLE `tp5` ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci select * from tp5; x 42 @@ -272,7 +272,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `x` int(11) DEFAULT NULL -) ENGINE=X DEFAULT CHARSET=latin1 +) ENGINE=X DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (`x`) (PARTITION `p1` VALUES LESS THAN (10) ENGINE = X, PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = X) |