IssueTracker

Component used:

• androidx.room:room-runtime
• androidx.room:room-ktx
• androidx.room:room-compiler

Version used: 2.6.1

Devices/Android versions reproduced on: OnePlus 8T

I want to provide FTS support for a table which contains localized strings. So I specified the languageId option of the Fts4 annotation. This leads to following issues:

1. The languageId becomes a hidden column and is therefore displayed as an error by the linter when selected in a query.
2. The languageId isn't populated by the content table through a TRIGGER. The TRIGGER is missing which is supposed to be generated by the compiler plugin, therefore theoretically it has to be populated manually.

The following example showcases my use case, the Entity entity is ommited on purpose.

Is this a bug or am I just using this feature in a wrong way? There are literally no examples in the docs or anywhere else on the internet.

    @Entity(
        tableName = "entitiy_name_localized",
        foreignKeys = [
            ForeignKey(
                entity = Entity::class,
                parentColumns = ["id"],
                childColumns = ["entity_id"],
                onDelete = CASCADE
            ),
            ForeignKey(
                entity = Language::class,
                parentColumns = ["id"],
                childColumns = ["language_id"],
                onDelete = CASCADE
            )
        ],
        indices = [
            Index("language_id")
        ],
        primaryKeys = [
            "entity_id",
            "language_id"
        ]
    )
    data class EntityNameLocalized(
        @ColumnInfo(name = "entity_id") val entityId: Long,
        @ColumnInfo(name = "language_id") val languageId: Long,
        @ColumnInfo(name = "name") val name: String
    ) {
        @Fts4(
            contentEntity = EntityNameLocalized::class,
            languageId = "language_id"
        )
        @Entity(tableName = "entitiy_name_localized_fts")
        data class Fts(
            @ColumnInfo(name = "entity_id") val entityId: Long,
            @ColumnInfo(name = "language_id") val languageId: Long,
            @ColumnInfo(name = "name") val name: String,
        )
    }

    @Entity(
        tableName = "language",
        indices = [
            Index("id"),
            Index("language_tag", unique = true)
        ]
    )
    data class Language(
        @PrimaryKey(autoGenerate = true)
        @ColumnInfo(name = "id") val id: Long,
        @ColumnInfo(name = "language_tag") val languageTag: String
    )