Subject | RE: [firebird-support] CREATE VIEW ... WITH RECURSIVE ... (error) |
---|---|
Author | Leyne, Sean |
Post date | 2008-04-16T19:29:34Z |
Philip,
an issue, if not please wait for some comments and then, if required,
open a new tracker case.
Sean
> I'm using FB2.1rc1. I haven't seen any bug reports indicatingYou should check the project tracker to see if this has been reported as
> 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.
an issue, if not please wait for some comments and then, if required,
open a new tracker case.
Sean