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 12 months ago. Updated 11 months ago.

Status:Closed
Priority:Normal
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

Description

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

Claas

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

Associated revisions

Revision 7f61dc49
Added by Alessandro Pasotti 11 months ago

Fix spatialite text pks and other issues

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

Fixes #21176

With tests

History

#1 Updated by Alessandro Pasotti 11 months ago

  • Assignee set to Alessandro Pasotti

#2 Updated by Alessandro Pasotti 11 months 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 11 months ago

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

Also available in: Atom PDF