SQLite json_extract not working when having CouchbaseLiteSwift as dependency

Mobile Couchbase Lite
1

In our project we use CouchbaseLiteSwift to store and sync data. However we also have a seperate SQLite database not related to Couchbase.

Using the json_extract function on this database results in the following error when having CouchbaseLiteSwift as a dependency to the project.

"no such column: <json path>..", code=1, codeDescription="SQL logic error"

If i remove the dependency, json_extract works again.

I have created a simple SwiftUI app demonstrating the issue here

This is quite the show-stopper for us as it’s a third party library using the json_extract function.

2

Couchbase Lite has its own statically-linked copy of SQLite. But that shouldn’t affect your code; if you call SQLite in your app that should use the OS-supplied dylib, not ours. I’m not sure how CBL-Swift is packaged, though.