【 TiDB 使用环境】生产环境
【 TiDB 版本】
建表SQL
CREATE TABLE day_report_status (
report_id INT NOT NULL,
report_status VARCHAR(20) NOT NULL,
report_date DATE NOT NULL
)
PARTITION BY RANGE COLUMNS (report_date)
INTERVAL (1 DAY) FIRST PARTITION LESS THAN ('2024-01-01') LAST PARTITION LESS THAN ('2025-01-01')
报错如下: