SQLite FTS4 compound MATCH doesn't work with FMDB (iOS, Objective c) -
i have simple fts4 query:
select * addresses addresses match '(plz:12* or nummer:12*) , (ort:berlin*)'
this query works fine sqlitemanager
(i results), when execute query fmdb don't results (no errors no results).
when use query fmdb works:
select * addresses addresses match 'ort:berlin* plz:12* or nummer:12*'
it seems fmdb has problem braces. there alternative braces?
is there bug in fmdb? use simple tokenizer:
[db executeupdate:@"create virtual table if not exists addresses using fts4(id, plz, nummer, ort, strasse, tokenize=simple);"];
Comments
Post a Comment