MySQL -> Doris 实现增量通道分区表增量通道出错

[baisui1981]

CREATE TABLE `points_xxxxx` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT ,
  `sys_id` varchar(10) COLLATE utf8_bin NOT NULL ,
  `member_id` bigint(20) NOT NULL ,
  `refer_no` varchar(40) COLLATE utf8_bin NOT NULL ,
  `merchant_code` varchar(15) COLLATE utf8_bin NOT NULL,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,
  `order_no` varchar(40) COLLATE utf8_bin DEFAULT NULL,
  `sub_order_no` varchar(40) COLLATE utf8_bin DEFAULT NULL,
  `out_refer_no` varchar(50) COLLATE utf8_bin NOT NULL ,
  `points_type` varchar(10) COLLATE utf8_bin NOT NULL ,
  `points_rule` varchar(20) COLLATE utf8_bin DEFAULT NULL ,
  `terminal_id` varchar(20) COLLATE utf8_bin DEFAULT NULL ,
  `channel_id` varchar(10) COLLATE utf8_bin NOT NULL,
  `store_code` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `pay_currency` varchar(5) COLLATE utf8_bin DEFAULT NULL ,
  `pay_amount` double(20,4) DEFAULT NULL ,
  `direction_opt` varchar(1) COLLATE utf8_bin NOT NULL,
  `points` bigint(20) NOT NULL,
  `actual_points` bigint(20) NOT NULL DEFAULT '0' ,
  `value_date` date DEFAULT NULL ,
  `maturity_date` date DEFAULT NULL ,
  `transaction_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `send_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,
  `remark` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `transaction_type` varchar(10) COLLATE utf8_bin NOT NULL ,
  `sub_transaction_type` varchar(30) COLLATE utf8_bin DEFAULT NULL ,
  `transaction_des` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `status` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '0' ,
  `is_freezed` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '0' ,
  `clean_date` date DEFAULT NULL,
  `batch_no` varchar(50) COLLATE utf8_bin DEFAULT NULL ,
  `voucher_codes` varchar(100) COLLATE utf8_bin DEFAULT NULL ,
  `ex_rate` double DEFAULT NULL ,
  `error_code` varchar(10) COLLATE utf8_bin DEFAULT NULL ,
  `error_msg` varchar(200) COLLATE utf8_bin DEFAULT NULL ,
  `adj_identify` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '1' ,
  `orgi_order_no` varchar(40) COLLATE utf8_bin DEFAULT NULL,
  `orgi_sub_order_no` varchar(40) COLLATE utf8_bin DEFAULT NULL,
  `orgi_out_refer_no` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `orgi_freezed_refer_no` varchar(40) COLLATE utf8_bin DEFAULT NULL ,
  `operator` varchar(32) COLLATE utf8_bin DEFAULT NULL ,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,
  `is_deleted` int(11) NOT NULL DEFAULT '0' ,
  `version` bigint(20) NOT NULL DEFAULT '0' ,
  `tx_ref1` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `tx_ref2` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `attr1` varchar(30) COLLATE utf8_bin DEFAULT NULL ,
  `attr2` varchar(30) COLLATE utf8_bin DEFAULT NULL ,
  `attr3` varchar(30) COLLATE utf8_bin DEFAULT NULL ,
  `available_points` bigint(20) DEFAULT NULL ,
  `open_id` varchar(100) COLLATE utf8_bin DEFAULT NULL ,
  PRIMARY KEY (`id`,`update_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6852440703340979329 DEFAULT CHARSET=utf8 COLLATE=utf8_bin  ;

设置增量轮训策略报错：

初步怀疑是因为因为表中的联合索引引起的：

 PRIMARY KEY (`id`,`update_time`) USING BTREE,

[baisui1981]

modfiied file:
qlangtech/plugins@c40c554#diff-7a5353c1336566af3d379f12162999923277596d2838b58978703a477596e149R221

[baisui1981]

modified file:
bad7020#diff-86eedeb431da7b75e893bf5157b3a9b11b0c875b0b5b317dacd1afd718cb78bfR330

[baisui1981]

fixed