Bug report #14626

SpatiaLite layer not displaying in QGIS 2.14, works ok in QGIS 2.8

Added by Christophe Damour over 8 years ago. Updated over 8 years ago.

Status:Closed
Priority:Severe/Regression
Assignee:-
Category:Data Provider/SpatiaLite
Affected QGIS version:master Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:22591

Description

Attached layer doesn't display correctly in QGIS 2.14 : no feature displayed, incorrect attribute values.
However it displays correctly in QGIS 2.8.

test_tron.zip (575 KB) Christophe Damour, 2016-04-07 07:23 AM

Related issues

Related to QGIS Application - Bug report #14575: attribute table errors when spatialite primary key is text Closed 2016-03-27
Duplicated by QGIS Application - Bug report #14999: Spatialite provider does not support alphanumeric primary... Closed 2016-06-10

Associated revisions

Revision 10501745
Added by Jürgen Fischer over 8 years ago

spatialite provider: prefer rowid as primary key where available (and some cleanups)

fixes #14575, fixes #14626

Revision 69e3c6f7
Added by Even Rouault over 8 years ago

[Spatialite provider] prefer rowid as primary key where available

Adapted from 1050174532627ae44c4467e9911c1fca41e138e3 without the cleanups.

fixes #14575, fixes #14626, fixes #14999

History

#1 Updated by Nyall Dawson over 8 years ago

  • Status changed from Open to Feedback

Please test with 2.14.1. A related fix was included.

#2 Updated by Christophe Damour over 8 years ago

Thank you for answering Nyall.
The problem occurs in QGIS 2.14.1.

#3 Updated by Nyall Dawson over 8 years ago

  • Status changed from Feedback to Open

#4 Updated by Giovanni Manghi over 8 years ago

  • Target version set to Version 2.16
  • Affected QGIS version changed from 2.14.0 to master
  • Priority changed from High to Severe/Regression

#5 Updated by Jürgen Fischer over 8 years ago

  • Status changed from Open to Closed

#6 Updated by Christophe Damour over 8 years ago

Thanks for the correction.
Will it be backported to the next 2.14 point release ?

#7 Updated by Even Rouault over 8 years ago

  • Target version changed from Version 2.16 to Version 2.14

Backported to 2.14

Also available in: Atom PDF