Bug report #21176

Can't open feature form when when the primary key of Spatialite layer is created in text type

Added by Claas Leiner over 3 years ago. Updated over 3 years ago.

Assignee:Alessandro Pasotti
Category:Data Provider/SpatiaLite
Affected QGIS version:3.5(master) Regression?:Yes
Operating System: Easy fix?:No
Pull Request or Patch supplied:Yes Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:28994


When I identify a SpatiaLite-Layer i can' t open the feature form, when the primary key is created in text type.
Is the primary key integer, there is no problem.

QGIS 3.4.4, Ubuntu 16.04.

see example project


spatlialite_prkey_prob.7z (236 KB) Claas Leiner, 2019-02-05 03:42 PM

Associated revisions

Revision 7f61dc49
Added by Alessandro Pasotti over 3 years ago

Fix spatialite text pks and other issues

... also fixes the geometry information query
when spatialite version is >= 4

Fixes #21176

With tests


#1 Updated by Alessandro Pasotti over 3 years ago

  • Assignee set to Alessandro Pasotti

#2 Updated by Alessandro Pasotti over 3 years ago

  • Pull Request or Patch supplied changed from No to Yes
  • Affected QGIS version changed from 3.4.4 to 3.5(master)
  • Status changed from Open to In Progress

#3 Updated by Alessandro Pasotti over 3 years ago

  • % Done changed from 0 to 100
  • Status changed from In Progress to Closed

Also available in: Atom PDF