Ah. Of course. Thanks for waking me up.. both you and Igor.
-----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, October 08, 2015 12:12 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] [sqlite-dev] Proposed new version numbering scheme for SQLite - Feedback requested 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 _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential, proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distribution or other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have received this email in error, please notify the sender immediately and delete the original.
