On 10/8/15, Marc L. Allen <mlallen at outsitenetworks.com> wrote:
> However, CTE is a functionality enhancement that, I believe, does not impact
> the ability of previous SQLite versions to work with the database. The
> thing is, I don't believe CTE is simply a "performance enhancement." To me,
> a "performance enhancement" provides no new functionality, but just works
> better.
>
If someone does (for example):
CREATE VIEW digits AS
WITH RECURSIVE c(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM c WHERE x<9)
SELECT x FROM c;
Then the CTE becomes part of the schema, and the database cannot be
opened by an earlier version of SQLite that lacks support for CTEs.
--
D. Richard Hipp
drh at sqlite.org
