SQLite Forum

fts5 rowid peculiarity in UPDATE FROM
Login
Sqlite version 3.36.0 

For fts4 the following query works

<blockquote>
update FtsIndex4 Set text="foo bar" from
(select 123432545 as modified
) where docid=modified
</blockquote>

but for fts5 the equivalent one (docid is replaced by rowid)

<blockquote>
update FtsIndex5 Set text="foo bar" from
(select 123432545 as modified
) where rowid=modified
</blockquote>

gives an error (no such column rowid), but with the table name prefix "...where FtsIndex5.rowid=modified..." it works. Not a big deal, but might confuse working with drop-in replacement in mind when migrating from fts3/fts4 to fts5

Thanks