【 使用环境 】测试环境
【 OB or 其他组件 】
OceanBase4.2.1
【问题描述】清晰明确描述问题
触发器创建失败
DELIMITER ;
CREATE DEFINER = kaifassr TRIGGER after_insert_asset AFTER INSERT ON new_hhit_asset FOR EACH ROW
BEGIN
INSERT INTO hhit_asset.hhit_asset_change_record ( ts, change_type, source_type, ip, ip_long, ipv6, ipv6_var )
VALUES
( NEW.ts, 0, NEW.last_source_type, NEW.ip, NEW.ip_long, NEW.ipv6, NEW.ipv6_var );
END;
DELIMITER ;
DELIMITER ;
CREATE DEFINER = kaifassr TRIGGER after_update_asset AFTER UPDATE ON new_hhit_asset FOR EACH ROW
BEGIN
INSERT INTO hhit_asset.hhit_asset_change_record ( ts, change_type, source_type, ip, ip_long, ipv6, ipv6_var )
VALUES
( NEW.ts, 1, NEW.last_source_type, NEW.ip, NEW.ip_long, NEW.ipv6, NEW.ipv6_var );
END;
DELIMITER ;
【附件及日志】
