What’s the compatibility of the new partial indexes* with deterministic functions in their WHERE clauses? I.e. if I create such an index, and then later the database is opened by an older version of SQLite, what happens? (Let’s say the function used in the WHERE clause is still properly registered.) If that’s ok, then what happens if the older SQLite modifies the database and updates the index? And what happens if the database is then re-opened by an instance of SQLite with the new functionality?
I’m just trying to decide whether I can safely make use of this feature yet, since some places my code will run will have only the built-in iOS version of SQLite, which is currently 3.14.0 at best. (But I suppose that even if it’s not version-compatible, I can at least detect the situation when opening the db and issue a REINDEX command.) —Jens * is it ‘indexes’ or ‘indices’, in computer science? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
