We are trying to update from sqlite3 3.10 to 3.17. Our virtual table modules are encountering problems with 3.17 since the 'xOpen' callback is now being called for value change and row deletion operations. Previously it was only being called for read-only queries.

We are using reader/writer locks and there is not a convenient way to transition from being a reader to being a writer. A file is opened by the 'xOpen' callback and we need to know if the file should be opened read only, or read/write.

The change in behavior can only work with virtual table modules which are able to smoothly transition between the state established by 'xOpen' to the 'xUpdate' call or know the intent when 'xOpen' is called. This did not seem to be a requirement before.

In what sqlite3 version did this behavior change?

Is there a way to know when the 'xOpen' callback is called if it is to support an update transaction (i.e. 'xUpdate' callback will be called)?

Thanks,

Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,    http://www.GraphicsMagick.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to