数据库报错没有分区Table has no partition for value，创建表分区失败

Table has no partition for value 20231005
创建分区失败
查看分区
select * from INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = ’ ’ ORDER BY partition_ordinal_position asc ;
查看创建表语句
PARTITION BY RANGE (order_date)
(PARTITION ** VALUES LESS THAN (20231001) ENGINE = InnoDB) */;

没有定义20231001以后的日期分区

改成
PARTITION BY RANGE (order_date)
(PARTITION ** VALUES LESS THAN (20241001) ENGINE = InnoDB)