diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_partition_sub1.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/tc_partition_sub1.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_partition_sub1.result b/mysql-test/suite/engines/funcs/r/tc_partition_sub1.result index be47aaadd40..90ff234c063 100644 --- a/mysql-test/suite/engines/funcs/r/tc_partition_sub1.result +++ b/mysql-test/suite/engines/funcs/r/tc_partition_sub1.result @@ -44,7 +44,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`)) SUBPARTITIONS 2 @@ -99,7 +99,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`)) SUBPARTITIONS 2 @@ -154,7 +154,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`)) SUBPARTITIONS 2 @@ -209,7 +209,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`)) SUBPARTITIONS 2 @@ -264,7 +264,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`)) SUBPARTITIONS 2 @@ -319,7 +319,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`)) SUBPARTITIONS 2 |