[Bug]: DLM only supports unique non-empty indexes. If it is not empty, it will prompt optimization.

[Huangxiao-mas]

ODC version

ODC430

OB version

Oceanbase430

What happened?

DLM only supports unique non-empty indexes. If it is not empty, it will prompt optimization.

What did you expect to happen?

。

How can we reproduce it (as minimally and precisely as possible)?

CREATE TABLE `bmp_select_group_result_test2` (
  `data_set` varchar(50) DEFAULT NULL COMMENT '场景code',
  `group_id` bigint(20) DEFAULT NULL COMMENT '群组ID',
  `group_instance_id` bigint(20) DEFAULT NULL COMMENT '圈选实例ID',
  `batch_no` varchar(50) DEFAULT NULL COMMENT '批次号',
  `target_id` bigint(20) DEFAULT NULL COMMENT '圈选对象id',
  `ds` bigint(20) DEFAULT NULL COMMENT '任务日期',
    UNIQUE KEY `idx_group_id` (target_id,ds),
  KEY `idx_group_instance_id` (`group_instance_id`) BLOCK_SIZE 16384 LOCAL
)
 partition by range(ds) 
 SUBPARTITION BY hash(target_id) SUBPARTITIONS 128
 (  
PARTITION p20240501 VALUES LESS THAN(100),
PARTITION p20240502 VALUES LESS THAN(200),
PARTITION p20240503 VALUES LESS THAN(300),
PARTITION p20240504 VALUES LESS THAN(500),
PARTITION p20240505 VALUES LESS THAN(600),
PARTITION p20240506 VALUES LESS THAN(1000),
PARTITION p20240507 VALUES LESS THAN(2000),
PARTITION p20240508 VALUES LESS THAN(4000),
PARTITION p20240509 VALUES LESS THAN(6000),
PARTITION p20240510 VALUES LESS THAN(10000),
PARTITION p20240511 VALUES LESS THAN(15000),
PARTITION p20240512 VALUES LESS THAN(20000),
PARTITION p20240513 VALUES LESS THAN(25000),
PARTITION p20240514 VALUES LESS THAN(30000),
PARTITION p20240515 VALUES LESS THAN(35000),
PARTITION p20240516 VALUES LESS THAN(40000),
PARTITION p20240517 VALUES LESS THAN(20240518),
PARTITION p20240518 VALUES LESS THAN(20240519),
PARTITION p20240519 VALUES LESS THAN(20240520),
PARTITION p20240520 VALUES LESS THAN(20240521),
PARTITION p20240521 VALUES LESS THAN(20240522),
PARTITION p20240522 VALUES LESS THAN(20240523),
PARTITION p20240523 VALUES LESS THAN(20240524),
PARTITION p20240524 VALUES LESS THAN(20240525),
PARTITION p20240525 VALUES LESS THAN(20240526),
PARTITION p20240526 VALUES LESS THAN(20240527),
PARTITION p20240527 VALUES LESS THAN(20240528),
PARTITION p20240528 VALUES LESS THAN(20240529),
PARTITION p20240529 VALUES LESS THAN(20240530),
PARTITION p20240530 VALUES LESS THAN(20240531),
PARTITION p20240531 VALUES LESS THAN(20240601)
) WITH COLUMN GROUP(each column);

Anything else we need to know?

No response

[Huangxiao-mas]

test pass