Announcement

Collapse
No announcement yet.

Something is up with alignment of SQL with insignificant differences

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Something is up with alignment of SQL with insignificant differences

    On build 18291 Windows when comparing SQL BC4 incorrectly aligns and therefore identifies lines as a significant difference when there is only a case difference.

    Create a file "test.sql" and put

    /* This is a test. */
    SELECT 'BC4' FROM DUAL;


    in the file.

    In another file test2.sql" enter

    select 'BC4' from dual;

    Compare these files in a text compare. Line 1 of test.sql will align with line 1 of test2.sql and show significant differences. If you then manually align the actual SQL statements BC4 will then accurately identify this as an insignificant difference of a comment and case in SQL keywords only.

    I confirmed that BC3 immediately aligns test2.sql line 1 with test.sql line 2 showing no significant difference.

  • #2
    Thanks for the report. We'll look into what might have caused this alignment difference.
    Aaron P Scooter Software

    Comment

    Working...
    X