Menu

#3707 mySQL procedure/function paremeters formatting

New
nobody
Medium
Cosmetical?
Enhancement
2017-09-12
2017-05-09
bbabic
No

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

Discussion