The SQLite build in iOS should compile with FTS5 enabled

Originator:steipete
Number:rdar://29850081 Date Originated:03-Jan-2017 07:35 PM
Status:Resolved Resolved:
Product:iOS + SDK Product Version:iOS 10.2
Classification:Enhancement Reproducible:Always
 
Peter Steinberger03-Jan-2017 07:35 PM

Area:
Something not on this list

Summary:
SQLite's FTS5 store is faster and more memory and disk efficient. We would like to use it in PSPDFKit's indexed full-text search.

http://mjtsai.com/blog/2015/07/31/sqlite-fts5/
https://sqlite.org/fts5.html

Steps to Reproduce:
Try to create a table via CREATE VIRTUAL TABLE email USING fts5(sender, title, body);

See https://sqlite.org/fts5.html

Expected Results:
(lldb) p sqlite3_compileoption_used("SQLITE_ENABLE_FTS5")
(int) $30 = 1

Actual Results:
(lldb) p sqlite3_compileoption_used("SQLITE_ENABLE_FTS5")
(int) $30 = 0

Version:
iOS 10.2

Notes:
Of course we can always ship a custom SQLite build, but that increases binary size and causes other issues and incompatibilities. Right now the situation is that we need to support both the old FTS3/4 and the new FTS5 with separate code paths. We would love to drop that once we drop iOS 10 (if that makes it into iOS 11)

Configuration:
iPad Pro 9.7'

Attachments:

Comments

iOS 11 now ships with an sqlite build that has the new FTS 5 enabled. Neato! (Got a ping that http://openradar.appspot.com/29850081 is closed now)

By steipete at June 14, 2017, 7:22 a.m. (reply...)

Please note: Reports posted here will not necessarily be seen by Apple. All problems should be submitted at bugreport.apple.com before they are posted here. Please only post information for Radars that you have filed yourself, and please do not include Apple confidential information in your posts. Thank you!