summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_default.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/partition_default.result')
-rw-r--r--mysql-test/main/partition_default.result42
1 files changed, 21 insertions, 21 deletions
diff --git a/mysql-test/main/partition_default.result b/mysql-test/main/partition_default.result
index db3b714bbcc..fa947531250 100644
--- a/mysql-test/main/partition_default.result
+++ b/mysql-test/main/partition_default.result
@@ -21,7 +21,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p2` VALUES IN (4,5,6) ENGINE = MyISAM,
PARTITION `p1` VALUES IN (1) ENGINE = MyISAM,
@@ -71,7 +71,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p0` DEFAULT ENGINE = MyISAM,
PARTITION `p2` VALUES IN (4,5,6) ENGINE = MyISAM,
@@ -99,7 +99,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p0` DEFAULT ENGINE = MyISAM,
PARTITION `p2` VALUES IN (4,5,6) ENGINE = MyISAM,
@@ -127,7 +127,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST COLUMNS(`a`,`b`)
(PARTITION `p2` VALUES IN ((1,4),(2,5),(3,6)) ENGINE = MyISAM,
PARTITION `p1` VALUES IN ((1,1),(0,0)) ENGINE = MyISAM,
@@ -175,7 +175,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p2` VALUES IN (4,5,6) ENGINE = MyISAM,
PARTITION `p1` VALUES IN (1,20) ENGINE = MyISAM,
@@ -255,7 +255,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST COLUMNS(`a`,`b`)
(PARTITION `p2` VALUES IN ((1,4),(2,5),(3,6),(5,5)) ENGINE = MyISAM,
PARTITION `p1` VALUES IN ((1,1),(20,20)) ENGINE = MyISAM,
@@ -324,7 +324,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a` + `b`)
(PARTITION `p2` VALUES IN (1,2,3,7) ENGINE = MyISAM,
PARTITION `p1` VALUES IN (21,0) ENGINE = MyISAM,
@@ -361,7 +361,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a` + 5)
(PARTITION `p2` VALUES IN (1,2,3,7) ENGINE = MyISAM,
PARTITION `p1` VALUES IN (0) ENGINE = MyISAM,
@@ -831,7 +831,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p2` VALUES IN (1,2,3) ENGINE = MyISAM,
PARTITION `p1` VALUES IN (20,0) ENGINE = MyISAM,
@@ -865,7 +865,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p2` VALUES IN (1,2,3) ENGINE = MyISAM,
PARTITION `p1` VALUES IN (20,0) ENGINE = MyISAM,
@@ -899,7 +899,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p2` DEFAULT ENGINE = MyISAM,
PARTITION `p1` VALUES IN (20,0) ENGINE = MyISAM,
@@ -926,7 +926,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p1` VALUES IN (20,0) ENGINE = MyISAM,
PARTITION `p0` VALUES IN (10) ENGINE = MyISAM)
@@ -944,7 +944,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`a`)
(PARTITION `p1` VALUES IN (20,0) ENGINE = MyISAM,
PARTITION `p0` VALUES IN (10) ENGINE = MyISAM,
@@ -976,7 +976,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST COLUMNS(`a`,`b`)
(PARTITION `p2` VALUES IN ((1,4),(2,5),(3,6)) ENGINE = MyISAM,
PARTITION `p1` VALUES IN ((1,1),(0,0)) ENGINE = MyISAM,
@@ -1010,7 +1010,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST COLUMNS(`a`,`b`)
(PARTITION `p2` VALUES IN ((1,4),(2,5),(3,6)) ENGINE = MyISAM,
PARTITION `p1` VALUES IN ((1,1),(0,0)) ENGINE = MyISAM,
@@ -1044,7 +1044,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST COLUMNS(`a`,`b`)
(PARTITION `p2` DEFAULT ENGINE = MyISAM,
PARTITION `p1` VALUES IN ((1,1),(0,0)) ENGINE = MyISAM,
@@ -1071,7 +1071,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST COLUMNS(`a`,`b`)
(PARTITION `p1` VALUES IN ((1,1),(0,0)) ENGINE = MyISAM,
PARTITION `p0` VALUES IN ((10,10)) ENGINE = MyISAM)
@@ -1089,7 +1089,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST COLUMNS(`a`,`b`)
(PARTITION `p1` VALUES IN ((1,1),(0,0)) ENGINE = MyISAM,
PARTITION `p0` VALUES IN ((10,10)) ENGINE = MyISAM,
@@ -1137,7 +1137,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST COLUMNS(`a`,`b`)
(PARTITION `p0` DEFAULT ENGINE = MyISAM,
PARTITION `p2` VALUES IN ((1,4),(2,5),(3,6)) ENGINE = MyISAM,
@@ -1244,7 +1244,7 @@ SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`i` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`i`)
(PARTITION `pdef` DEFAULT ENGINE = MyISAM)
DROP TABLE t1;
@@ -1261,7 +1261,7 @@ SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`i` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY LIST (`i`)
(PARTITION `p` VALUES IN (1,2,3,4) ENGINE = MyISAM)
DROP TABLE t1;
View Lorry Controller Status