Parsing error on Materialized View with "WITH" clause

skoffer

Version 3.0.0.719

My view is like

CREATE MATERIALIZED VIEW smmry_cross_tab_equity_10
BUILD DEFERRED
REFRESH COMPLETE
AS WITH ba AS
(SELECT
rds_employee_id
,pcr_team_id
....

When trying to schema compare it I get the following error:
Parsing failed with message SyntaxError. Unexpected token 'AS'(Line 4, Col1) Sumbol Id.

neil.anderson

skoffer wrote:

Version 3.0.0.719

My view is like

CREATE MATERIALIZED VIEW smmry_cross_tab_equity_10
BUILD DEFERRED
REFRESH COMPLETE
AS WITH ba AS
(SELECT
rds_employee_id
,pcr_team_id
....

When trying to schema compare it I get the following error:
Parsing failed with message SyntaxError. Unexpected token 'AS'(Line 4, Col1) Sumbol Id.

Hi thanks for this. I've been able to recreate so I'll have a fix for you soon.

neil.anderson

Hi,

I believe this has been fixed. You can try the latest builds of Schema Compare and Source Control here:

http://download.red-gate.com/EAP/Source ... .0.100.exe

http://download.red-gate.com/EAP/Schema ... .0.737.exe

Please let me know if the problem persists.

Thanks,
Neil