错误码：-2730
错误内容：范围分区值非递增
错误级别: ERROR
原因：分区中存在了新添加的分区的范围

drop TABLE T_RANGE;

CREATE TABLE t_range(
	id INT,
	sal int
)
PARTITION BY RANGE(sal)(
	PARTITION p1 VALUES LESS THAN(100),
	PARTITION p2 VALUES LESS THAN(200),
	PARTITION p3 VALUES LESS THAN(MAXVALUE)
);

INSERT INTO T_RANGE VALUES(1,10);
INSERT INTO T_RANGE VALUES(1,100);
INSERT INTO T_RANGE VALUES(1,101);
INSERT INTO T_RANGE VALUES(1,201);
INSERT INTO T_RANGE VALUES(1,301);
INSERT INTO T_RANGE VALUES(1,401);
INSERT INTO T_RANGE VALUES(1,501);
INSERT INTO T_RANGE VALUES(1,601);
COMMIT;

ALTER TABLE T_RANGE ADD PARTITION p4 VALUES LESS THAN(300);
[执行语句1]:
ALTER TABLE T_RANGE ADD PARTITION p4 VALUES LESS THAN(300);
执行失败(语句1)
-2730: 第1 行附近出现错误:
范围分区值非递增

解决方法
1、拆分分区表

ALTER TABLE T_RANGE SPLIT PARTITION p3 AT (300) INTO (PARTITION p3, PARTITION p4);