I've been evaluating HeidiSQL as a possible replacement for our current MySQL GUI, and hit a major problem: When there are comments embedded in the parameter list, regardless of which comment syntax is used, Heidi misparses it badly. It looks like there's also an issue with ENUM types, due to the embedded commas. The proc is created correctly on the first run, but the parameter and create tabs are incorrect, as you can see from the attached -- a snip of the relevant part of the original .sql file, the results in Heidi's CREATE Code tab, and the results in the Parameters tab. Not shown, because only three attachments, but the results of running "SHOW CREATE" are correct; it's only the Heidi UI misparsing -- but that includes the parameter prompts when you use "Run routine(s)".
MySQL Stored Proc comment parsing
Sorry for the long delay.
The problem was also reported in issue #1477, and it's fixed now. The next nightly builds strips comments from parameters away before parsing them.
Please login to leave a reply, or register at first.