diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-28 19:20:32 +0100 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-28 19:20:32 +0100 |
| commit | 470a44c70dedf9e58f914b51485280642f69a43f (patch) | |
| tree | 8b5a0aa5dc69ed5d03a130028ae1f0695913991a /mysql-test/r/partition_column.result | |
| parent | c94237e530cd082321474fae0f51e85b71d7dc87 (diff) | |
| download | mariadb-git-470a44c70dedf9e58f914b51485280642f69a43f.tar.gz | |
Fixed code review change to ensure that VALUES constants are of the same result type as the field they are constants for
Diffstat (limited to 'mysql-test/r/partition_column.result')
| -rw-r--r-- | mysql-test/r/partition_column.result | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index 0dc81240782..784d4d08a25 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -43,21 +43,21 @@ create table t1 (a int, b char(10), c varchar(25), d datetime) partition by range column_list(a,b,c,d) subpartition by hash (to_seconds(d)) subpartitions 4 -( partition p0 values less than (1, 0, MAXVALUE, 0), -partition p1 values less than (1, 'a', MAXVALUE, TO_DAYS('1999-01-01')), +( partition p0 values less than (1, 0, MAXVALUE, '1900-01-01'), +partition p1 values less than (1, 'a', MAXVALUE, '1999-01-01'), partition p2 values less than (1, 'a', MAXVALUE, MAXVALUE), partition p3 values less than (1, MAXVALUE, MAXVALUE, MAXVALUE)); select partition_method, partition_expression, partition_description from information_schema.partitions where table_name = "t1"; partition_method partition_expression partition_description -RANGE COLUMN_LIST a,b,c,d 1,'0',MAXVALUE,0 -RANGE COLUMN_LIST a,b,c,d 1,'0',MAXVALUE,0 -RANGE COLUMN_LIST a,b,c,d 1,'0',MAXVALUE,0 -RANGE COLUMN_LIST a,b,c,d 1,'0',MAXVALUE,0 -RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,730120 -RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,730120 -RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,730120 -RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,730120 +RANGE COLUMN_LIST a,b,c,d 1,'0',MAXVALUE,'1900-01-01' +RANGE COLUMN_LIST a,b,c,d 1,'0',MAXVALUE,'1900-01-01' +RANGE COLUMN_LIST a,b,c,d 1,'0',MAXVALUE,'1900-01-01' +RANGE COLUMN_LIST a,b,c,d 1,'0',MAXVALUE,'1900-01-01' +RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,'1999-01-01' +RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,'1999-01-01' +RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,'1999-01-01' +RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,'1999-01-01' RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,MAXVALUE RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,MAXVALUE RANGE COLUMN_LIST a,b,c,d 1,'a',MAXVALUE,MAXVALUE @@ -77,8 +77,8 @@ t1 CREATE TABLE `t1` ( /*!50100 PARTITION BY RANGE COLUMN_LIST(a,b,c,d) SUBPARTITION BY HASH (to_seconds(d)) SUBPARTITIONS 4 -(PARTITION p0 VALUES LESS THAN (1,_latin1'0',MAXVALUE,0) ENGINE = MyISAM, - PARTITION p1 VALUES LESS THAN (1,_latin1'a',MAXVALUE,730120) ENGINE = MyISAM, +(PARTITION p0 VALUES LESS THAN (1,_latin1'0',MAXVALUE,'1900-01-01') ENGINE = MyISAM, + PARTITION p1 VALUES LESS THAN (1,_latin1'a',MAXVALUE,'1999-01-01') ENGINE = MyISAM, PARTITION p2 VALUES LESS THAN (1,_latin1'a',MAXVALUE,MAXVALUE) ENGINE = MyISAM, PARTITION p3 VALUES LESS THAN (1,MAXVALUE,MAXVALUE,MAXVALUE) ENGINE = MyISAM) */ drop table t1; |