search

yy0931 / sqlite3-editor

https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor
GNU General Public License v3.0
838 stars 6 forks source link

Wrong rowid #42

Closed vizam closed 10 months ago

vizam commented 10 months ago

The left column is supposed to be rowid right ? But hovering over it, shows some kind of offset, after manipulating database. I tried another viewer, showing the right state

image

yy0931 commented 10 months ago

The leftmost column displays the offsets in the result of the SELECT statement. It always start at 1. The tooltip reveals the rowid in the rowid table. Note that the rowid does not always start at 1. Does this answer your question?