1、报错：SQL 错误 [1064] [42000]: expr’s type is not same with slot’s backend:172.10.40.4
2、过程：
CREATE TABLE flow_tasknode (
F_Id varchar(50) NOT NULL COMMENT “自然主键”,
F_NodeCode varchar(50) NULL COMMENT “节点编号”,
F_NodeName varchar(50) NULL COMMENT “节点名称”,
F_NodeType varchar(50) NULL COMMENT “节点类型”,
F_NodePropertyJson json NULL COMMENT “节点属性Json”,
F_NodeUp varchar(50) NULL COMMENT “上一节点”,
F_NodeNext varchar(50) NULL COMMENT “下一节点”,
F_Completion int(11) NULL COMMENT “是否完成”,
F_Description varchar(1048575) NULL COMMENT “描述”,
F_SortCode bigint(20) NULL COMMENT “排序码”,
F_CreatorTime datetime NULL COMMENT “创建时间”,
F_TaskId varchar(50) NULL COMMENT “任务主键”,
F_State varchar(50) NULL COMMENT “状态”,
F_Candidates json NULL COMMENT “候选人”,
starrocks_last_modify_date varchar(50) NULL COMMENT “操作时间”,
starrocks_last_modify_type varchar(50) NULL COMMENT “操作类型, insert, delete, update”
) ENGINE=OLAP
PRIMARY KEY(F_Id)
COMMENT “流程节点”
DISTRIBUTED BY HASH(F_Id) BUCKETS 8
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);
UPDATE flow_tasknode
SET F_NodeCode=‘segSgI1’, F_NodeName=‘开始’, F_NodeType=‘start’,
F_NodeUp=‘NULL’,
F_NodeNext=‘6S0TgI1’,
F_Completion=1,
F_Description=‘NULL’,
F_SortCode=1,
F_CreatorTime=‘2023-03-10 10:17:38’,
F_TaskId=‘394355734159429’,
F_State=‘0’,
F_Candidates=’“NULL”’,
starrocks_last_modify_date=‘2023-05-31 17:47:41’,
starrocks_last_modify_type=‘insert’
where F_Id=‘394355735281733’;
1ddad5b9382073c8060eb74db03c644|690x388
更新int(11) 为bigint(20)后执行成功。