SQLite Forum

fts5 rowid peculiarity in UPDATE FROM
Login
Thanks, I understand now. The situation is unusual in the sense that rowid is a special citizen for obvious reasons and anyone familiar with Sqlite is used to this. In other words it's always there (with exception of WITHOUT ROWID tables), but you don't deal with it unless you want to. But when using fts5, one is enforced to use it instead of a general (at least from the naming point of view) column docid. So the special life of this citizen comes to light unconditionally. 

I tried to search in the timeline and it looks like not using an alias like docid was a very early design decision, the comment some time contained docid in description and then were renamed overnight. Just for historical curiosity I wonder what was the objective of not using docid alias from the start?