Hello,
I believe I have encountered a bug in SQLyog.
SQLyog Community Edition v8.14
MySQL Server version 5.1.37-community
running on localhost, connected as root
Windows XP Pro SP3 +
I am developing a scheduled event which deletes old data from my tables periodically. As my CREATE EVENT statement will use a block (BEGIN..END), I need to start the query with a delimiter change (“DELIMITER $$”). I have found that I will get an error somewhere later in the query if there are one or more spaces on preceding the DELIMITER command (” DELIMITER $$”). Simply removing this leading white space allows the query to run to completion.
I performed the exact same test with and without a space before DELIMITER using Navicat 8 and there is no problem.
This took a long time to pin down since it is not intuitive that unquoted spaces would break a query. I initially thought there was a bug in my query or in the MySQL Server code. Since Navicat can handle the space I think this is most likely to be a SQLyog bug.
The full text of my query is available on request but it's long and I don't think it's needed here. Correct me if I am wrong.
Thank you for developing a great product!
Peter Laskey
[attachment=1239:screenshot.2.jpg]
