Object Schema comparison

[Robin Lowther]

It would be nice to have the option to ignore LF and CRLF differences in stored procedures, functions etc in the same way as whitespace can be ignored.

When comparing stored procedures in DB2, procschema and procname cannot be used to uniquely identify a procedure.  The comparison needs to be based on procschema, procname and parm_signature.  The same applied to functions as well.

[DB Solo Admin]

If you 'ignore whitespace' it will cover the newlines as well, no?

Marko

[Robin Lowther]

Yes, I think that might be correct from the "Compare Schema - Results" when the objects are identical (green).  However, if there is a minor difference (or in fact no difference), then the comparison (?=?) shows LF/CRLF differences and possibly also whitespace differences.  So, where there are LF/CRLF differences, then every line is being displayed as a mismatch.

Regards,

Robin.

[DB Solo Admin]

That's correct. At the moment the ?=? window shows the source code unmodified (whether whitespace was ignored during comparison or not).

Marko

[DB Solo Admin]

There should be a solution for this now. In the ?=? dialog there is a toggle-button that allows you to ignore the line endings.

You can find the fixed version here

dbsolo.com/preview

Marko

[Robin Lowther]

Hi Marko,

Yes, that works fine for CRLF/LF differences, but I wonder whether it could also cover any whitespace differences as well?  Perhaps the toggle-button could also default depending on the "Ignore whitespace when comparing source" setting?

Regards,

Robin

[DB Solo Admin]

Hi,

It might make more sense to have a separate button to ignore the whitespace besides the end of line characters.

Marko

[Robin Lowther]

Yes a separate button would work, but since the "ignore whitespace" in compare settings seems to cover both, perhaps they should be consistent in both places?

Regards,

Robin

[DB Solo Admin]

Yeah that might actually make more sense, let me investigate.

Marko