Bug report #14232

select features in a spatialite view leads to wrong_results

Added by Gerhard Spieles about 1 year ago. Updated 11 months ago.

Status:Closed Start Date:02/04/2016
Priority:Severe/Regression Due date:
Assigned to:- % Done:

0%

Category:SpatiaLite Data Provider
Target version:Version 2.14
Platform: Pull Request or Patch supplied:No
Platform version: Affected version:master
Status info: Causes crash or corruption:No
Resolution: Tag:

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.5 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 f028c0bb5898af12b81953210dabf2a26713095d
Added by Martin Dobias about 1 year ago

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

Revision 42d88848f3010365d2c9fcf84b3a8ed5d52749a1
Added by Martin Dobias 12 months ago

Improved fix for spatialite views (fixes #14232)

Revision 780c5873f62cf60d040e776f622bc1ad4edb7e79
Added by Martin Dobias 11 months ago

Improved fix for spatialite views (fixes #14232)

(cherry picked from commit 42d88848f3010365d2c9fcf84b3a8ed5d52749a1)

History

Updated by Giovanni Manghi about 1 year ago

  • Priority changed from High to Severe/Regression
  • Platform deleted (windows)
  • Platform version deleted (7)

confirmed on master, is ok on 2.8.6

Updated by Martin Dobias about 1 year ago

  • Status changed from Open to Closed

Updated by Arnold van 't Veld 11 months 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

Updated by Martin Dobias 11 months ago

  • Status changed from Reopened to Closed

Updated by Martin Dobias 11 months ago

Backported to 2.14 branch in 780c5873f62cf60d040e776f622bc1ad4edb7e79

Also available in: Atom