guardianproject/android-database-sqlcipher — Issue #35: FTS3/4 MATCH not supported?
Author: Nappy
Created: 2011-12-16 11:14:46+00:00
State: open

Shema:
```sql
CREATE VIRTUAL TABLE sites USING fts4(domain, url, title, meta_keys, body)
CREATE TABLE keywords (keyword TEXT)
```

Query:
```sql
SELECT keyword FROM keywords INNER JOIN sites WHERE sites.title MATCH keywords.keyword
```
I get a info.guardianproject.database.sqlcipher.SQLiteException: "SQL logic error or missing database".

info.guardianproject.database.sqlcipher.SQLiteQuery.native_fill_window(Native Method)
info.guardianproject.database.sqlcipher.SQLiteQuery.fillWindow(SQLiteQuery.java:73)
info.guardianproject.database.sqlcipher.SQLiteCursor.fillWindow(SQLiteCursor.java:290)
info.guardianproject.database.sqlcipher.SQLiteCursor.getCount(SQLiteCursor.java:271)
android.database.CursorWrapper.getCount(CursorWrapper.java:51)