[firebird-support] Dynamic SQL Error SQL error code = -104 CTE CTE_CP is not used in query
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.) -- Tim Ward ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Dynamic SQL Error SQL error code = -104 CTE CTE_CP is not used in query
On Tue, 17 Feb 2015 09:41:56 +, Tim Ward t...@telensa.com [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
Re: [firebird-support] Dynamic SQL Error SQL error code = -104 CTE CTE_CP is not used in query
On 17/02/2015 09:44, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On Tue, 17 Feb 2015 09:41:56 +, Tim Ward t...@telensa.com [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 __._, 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. -- Tim Ward