summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_datatype.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/partition_datatype.result')
-rw-r--r--mysql-test/main/partition_datatype.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/partition_datatype.result b/mysql-test/main/partition_datatype.result
index 2e518c194f0..fb2635ceda9 100644
--- a/mysql-test/main/partition_datatype.result
+++ b/mysql-test/main/partition_datatype.result
@@ -332,7 +332,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` bit(27) NOT NULL,
PRIMARY KEY (`a`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY HASH (`a`)
(PARTITION `p0` ENGINE = MyISAM,
PARTITION `p1` ENGINE = MyISAM,
@@ -853,7 +853,7 @@ Table Create Table
t2 CREATE TABLE `t2` (
`a` timestamp NULL DEFAULT NULL,
`tz` varchar(16) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY RANGE (unix_timestamp(`a`))
(PARTITION `p0` VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION `p-2000` VALUES LESS THAN (946684800) ENGINE = MyISAM,
@@ -1337,7 +1337,7 @@ Table Create Table
t2 CREATE TABLE `t2` (
`a` timestamp NULL DEFAULT NULL,
`tz` varchar(16) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY RANGE (unix_timestamp(`a`))
(PARTITION `p0` VALUES LESS THAN (0) ENGINE = MyISAM,
PARTITION `p-2000` VALUES LESS THAN (946684800) ENGINE = MyISAM,