On Aug 17, 2015 21:53, "Yuriy M. Kaminskiy" <yumkam at gmail.com> wrote: > > ... and then, at some wonderful moment, sqlite devs will implement query > flattening for CTE (like they did for subquery above), and you'll be in > square one. > > (Or, maybe, they will finally implement "common subexpression > elimination", and original query will suddenly work again). > > It is not good idea to depend on undocumented behavior.
A very good point! Thanks for reminding me. > >
