Schema Compare creates a blank line in scripts with union all. (4225571)

Schema Compare creates a blank line in scripts with union all. The spaces in the script are treated like separators and it runs as separate commands instead of creating a view based off a union.


Ex:
Prompt View STRAT_VW;
CREATE OR REPLACE FORCE VIEW HIEU.STRAT_VW
(COLUMN1)
AS
SELECT z.a_key
FROM
a_tbl z

UNION ALL

SELECT x.b_key
FROM
b_tbl x

WORKAROUND 1:
Manually remove spaces from the sync script.

WORKAROUND 2:
Recreate original view using scripts specifically without spaces between UNION ALL. Then re-run the compare to general the sync script again.

STATUS:
Waiting for fix in a future version of Toad for Oracle.