add partition 失败

🪐 TiDB 技术问题 部署&运维管理
1 
MySQL [test]> select @@version;

+--------------------+

| @@version |

+--------------------+

| 5.7.25-TiDB-v4.0.3 |

+--------------------+

**1 row in set (0.00 sec)**

MySQL [test]> ALTER TABLE data_pre.processed_hot_impression_sdk ADD PARTITION (PARTITION p2020072810 VALUES LESS THAN (UNIX_TIMESTAMP('2020-07-28 11:00:00')));
ERROR 1105 (HY000): strconv.Atoi: parsing "unix_timestamp(\"2020-07-24 23:59:59\")": invalid syntax

MySQL [test]>

以上，之前4.0版本是可以生效的，4.0.3会报错
我加p2020072810，和2020-07-24 23:59:59又啥关系？

2

麻烦上传下建表语句，多谢。

3

已解决

CREATE TABLE data_pre.processed_hot_impression_sdk (
    gid BIGINT NOT NULL,
    feed_id BIGINT NOT NULL,
    create_time TIMESTAMP NOT NULL,
    uid BIGINT NOT NULL,
    scm varchar(200),
    session_id char(32),
    feed_type TINYINT,
    feed_cnt INT,
    feed_view_cnt INT
) PARTITION BY RANGE (UNIX_TIMESTAMP(create_time)) (
    PARTITION p20200724 VALUES LESS THAN (UNIX_TIMESTAMP('2020-07-24 23:59:59'))
);

MySQL [test]> ALTER TABLE data_pre.processed_hot_impression_sdk DROP PARTITION p20200724;
ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead

后来之后重建表了

4

感谢反馈，我尝试使用您的语句也没有复现问题:sweat: