Since a few updates to HeidiSQL (currently using version 12.21), some of my triggers are no longer displayed; more precisely, they have an empty body.
Log msg: /* Result from previous query does not contain expected pattern: (\sDEFINER=(["]?[^"]+[`"]..........
The beginning of the CREATE TRIGGER statement:
[Trigger is displayed]
CREATE DEFINER=user123@% TRIGGER tr_opt_b_update BEFORE UPDATE ON opt FOR EACH ROW BEGIN .....
(one line no line breaks)
[Trigger is not displayed]
CREATE DEFINER=user123@% TRIGGER db1.tr_audit_opt_update
AFTER UPDATE ON db1.opt
FOR EACH ROW
BEGIN
.....
(line breaks before AFTER, FOR, BEGIN)
Is this a bug? Does this have anything to do with line breaks?