diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_partition_hash_date_function.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/tc_partition_hash_date_function.result | 96 |
1 files changed, 48 insertions, 48 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_partition_hash_date_function.result b/mysql-test/suite/engines/funcs/r/tc_partition_hash_date_function.result index 96725b7328a..c713b93f193 100644 --- a/mysql-test/suite/engines/funcs/r/tc_partition_hash_date_function.result +++ b/mysql-test/suite/engines/funcs/r/tc_partition_hash_date_function.result @@ -9,7 +9,7 @@ t2 CREATE TABLE `t2` ( `c1` tinyint(4) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -24,7 +24,7 @@ t2 CREATE TABLE `t2` ( `c1` smallint(6) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -39,7 +39,7 @@ t2 CREATE TABLE `t2` ( `c1` mediumint(9) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -54,7 +54,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -69,7 +69,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -84,7 +84,7 @@ t2 CREATE TABLE `t2` ( `c1` bigint(20) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -99,7 +99,7 @@ t2 CREATE TABLE `t2` ( `c1` tinyint(4) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -114,7 +114,7 @@ t2 CREATE TABLE `t2` ( `c1` smallint(6) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -129,7 +129,7 @@ t2 CREATE TABLE `t2` ( `c1` mediumint(9) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -144,7 +144,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -159,7 +159,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -174,7 +174,7 @@ t2 CREATE TABLE `t2` ( `c1` bigint(20) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (year(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -189,7 +189,7 @@ t2 CREATE TABLE `t2` ( `c1` tinyint(4) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -204,7 +204,7 @@ t2 CREATE TABLE `t2` ( `c1` smallint(6) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -219,7 +219,7 @@ t2 CREATE TABLE `t2` ( `c1` mediumint(9) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -234,7 +234,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -249,7 +249,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -264,7 +264,7 @@ t2 CREATE TABLE `t2` ( `c1` bigint(20) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -279,7 +279,7 @@ t2 CREATE TABLE `t2` ( `c1` tinyint(4) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -294,7 +294,7 @@ t2 CREATE TABLE `t2` ( `c1` smallint(6) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -309,7 +309,7 @@ t2 CREATE TABLE `t2` ( `c1` mediumint(9) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -324,7 +324,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -339,7 +339,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -354,7 +354,7 @@ t2 CREATE TABLE `t2` ( `c1` bigint(20) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (month(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -369,7 +369,7 @@ t2 CREATE TABLE `t2` ( `c1` tinyint(4) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -384,7 +384,7 @@ t2 CREATE TABLE `t2` ( `c1` smallint(6) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -399,7 +399,7 @@ t2 CREATE TABLE `t2` ( `c1` mediumint(9) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -414,7 +414,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -429,7 +429,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -444,7 +444,7 @@ t2 CREATE TABLE `t2` ( `c1` bigint(20) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -459,7 +459,7 @@ t2 CREATE TABLE `t2` ( `c1` tinyint(4) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -474,7 +474,7 @@ t2 CREATE TABLE `t2` ( `c1` smallint(6) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -489,7 +489,7 @@ t2 CREATE TABLE `t2` ( `c1` mediumint(9) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -504,7 +504,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -519,7 +519,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -534,7 +534,7 @@ t2 CREATE TABLE `t2` ( `c1` bigint(20) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofmonth(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -549,7 +549,7 @@ t2 CREATE TABLE `t2` ( `c1` tinyint(4) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -564,7 +564,7 @@ t2 CREATE TABLE `t2` ( `c1` smallint(6) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -579,7 +579,7 @@ t2 CREATE TABLE `t2` ( `c1` mediumint(9) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -594,7 +594,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -609,7 +609,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -624,7 +624,7 @@ t2 CREATE TABLE `t2` ( `c1` bigint(20) DEFAULT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -639,7 +639,7 @@ t2 CREATE TABLE `t2` ( `c1` tinyint(4) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -654,7 +654,7 @@ t2 CREATE TABLE `t2` ( `c1` smallint(6) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -669,7 +669,7 @@ t2 CREATE TABLE `t2` ( `c1` mediumint(9) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -684,7 +684,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -699,7 +699,7 @@ t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; @@ -714,7 +714,7 @@ t2 CREATE TABLE `t2` ( `c1` bigint(20) NOT NULL, `c2` char(5) DEFAULT NULL, `c3` datetime DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 +) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (dayofweek(`c3`)) DROP TABLE t2; SHOW TABLES; |