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-master-dev

commit bce60539c0944b4b449a6f03419f62715536c867
Author: Sumir Kataria <sumir@google.com>
Date: Wed Jan 23 00:05:10 2019

Revert "Mark jobs as completed, if they were never enqueued."

This reverts commit 77767a7c8c7d6f757c6110ebac2536be6e3b69ee.

Reason for revert:

b/123211993

Change-Id: I503f2479d0a123f1a85cc45193cae976dadd10d6

M work/workmanager/src/androidTest/java/androidx/work/impl/background/systemjob/SystemJobServiceTest.java
M work/workmanager/src/main/java/androidx/work/impl/WorkManagerImpl.java
M work/workmanager/src/main/java/androidx/work/impl/background/systemjob/SystemJobService.java
M work/workmanager/src/main/java/androidx/work/impl/utils/StartWorkRunnable.java

https://android-review.googlesource.com/881112

https://goto.google.com/android-sha1/bce60539c0944b4b449a6f03419f62715536c867

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