How can we help you today? How can we help you today?

Parsing error on Materialized View with "WITH" clause

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.
skoffer
0

Comments

2 comments

Sort by
  • 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
    0
  • 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
    neil.anderson
    0

Add comment

Please sign in to leave a comment.