问题现象
OceanBase 数据库 MySQL 模式修改分区规则报错
ERROR 1655 (HY000): Too many fields in 'list of partition fields'。obclient(root@mysqlt)[testdb]> show create table test_num; +----------+---------------------------------------------------------------------------+ | Table | Create Table | +----------+---------------------------------------------------------------------------+ | test_num | CREATE TABLE `test_num` ( `a1` varchar(20) NOT NULL, `a2` int(11) NOT NULL, `a3` varchar(20) NOT NULL, `a4` varchar(1) NOT NULL, `a5` varchar(1) NOT NULL, `a6` varchar(30) NOT NULL, `a7` varchar(1) NOT NULL, `a8` varchar(1) NOT NULL, `a9` varchar(1) NOT NULL, `a10` varchar(30) NOT NULL, `a11` varchar(30) NOT NULL, `a12` varchar(30) NOT NULL, `a13` varchar(2) NOT NULL, `a14` varchar(2) NOT NULL, `a15` varchar(10) NOT NULL, `a16` varchar(3) NOT NULL, `a17` varchar(4) NOT NULL ) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 | +----------+----------------+ 1 row in set (0.004 sec) obclient(root@mysqlt)[testdb]> alter table test_num partition by key (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) partitions 32; ERROR 1655 (HY000): Too many fields in 'list of partition fields'OceanBase 数据库 Oracle 模式下修改分区规则报错
ORA-00600: internal error code, arguments: -5287, Too many fields in 'list of partition fields'。obclient(SYS@oracle)[SYS]> show create table test_num; +----------+---------------------------------------------------------------------------+ | TABLE | CREATE TABLE +----------+---------------------------------------------------------------------------+ | TEST_NUM | CREATE TABLE "TEST_NUM" ( "A1" VARCHAR2(20) NOT NULL ENABLE, "A2" NUMBER(*,0) NOT NULL ENABLE, "A3" VARCHAR2(20) NOT NULL ENABLE, "A4" VARCHAR2(1) NOT NULL ENABLE, "A5" VARCHAR2(1) NOT NULL ENABLE, "A6" VARCHAR2(30) NOT NULL ENABLE, "A7" VARCHAR2(1) NOT NULL ENABLE, "A8" VARCHAR2(1) NOT NULL ENABLE, "A9" VARCHAR2(1) NOT NULL ENABLE, "A10" VARCHAR2(30) NOT NULL ENABLE, "A11" VARCHAR2(30) NOT NULL ENABLE, "A12" VARCHAR2(30) NOT NULL ENABLE, "A13" VARCHAR2(2) NOT NULL ENABLE, "A14" VARCHAR2(2) NOT NULL ENABLE, "A15" VARCHAR2(10) NOT NULL ENABLE, "A16" VARCHAR2(3) NOT NULL ENABLE, "A17" VARCHAR2(4) NOT NULL ENABLE ) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 | +----------+---------------------------------------------------------------------------+ 1 row in set (0.037 sec) obclient(SYS@oracle)[SYS]> ALTER TABLE test_num MODIFY PARTITION BY HASH (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) PARTITIONS 32; ORA-00600: internal error code, arguments: -5287, Too many fields in 'list of partition fields'
问题原因
目前内核设定了最大分区键只有 16 个，并且没有接口可以修改这个值。以上案例中，分区中的字段列数超过 16 个，因此报错。
适用版本
OceanBase 数据库 V4.x 版本。
解决方法
修改分区规则时，控制分区中的字段列数在 16 个以内。
OceanBase 数据库 MySQL 模式修改分区规则成功。
obclient(root@mysqlt)[testdb]> alter table test_num partition by key (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) partitions 32; Query OK, 0 rows affected (1.823 sec)OceanBase 数据库 Oracle 模式修改分区规则成功。
obclient(SYS@oracle)[SYS]> ALTER TABLE test_num MODIFY PARTITION BY HASH (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) PARTITIONS 32; Query OK, 0 rows affected (2.693 sec)
