CODEWITHSUNDEEP
sqlsqlitefull-text-searchfts4
Name is carl
Name is carl

Reputation: 6031

Cannot create noindexed columns with in sqlite FTS table

I'm trying to create the following table with 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 some reason, the command fails with the following error: 

 no such column: media_id

Do you know what is going wrong?

Note : According to this answer, notindexed is supported for 3.8 and above.

Upvotes: 3

Views: 423

Answers (1)

CL.
CL.

Reputation: 180010

The notindexed= option is not a column but just an option. So when you want an unindexed column, you still have to list the 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
    ) ;

Upvotes: 5

Related Questions