表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