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