Object Schema comparison

33 views
Skip to first unread message

Robin Lowther

unread,
Apr 13, 2021, 7:45:16 AMApr 13
to DB Solo
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

unread,
Apr 13, 2021, 4:13:19 PMApr 13
to DB Solo
If you 'ignore whitespace' it will cover the newlines as well, no?

Marko

Robin Lowther

unread,
Apr 13, 2021, 4:46:06 PMApr 13
to DB Solo
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

unread,
Apr 13, 2021, 8:05:05 PMApr 13
to DB Solo
That's correct. At the moment the ?=? window shows the source code unmodified (whether whitespace was ignored during comparison or not).

Marko

Message has been deleted

DB Solo Admin

unread,
Apr 14, 2021, 8:15:31 PMApr 14
to DB Solo
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



Marko

Robin Lowther

unread,
Apr 16, 2021, 7:11:34 AMApr 16
to DB Solo
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

unread,
Apr 19, 2021, 8:29:52 PMApr 19
to DB Solo
Hi,

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

Marko

Robin Lowther

unread,
Apr 27, 2021, 4:08:37 PMApr 27
to DB Solo
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

unread,
Apr 27, 2021, 8:54:11 PMApr 27
to DB Solo
Yeah that might actually make more sense, let me investigate.

Marko

Reply all
Reply to author
Forward
0 new messages