Bug report #15600
Selecting features feature in spatial views and virtual layers leads to wrong results
|Affected QGIS version:||3.5(master)||Regression?:||Yes|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||23523|
Select features in spatialite views higlights wrong objects
#16 Updated by Gerhard Spieles almost 4 years ago
- Affected QGIS version changed from 3.1(master) to 3.5(master)
- File testviewspatialite_qgis3_5_56.zip added
tested issue with 3.5master, Rel 56.
To exclude faults, i have created a complete new project in 3.5 with a newly created spatialite database and layers via QGIS. Testproject and database are attached (zip).
Virtual Layers seems to be ok!.
Spatialite views leads to the same wrong results in selecting objects.
The issue seems for me to depend in the interpretation/handling of the "ROWID" in QGIS.
In the sample data, I created to views. One with the "ROWID" from the geometrielayer(Parent), one without.
The layer (view) with the "ROWID" shows:
-undefined selection behaviour for objects
-in objectcount = 0,
-open the the attribute table, 100 filtered Rows are shown. Really, the layer has 256 rows.
-When you go to the layer in the layers panel, right click, filter and define a filter "ROWID < 1000000", the objectcount shows 256 rows and the attrubute table shows all the 256 rows. Selecton behaviour is further undefined.
The layer (view) without "ROWID" shows:
-all objects are selected, even only one oject was clicked.
-in objectcount 0
-in attribute table only one filtered row. Setting a filter via layers panel like "ROWID < 1000000" brings no change.