empty body for triggers in HeidiSQL

danieljena's profile image danieljena posted 1 month ago in General Permalink

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?

ansgar's profile image ansgar posted 1 month ago Permalink

I guess this is due to the expected quoting of identifiers, for example the name of the trigger. I recall I fixed a bug with that recently. You should post that to the bugtracker.

danieljena's profile image danieljena posted 1 month ago Permalink

OK, issue is written :)

Please login to leave a reply, or register at first.