Bug report #6226
Primary key field hidden on attributes tables addes to qgis
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||duplicate|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||15537|
Adding a sqlite text table (Layer > Add Vector Table) QGIS hides the primary key field (named `id`). The `id` field can not be used for references, queries or joins.
The ID field should be displayed and usable at least in read-only actions, such as queries, joins etc.
More information can be found here: http://gis.stackexchange.com/questions/31732/primary-key-field-hidden-on-atributes-tables-addes-to-qgis and here http://comments.gmane.org/gmane.comp.gis.qgis.user/18353
#3 Updated by Médéric RIBREUX over 4 years ago
- Status changed from Open to Feedback
Hello, bug triage...
I can't reproduce it on QGIS 2.13 master (and it should also be the case in QGIS 2.12.1).
When I am loading a SQLite non geographic table (and it is also true for geographic ones), the ID primary key is always displayed and editable. I can make joins on it.
Can you confirm that this bug is fixed ?