More issues with comments on views
Aside from the issue OC-644, that I reported last December, I have found another issue.
Anyway the symptoms are this. If a table or view comment (not a column comment) has more than one line, it always appears as a change needed to commit to the SVN repository.
For example, I have done this:
CREATE OR REPLACE VIEW v_test_comments ( val ) AS select 1 val from dual; -- Comments for V_TEST_COMMENTS COMMENT ON TABLE v_test_comments IS 'This is a comment.';
When I commit that view to the SVN repository, and refresh my project, it shows up again as needing to be checked in, but in the 'differences' section of the check-in screen, no differences between the view in the instance and repo are shown.
So, I pulled the repository using TortoiseHg and do a Schema Compare (ignoring whitespace) between the filesystem checked out version and the schema and find that it indicates they are different, unfortunately Schema Compare doesn't show any differences in the 'differences' section.
So I do a deployment, and copy the deployment script to the clipboard, which I have pasted here:
-- -- Script generated by Schema Compare for Oracle 220.127.116.118 on 8/12/2014 11:39:08 AM -- SET DEFINE OFF COMMENT ON TABLE akfish_cas2.v_test_comments IS 'This is a comment.';
Anyway, if I deploy the change to another schema, it continues to show that difference between the repo and the deployed instance, but not between the original instance (where the view and comment were made) and the deployed instance.
As a final point, if I change the comment thus:
COMMENT ON TABLE akfish_cas2.v_test_comments IS 'This is a comment.';
None of the behavior occurs, it behaves as expected. So, I suspect some kind of carriage-return/line feed problem. However, I am unable to figure out a way to have a multiple line comment commit and have Oracle Source Control or Schema Compare show the repo as being the same. This wouldn't be a problem if our comments were as in this example, but we have thousands of existing tables and views that have long descriptions. Newlines are needed.
I really want to use this tool, but these kinds of things are difficult to work around.