语句一：
UPDATE tidb_sync_combine.tb_base_masterdata_resource
SET comm_id = ‘cca0df67-555b-4972-8296-bc4d789ef7fc’,
get_house_end_date = ‘2021-11-30T00:00’,
create_date = ‘2024-06-28T16:58:04’,
owner_name = ‘关兵’,
resource_class = 1,
resource_code = ‘POLYWY-JL-CC-30-C2-04-04-07’,
resource_type = 3,
sort = 0,
parent_id = ‘e6277cdc-34f6-11ef-8f08-525400fdc804’,
is_split_merge = 0,
owner_mobile = ‘13590001754’,
floor_name = ‘04’,
build_area = 89.12,
resource_group = ‘e6277cdc-34f6-11ef-8f08-525400fdc804’,
resource_attr = 1,
actual_sub_date = ‘2021-11-30T00:00’,
common_area = 21.85,
time_stamp = ‘2024-08-18T12:48:17’,
owner_idcard_num = ‘220282198112034129’,
is_delete = 0,
get_house_start_date = ‘2021-11-30T00:00’,
calc_area = 89.12,
interior_area = 67.27,
resource_name = ‘一期-C2-高层住宅-4-407’,
modify_date = ‘2024-08-18T12:48:17’
WHERE
id = ‘4c527ebb-34f8-11ef-8f08-525400fdc804’
语句二：
UPDATE tidb_sync_combine.tb_base_masterdata_resource
SET comm_id = ‘cca0df67-555b-4972-8296-bc4d789ef7fc’,
get_house_end_date = ‘2021-11-30T00:00’,
create_date = ‘2024-06-28T16:58:04’,
owner_name = ‘关兵’,
resource_class = 1,
resource_code = ‘POLYWY-JL-CC-30-C2-04-04-07’,
resource_type = 3,
sort = 0,
parent_id = ‘e6277cdc-34f6-11ef-8f08-525400fdc804’,
is_split_merge = CAST(0 AS BIGINT),
owner_mobile = ‘13590001754’,
floor_name = ‘04’,
build_area = 89.12,
resource_group = ‘e6277cdc-34f6-11ef-8f08-525400fdc804’,
resource_attr = 1,
actual_sub_date = ‘2021-11-30T00:00’,
common_area = 21.85,
time_stamp = ‘2024-08-18T12:48:17’,
owner_idcard_num = ‘220282198112034129’,
is_delete = 0,
get_house_start_date = ‘2021-11-30T00:00’,
calc_area = 89.12,
interior_area = 67.27,
resource_name = ‘一期-C2-高层住宅-4-407’,
modify_date = ‘2024-08-18T12:48:17’
WHERE
id = ‘4c527ebb-34f8-11ef-8f08-525400fdc804’
在starrocks里，语句二不会报错，而语句一要报INT无法转换为BIGINT的错误，is_split_merge为BIGINT类型，我实在无法理解。但如果我单独
UPDATE tidb_sync_combine.tb_base_masterdata_resource
SET
is_split_merge = 0,
WHERE
id = ‘4c527ebb-34f8-11ef-8f08-525400fdc804’
这样执行时，却又不会报错，这个是有什么机制吗？谢谢各位的回答。