SQLite Forum

fts5 rowid peculiarity in UPDATE FROM
> Just for historical curiosity I wonder what was the objective of not using docid alias from the start?

Just didn't see any point to it at the time I suppose. And you have to figure out what to do about this:

    INSERT INTO fts3(rowid, docid, cols) VALUES(1, 2, ...);

The problem with SQLite not allowing "rowid" in the join query, even though the reference is not ambiguous, is fixed here, btw:


So the UPDATE FROM on the fts5 table should now work with trunk. Or 3.37.0, when it is released.