sql - Cannot create noindexed columns with in sqlite FTS table -

sql - Cannot create noindexed columns with in sqlite FTS table -

i'm trying create next table sqlite 3.8.2

create virtual table if not exists media_fts using fts4 ( notindexed=media_id, notindexed=album_id, title, artist, album_artist, album, comment, lyrics ) ;

but reason, command fails next error:

no such column: media_id

do know going wrong?

note : according this answer, notindexed supported 3.8 , above.

the notindexed= alternative not column option. when want unindexed column, still have list column itself:

create virtual table if not exists media_fts using fts4 ( title, artist, album_artist, album, comment, lyrics, media_id, album_id, notindexed=media_id, notindexed=album_id ) ;

sql sqlite full-text-search fts4