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

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

configurationsection - activeMq-5.13.3 setup configurations for wildfly 10.0.0 -