The tree does not show the events, but if you perform the sql query, the events are in the database
The tree does not show the events
Yes, that's the problem. HeidiSQL compares the "Db" value with the current database, which do not match on your side: sai_aga != SAI_AGA.
First thought I just had was: why even compare the Db ? I found I added this Db comparison in commit:49dce8e08b7550cb8b1dbbc6d57f649e77f032c9 to work around MySQL bug 41907. The problem was that MySQL returned events from other schemas. And it was fixed in MySQL 5.1.57, 5.5.12, 5.6.3 and newer.
Now your server is not even affected by the MySQL bug (MySQL 5.5.30 is old, but should have the fix). So I can modify the code in HeidiSQL so it only compares the schema name if the version is older than these. Further on, I will make the comparison case insensitive for older servers.
Fix retrieving MySQL events from the current database on older servers which return a lower case schema name, by turning the comparison case insensitive. Further more, don't compare the schema at all on newer servers with a fix for MySQL bug 41907. See https://bugs.mysql.com/bug.php?id=41907#c360194 and https://www.heidisql.com/forum.php?t=41682
Please login to leave a reply, or register at first.