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

I'd also love to see this as a formula, in order to apply conditional formatting based on the whether the content of a cell passes the data validation rule or not. Something like ISVALID(value).

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

I'm completely baffled: what's the point of "Data Validation" if there's no way of checking whether the data satisfies the condition? Could we all be missing something?

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