With time, HeidiSQL will add extra empty lines in CREATE code for stored procedures/functions. That does not affect functionality, but produces a problem when trying to synchronize two databases since the create code output differs even though actual procedure/function body is exactly the same.
How to reproduce the problem?
1. create profedure or function
2. add parameter(s)
3. save/close/exit
4. add/remove procedure/function parameters
5. save/close/exit
6. check "CREATE code tab" for extra newlines in parameters section
What was the expected output?
CREATE code should show one parameter per line, without extra empty lines
What happened instead?
There are random empty lines inserted in CREATE code parameters section
Suggested fix (optional)?
Always re-create and format parameters section based on parameter list on save.
I am not sure when exactly this "bug" appeared, but I am pretty sure it existed in v9.3