diff options
Diffstat (limited to 'mysql-test/t/partition_datatype.test')
| -rw-r--r-- | mysql-test/t/partition_datatype.test | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/t/partition_datatype.test b/mysql-test/t/partition_datatype.test index 967e1cddb4e..a6035fcb592 100644 --- a/mysql-test/t/partition_datatype.test +++ b/mysql-test/t/partition_datatype.test @@ -248,13 +248,13 @@ ENGINE = MyISAM; CREATE TABLE t2 LIKE t1; ALTER TABLE t2 PARTITION BY RANGE (UNIX_TIMESTAMP(a)) (PARTITION `p0` VALUES LESS THAN (0), - PARTITION `p-2000` VALUES LESS THAN (UNIX_TIMESTAMP('2000-01-01')), - PARTITION `p-2011-MSK` VALUES LESS THAN (UNIX_TIMESTAMP('2011-03-26 23:00:00')), - PARTITION `p-2011-MSD-1` VALUES LESS THAN (UNIX_TIMESTAMP('2011-10-29 22:00:00')), - PARTITION `p-2011-MSD-2` VALUES LESS THAN (UNIX_TIMESTAMP('2011-10-29 23:00:00')), - PARTITION `p-2012-MSK-1` VALUES LESS THAN (UNIX_TIMESTAMP('2011-10-30 00:00:00')), - PARTITION `p-2012-MSK-2` VALUES LESS THAN (UNIX_TIMESTAMP('2012-03-24 23:00:00')), - PARTITION `pEnd` VALUES LESS THAN (UNIX_TIMESTAMP('2038-01-19 03:14:07')), + PARTITION `p-2000` VALUES LESS THAN (UNIX_TIMESTAMP(20000101)), + PARTITION `p-2011-MSK` VALUES LESS THAN (UNIX_TIMESTAMP(20110326230000)), + PARTITION `p-2011-MSD-1` VALUES LESS THAN (UNIX_TIMESTAMP(20111029220000)), + PARTITION `p-2011-MSD-2` VALUES LESS THAN (UNIX_TIMESTAMP(20111029230000)), + PARTITION `p-2012-MSK-1` VALUES LESS THAN (UNIX_TIMESTAMP(20111030000000)), + PARTITION `p-2012-MSK-2` VALUES LESS THAN (UNIX_TIMESTAMP(20120324230000)), + PARTITION `pEnd` VALUES LESS THAN (UNIX_TIMESTAMP(20380119031407)), PARTITION `pMax` VALUES LESS THAN MAXVALUE); |