| Subject | Re: [firebird-support] "Dynamic SQL Error SQL error code = -104 CTE "CTE_CP" is not used in query" |
|---|---|
| Author | Tim Ward |
| Post date | 2015-02-17T09:46:48Z |
That would be my view, yes! - I've got a mind-bending day (or three) ahead of me trying to tweak the query generation code.On Tue, 17 Feb 2015 09:41:56 +0000, "Tim Ward tdw@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> Why?? Why does that have to be a failure?? Why can't Firebird just
> ignore it??
>
> Is there any switch to turn off this behaviour??
>
> (I've got some immensely complicated query generation code which, it now
> appears, can occasionally include a common table expression in the query
> that isn't actually used anywhere. I've now got to fix that code to be
> extremely careful about *ex*cluding unneeded CTEs - it's currently aimed
> at being extremely careful to *in*clude CTEs that *are* needed.)
It sounds like this should be a warning, and not an error.
Mark
__._,
-- Tim Ward