Hello,
the HeidiSQL 8.3.0.4840 try to send
--- snip ---
SHOW TRIGGERS FROM `<database>`;
SHOW CREATE TRIGGER `<database>`.`<trigger>`;
--- snip ---
for geting a trigger code.
At mySQL version 5.0.51 the SHOW CREATE TRIGGER command isn't supported. So a mysql error 1064 is generated. All works, but the message:
--- snip ---
/* SQL Fehler (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER `<datebase>`.`<trigger>`' at line 1 */
--- snip ---
is displayed in the command window. This error is repeated every trigger i try to view. If you know, this mysql server version didn't understand this command, you can skip it in the next time!
Martin
SHOW CREATE TRIGGER shows mysql error 1064 on mySQL 5.0.51
That's a newly introduced bug. See this thread for the reason.
http://dev.mysql.com/doc/refman/5.1/en/show-create-trigger.html :
I will add a version conditional here.
http://dev.mysql.com/doc/refman/5.1/en/show-create-trigger.html :
SHOW CREATE TRIGGER was added in MySQL 5.1.21.
I will add a version conditional here.
Code modification/commit
from ansgar.becker,
9 years ago,
revision 4842
Keep compatibility with older MySQL servers when getting a trigger's CREATE CODE. See here: http://www.heidisql.com/forum.php?t=16662
Hello,
This bug still exists (9.4.0.5169)
I have MySQL v5.7 installed locally, and routinely connect to an old system with v5.0 installed. Every query autocomplete tentative results in a unhandeled exception being thrown due to the SHOW CREATE TRIGGER
command.
Regards,
nostra
Please login to leave a reply, or register at first.