summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/tc_partition_hash.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_partition_hash.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/tc_partition_hash.result168
1 files changed, 84 insertions, 84 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_partition_hash.result b/mysql-test/suite/engines/funcs/r/tc_partition_hash.result
index e7ac578fbfe..333598b49a8 100644
--- a/mysql-test/suite/engines/funcs/r/tc_partition_hash.result
+++ b/mysql-test/suite/engines/funcs/r/tc_partition_hash.result
@@ -8,7 +8,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -23,7 +23,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -38,7 +38,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -53,7 +53,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -68,7 +68,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -83,7 +83,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -98,7 +98,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -113,7 +113,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -128,7 +128,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -143,7 +143,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -158,7 +158,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -173,7 +173,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 1
DROP TABLE t1;
@@ -188,7 +188,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -203,7 +203,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -218,7 +218,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -233,7 +233,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -248,7 +248,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -263,7 +263,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -278,7 +278,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -293,7 +293,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -308,7 +308,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -323,7 +323,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -338,7 +338,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -353,7 +353,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 2
DROP TABLE t1;
@@ -368,7 +368,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -383,7 +383,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -398,7 +398,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -413,7 +413,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -428,7 +428,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -443,7 +443,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -458,7 +458,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -473,7 +473,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -488,7 +488,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -503,7 +503,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -518,7 +518,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -533,7 +533,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -548,7 +548,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -563,7 +563,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -578,7 +578,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -593,7 +593,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -608,7 +608,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -623,7 +623,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -638,7 +638,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -653,7 +653,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -668,7 +668,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -683,7 +683,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -698,7 +698,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -713,7 +713,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 4
DROP TABLE t1;
@@ -728,7 +728,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -743,7 +743,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -758,7 +758,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -773,7 +773,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -788,7 +788,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -803,7 +803,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -818,7 +818,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -833,7 +833,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -848,7 +848,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -863,7 +863,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -878,7 +878,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -893,7 +893,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 5
DROP TABLE t1;
@@ -908,7 +908,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -923,7 +923,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -938,7 +938,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -953,7 +953,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -968,7 +968,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -983,7 +983,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -998,7 +998,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -1013,7 +1013,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -1028,7 +1028,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -1043,7 +1043,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -1058,7 +1058,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -1073,7 +1073,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 10
DROP TABLE t1;
@@ -1088,7 +1088,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1103,7 +1103,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1118,7 +1118,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1133,7 +1133,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1148,7 +1148,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1163,7 +1163,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) DEFAULT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1178,7 +1178,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1193,7 +1193,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1208,7 +1208,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1223,7 +1223,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1238,7 +1238,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
@@ -1253,7 +1253,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL,
`c2` char(5) DEFAULT NULL
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`c1`)
PARTITIONS 50
DROP TABLE t1;
View Lorry Controller Status