mysql> CREATE TABLE `t1` (
-> `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '',
-> `u` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
-> `p` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
-> `k` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
-> `c` date NOT NULL DEFAULT '0001-01-01' COMMENT '',
-> PRIMARY KEY (`id`,`c`) /*T![clustered_index] CLUSTERED */,
-> KEY `idx_userid` (`u`,`c`),
-> KEY `idx_user_keyword` (`c`,`u`,`k`),
-> KEY `idx_user_plan` (`c`,`u`,`p`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=113838548138 COMMENT=''
-> PARTITION BY RANGE COLUMNS(`c`)
-> (PARTITION `p20250409` VALUES LESS THAN ('20250410'),
-> PARTITION `p20250410` VALUES LESS THAN ('20250411'),
-> PARTITION `p20250411` VALUES LESS THAN ('20250412'),
-> PARTITION `p20250412` VALUES LESS THAN ('20250413'),
-> PARTITION `p20250413` VALUES LESS THAN ('20250414'),
-> PARTITION `p20250414` VALUES LESS THAN ('20250415'),
-> PARTITION `p20250415` VALUES LESS THAN ('20250416'),
-> PARTITION `p20250416` VALUES LESS THAN ('20250417'),
-> PARTITION `p20250417` VALUES LESS THAN ('20250418'),
-> PARTITION `p20250418` VALUES LESS THAN ('20250419'),
-> PARTITION `p20250419` VALUES LESS THAN ('20250420'),
-> PARTITION `p20250420` VALUES LESS THAN ('20250421'),
-> PARTITION `p20250421` VALUES LESS THAN ('20250422'),
-> PARTITION `p20250422` VALUES LESS THAN ('20250423'),
-> PARTITION `p20250423` VALUES LESS THAN ('20250424'),
-> PARTITION `p20250424` VALUES LESS THAN ('20250425'),
-> PARTITION `p20250425` VALUES LESS THAN ('20250426'),
-> PARTITION `p20250426` VALUES LESS THAN ('20250427'),
-> PARTITION `p20250427` VALUES LESS THAN ('20250428'),
-> PARTITION `p20250428` VALUES LESS THAN ('20250429'),
-> PARTITION `p20250429` VALUES LESS THAN ('20250430'));
Query OK, 0 rows affected (0.16 sec)
mysql> SPLIT TABLE t1 BETWEEN (2) AND (9223372036854775807) REGIONS 64;
ERROR 1105 (HY000): Split table region lower value count should be 2