Room FTS table should drop and recreate tables during AutoMigration [348227770]

Fixed

Bug

Status Update

No update yet.

Description

el...@google.com

created issue #1

Jun 19, 2024 11:42PM

User reported receiving a `virtual tables may not be altered (code 1 SQLITE_ERROR)` error when a new column is added to an FTS table. They also reported that Room tries to alter the table to add the new column instead of recreating (as should be the process for FTS tables)

Comments

ap...@google.com <ap...@google.com> #2Feb 26, 2025 11:26PM

Project: platform/frameworks/support
Branch: androidx-main
Author: elifbilgin <elifbilgin@google.com>
Link: https://android-review.googlesource.com/3511212

Fix FTS table issue in AutoMigration.

Expand for full commit details

Fix FTS table issue in AutoMigration. 
 
A new column in an FTS table is considered a complex change and should be treated as such, as opposed to a regular table where a simple ADD COLUMN statement would suffice. This CL provides a fix for this behavior. 
 
Bug: 348227770 
Test: AutoMigrationTest.kt, add new column in Entity 22 going from V3 -> V4. 
Change-Id: Ic53f33be4140a95d76bc9a1bd40f3554684781ac

Files:

M room/integration-tests/kotlintestapp/schemas-ksp/androidx.room.integration.kotlintestapp.migration.AutoMigrationDb/4.json
M room/integration-tests/kotlintestapp/schemas-ksp/androidx.room.integration.kotlintestapp.migration.AutoMigrationDb/5.json
M room/integration-tests/kotlintestapp/schemas/androidx.room.integration.kotlintestapp.migration.AutoMigrationDb/4.json
M room/integration-tests/kotlintestapp/schemas/androidx.room.integration.kotlintestapp.migration.AutoMigrationDb/5.json
M room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/migration/AutoMigrationDb.kt
M room/room-compiler/src/main/kotlin/androidx/room/util/SchemaDiffer.kt

Hash: e187bb836d9402d7c5943a3486851dab7499d5d1
Date: Wed Feb 26 13:32:41 2025

el...@google.com <el...@google.com> Feb 26, 2025 11:37PM

Marked as fixed.

na...@google.com <na...@google.com> #3Mar 12, 2025 06:13PM

The following release(s) address this bug.It is possible this bug has only been partially addressed:

androidx.room:room-compiler:2.7.0-rc02

Issue 348227770

Description

Issue summary

Comments

ap...@google.com <ap...@google.com> #2Feb 26, 2025 11:26PM

el...@google.com <el...@google.com> Feb 26, 2025 11:37PM

na...@google.com <na...@google.com> #3Mar 12, 2025 06:13PM

Add comment

Issue metadata