Subject RE: [firebird-support] CREATE VIEW ... WITH RECURSIVE ... (error)
Author Leyne, Sean
Philip,

> I'm using FB2.1rc1. I haven't seen any bug reports indicating
> this had been reported, or fixed in FB2.1rc2.
>
> The SELECT query itself runs fine (finally), but creating a
> VIEW out of it does not. Error message and query are below.
>
> Does FB2.1 support creating views based on common table
> expressions (CTE)'s yet? Am I just getting a strange error
> that indicates it thinks the whole WITH clause is part of the
> new view name, because it's not parsing it correctly? When it
> complains about long object names, it doesn't spit back out
> what it thinks you meant, so it's hard to tell.

You should check the project tracker to see if this has been reported as
an issue, if not please wait for some comments and then, if required,
open a new tracker case.


Sean