MySQL RANGE 表按月分区 2 年记录

问：

我正在探索 MySQL 表分区，我有一个有 2 年记录的表。我正在尝试创建一个类似于我拥有的当前表的新表，以便我可以将数据从表复制到这个新表，该表的记录将按 2021 年和 2022 年按月分区。我在下面有这个查询，但这遇到了一个我不太理解的错误Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

CREATE TABLE TnTest (
  id bigint NOT NULL AUTO_INCREMENT,
  tnDate date NOT NULL,
  tnDateTime datetime NOT NULL,
  tnType varchar(40) NOT NULL,
  checksum varchar(255) NOT NULL,
  PRIMARY KEY (id, tnDate),
  UNIQUE KEY checksum (checksum, tnDate),
)ENGINE=InnoDB AUTO_INCREMENT=50015 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
  PARTITION BY RANGE (extract(year_month from 'tnDate'))
(
  PARTITION P0 VALUES LESS THAN (202101),
  PARTITION P1 VALUES LESS THAN (202102),
  PARTITION P2 VALUES LESS THAN (202103),
  PARTITION P3 VALUES LESS THAN (202104),
  PARTITION P4 VALUES LESS THAN (202105),
  PARTITION P5 VALUES LESS THAN (202106),
  PARTITION P6 VALUES LESS THAN (202107),
  PARTITION P7 VALUES LESS THAN (202108),
  PARTITION P8 VALUES LESS THAN (202109),
  PARTITION P9 VALUES LESS THAN (202110),
  PARTITION P10 VALUES LESS THAN (202111),
  PARTITION P11 VALUES LESS THAN (202112),
  PARTITION P12 VALUES LESS THAN (202201),
  PARTITION P13 VALUES LESS THAN (202202),
  PARTITION P14 VALUES LESS THAN (202203),
  PARTITION P15 VALUES LESS THAN (202204),
  PARTITION P16 VALUES LESS THAN (202205),
  PARTITION P17 VALUES LESS THAN (202206),
  PARTITION P18 VALUES LESS THAN (202207),
  PARTITION P19 VALUES LESS THAN (202208),
  PARTITION P20 VALUES LESS THAN (202209),
  PARTITION P21 VALUES LESS THAN (202210),
  PARTITION P22 VALUES LESS THAN (202211),
  PARTITION P23 VALUES LESS THAN (202212),
  PARTITION P24 VALUES LESS THAN MAXVALUE
);

从查询中，我尝试创建一个总共有 24 个分区的表（由 2021 年和 2022 年的月份组成），以便当我将记录复制到该表时，它将根据相应年份的月份进行分区。