Thinking about it yes i agree. Ultimately, if the CTE is not used, FB need not execute the query. No CPU cycles lost. Maybe a warning in the query plan, but an error is too restricting > Unlike Louis, I don't understand why this results in an error, I'd say > Firebird is too picky in this case. > > > > • > • > •
Re: [firebird-support] Annoying: CTE "CTE2" is not used in query
Louis van Alphen [email protected] [firebird-support] Fri, 14 Aug 2015 10:45:55 -0700
- [firebird-support... 'Louis van Alphen' [email protected] [firebird-support]
- Re: [firebir... Tim Ward [email protected] [firebird-support]
- Re: [fir... setysvar [email protected] [firebird-support]
- Re: ... Louis van Alphen [email protected] [firebird-support]
