mg-ica
mg-ica
The following code causes this behavior every time. Without the intermediate COMMITs it's working ``` SET TERM ^ ; CREATE PROCEDURE SP_TEST RETURNS (X VARCHAR(8)) AS BEGIN X = '1';...
Even though this is just a warning, it's very annoying. Especially when it pops up multiple times while deploying a longer script. For example, when an update script is distributed...
The warning is very helpful when the input/output parameters of a procedure change (unintentionally), but if only the body changes, the warning remains annoying and pointless in my opinion. The...
Neither the first nor the second version of SP_TEST has an input parameter. Both versions only return a VARCHAR(8). The only difference is that the return value in the body...
SP_TEST returns X not Y. Flamerobin could check the parameters of the procedure before and after the change and only if these change should the warning be issued.
@baldeuniversel This is the example code which should not raise a warning: https://github.com/mariuz/flamerobin/issues/409#issuecomment-2673776506 There might be views which depend on views ... which need to be dropped to prevent this...