CREATE VIRTUAL TABLE prepare statement syntax error on "IF NOT EXISTS"
Issue #92
new
on Android with implementation 'com.almworks.sqlite4java:sqlite4java:1.0.392'
I tested today with breakpoint and confirmed that it's "IF NOT EXISTS" statement not recognized by _SQLiteManualJNI.sqlite3_prepare_v2() in sqlite4java.....
Caused by: com.almworks.sqlite4java.SQLiteException: [1] DB[1] prepare() CREATE VIRTUAL TABLE IF NOT EXISTS parking_lot USING FTS4(id TEXT, area TEXT, name TEXT) [near "NOT": syntax error]'
I'm using Room.inMemoryDatabaseBuilder(appContext, AppDatabase.class)
Having the same issue when using Robolectric 4.1 to run Android tests. Although Robolectric still uses a very old version of sqlite4java, I overrode the dependency and forced use of the latest 1.0.302 version, but I have the same result as @lukechi1219.