diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_partition_sub2.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/tc_partition_sub2.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_partition_sub2.result b/mysql-test/suite/engines/funcs/r/tc_partition_sub2.result index 543b3471092..71145725608 100644 --- a/mysql-test/suite/engines/funcs/r/tc_partition_sub2.result +++ b/mysql-test/suite/engines/funcs/r/tc_partition_sub2.result @@ -52,7 +52,7 @@ t1 CREATE TABLE `t1` ( `c1` tinyint(4) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, `purchased` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (year(`purchased`)) SUBPARTITION BY HASH (to_days(`purchased`)) (PARTITION `p0` VALUES LESS THAN (1990) @@ -120,7 +120,7 @@ t1 CREATE TABLE `t1` ( `c1` smallint(6) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, `purchased` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (year(`purchased`)) SUBPARTITION BY HASH (to_days(`purchased`)) (PARTITION `p0` VALUES LESS THAN (1990) @@ -188,7 +188,7 @@ t1 CREATE TABLE `t1` ( `c1` mediumint(9) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, `purchased` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (year(`purchased`)) SUBPARTITION BY HASH (to_days(`purchased`)) (PARTITION `p0` VALUES LESS THAN (1990) @@ -256,7 +256,7 @@ t1 CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, `purchased` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (year(`purchased`)) SUBPARTITION BY HASH (to_days(`purchased`)) (PARTITION `p0` VALUES LESS THAN (1990) @@ -324,7 +324,7 @@ t1 CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, `purchased` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (year(`purchased`)) SUBPARTITION BY HASH (to_days(`purchased`)) (PARTITION `p0` VALUES LESS THAN (1990) @@ -392,7 +392,7 @@ t1 CREATE TABLE `t1` ( `c1` bigint(20) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, `purchased` date DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY RANGE (year(`purchased`)) SUBPARTITION BY HASH (to_days(`purchased`)) (PARTITION `p0` VALUES LESS THAN (1990) |