Bug report #14232

select features in a spatialite view leads to wrong_results

Added by Gerhard Spieles over 1 year ago. Updated over 1 year ago.

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

Description

When i select features in a spatialite view, wrong objects are selected
sample jpgs are attached

spatialite_view_layer_select_feature.jpg (152 KB) Gerhard Spieles, 02/04/2016 06:31 AM

spatialite_view_layer_selected_feature_wrong_result.jpg (145 KB) Gerhard Spieles, 02/04/2016 06:31 AM


Related issues

Duplicated by QGIS Application - Bug report #14327: Selection mismatch views sqlite Closed 02/18/2016

Associated revisions

Revision f028c0bb
Added by Martin Dobias over 1 year ago

[spatialite] use view's pkey if defined in meta table (fixes #14232)

Revision 42d88848
Added by Martin Dobias over 1 year ago

Improved fix for spatialite views (fixes #14232)

Revision 780c5873
Added by Martin Dobias over 1 year ago

Improved fix for spatialite views (fixes #14232)

(cherry picked from commit 42d88848f3010365d2c9fcf84b3a8ed5d52749a1)

History

#1 Updated by Giovanni Manghi over 1 year ago

  • OS version deleted (7)
  • Priority changed from High to Severe/Regression
  • Operating System deleted (windows)

confirmed on master, is ok on 2.8.6

#2 Updated by Martin Dobias over 1 year ago

  • Status changed from Open to Closed

#3 Updated by Arnold van 't Veld over 1 year ago

  • Status changed from Closed to Reopened

I'm trying in QGIS 2.14 to select a field (without pkey) and then I see the same prob again.

Is it obligatory to have a pkey in a spatialite table?

Actually, I'm now using a table create based on a view

#4 Updated by Martin Dobias over 1 year ago

  • Status changed from Reopened to Closed

#5 Updated by Martin Dobias over 1 year ago

Backported to 2.14 branch in 780c5873f62cf60d040e776f622bc1ad4edb7e79

Also available in: Atom PDF