表DDL:
CREATE TABLE temp
(
channel_billing_id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
reconciliation_date
date NOT NULL COMMENT ‘日期’,
PRIMARY KEY (channel_billing_id
),
UNIQUE KEY tp_check_channel_billing_data_channel_billing_id_uindex
(channel_billing_id
) BLOCK_SIZE 16384 LOCAL,
KEY unique_index1
(mer_id
, reconciliation_date
) BLOCK_SIZE 16384 LOCAL
) AUTO_INCREMENT = 1002401 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 COMMENT = ‘数据’;
同一请求中,先用mybatis-plus批量保存该表数据,后用mybatis-plus批量更新(updateBatchById)该表,报错: SQL state [0A000]; error code [1235]; Not supported feature or function