v4.1.4 Range按天分区 ALTER TABLE DROP PARTITIONS WHERE 无法删除匹配分区
Steps to reproduce the behavior (Required)
--创建一个有4个分区的range分区表 CREATE TABLE r1_eq (id INT, dt DATE NOT NULL) PARTITION BY RANGE(dt) ( PARTITION p20260829 VALUES [('2026-08-29'), ('2026-08-30')), PARTITION p20260830 VALUES [('2026-08-30'), ('2026-08-31')), PARTITION p20260831 VALUES [('2026-08-31'), ('2026-09-01')), PARTITION p20260910 VALUES [('2026-09-10'), ('2026-09-11')) ) DISTRIBUTED BY HASH(id) PROPERTIES ("replication_num" = "1");
--插入4条数据 INSERT INTO r1_eq VALUES (1,'2026-08-29'),(2,'2026-08-30'),(3,'2026-08-31'),(4,'2026-09-10');
--执行等值删除,where后跟具体的日期 ALTER TABLE r1_eq DROP PARTITIONS WHERE dt = "2026-09-10";
--查询数据和分区 select * from r1_eq; show partitions from r1_eq\G;
Expected behavior (Required)
匹配条件的分区 p20260910 应该被成功删除,在show partitions中不再出现。
Real behavior (Required)
ALTER 语句执行返回 OK,没有报错,但是目标分区仍然存在,没有被删除。
StarRocks version (Required)
mysql> select current_version(); +-------------------+ | current_version() | +-------------------+ | 4.1.4-4a9848e | +-------------------+ 1 row in set (0.01 sec)
Additional information
--where后不跟具体的日期,而是跟范围依然删除不掉 ALTER TABLE r1_eq DROP PARTITIONS WHERE dt >= "2026-09-10" AND dt < "2026-09-10" + INTERVAL 1
Source: StarRocks/starrocks