summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/tc_partition_change_from_range_to_hash_key.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_partition_change_from_range_to_hash_key.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/tc_partition_change_from_range_to_hash_key.result48
1 files changed, 24 insertions, 24 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_partition_change_from_range_to_hash_key.result b/mysql-test/suite/engines/funcs/r/tc_partition_change_from_range_to_hash_key.result
index 93208147dc4..9710b55cdf6 100644
--- a/mysql-test/suite/engines/funcs/r/tc_partition_change_from_range_to_hash_key.result
+++ b/mysql-test/suite/engines/funcs/r/tc_partition_change_from_range_to_hash_key.result
@@ -33,7 +33,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
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -55,7 +55,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;
@@ -96,7 +96,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
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -118,7 +118,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;
@@ -159,7 +159,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
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -181,7 +181,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;
@@ -222,7 +222,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
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -244,7 +244,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;
@@ -285,7 +285,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
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -307,7 +307,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;
@@ -348,7 +348,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
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -370,7 +370,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;
@@ -411,7 +411,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 KEY (`c1`)
PARTITIONS 5
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -433,7 +433,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 KEY (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -474,7 +474,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 KEY (`c1`)
PARTITIONS 5
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -496,7 +496,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 KEY (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -537,7 +537,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 KEY (`c1`)
PARTITIONS 5
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -559,7 +559,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 KEY (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -600,7 +600,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 KEY (`c1`)
PARTITIONS 5
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -622,7 +622,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 KEY (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -663,7 +663,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 KEY (`c1`)
PARTITIONS 5
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -685,7 +685,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 KEY (`c1`)
PARTITIONS 3
DROP TABLE t1;
@@ -726,7 +726,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 KEY (`c1`)
PARTITIONS 5
ALTER TABLE t1 COALESCE PARTITION 2;
@@ -748,7 +748,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 KEY (`c1`)
PARTITIONS 3
DROP TABLE t1;