On 10/7/15, Peter Aronson <pbaronson at att.net> wrote: > I assume, like with similar enhancements, a database created at SQLite > 3.8.12 with an expression index will be unreadable with earlier versions of > SQLite? As, for instance, a database created at 3.8.11 with an index with a > where clauses causes SQLite 3.715.2 to fail when trying execute any SQL > statements with "Error: malformed database schema (index name) - near > "where": syntax error?
Correct. On the other hand, a database created using 3.8.12 that does NOT use new features, should be readable and writable by all prior versions of SQLite. -- D. Richard Hipp drh at sqlite.org