> 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:
<pre>
INSERT INTO fts3(rowid, docid, cols) VALUES(1, 2, ...);
</pre>
The problem with SQLite not allowing "rowid" in the join query, even though the reference is not ambiguous, is fixed here, btw:
<https://www.sqlite.org/src/info/d4097364c511709b>
So the UPDATE FROM on the fts5 table should now work with trunk. Or 3.37.0, when it is released.
Dan.