Selecting features feature in spatial views and virtual layers leads to wrong results

[qgib]

Author Name: Gerhard Spieles (Gerhard Spieles)
Original Redmine Issue: 15600
Affected QGIS version: 3.5(master)
Redmine category:vectors
Assignee: Hugo Mercier

---

Select features in spatialite views higlights wrong objects

---

• test.zip (Gerhard Spieles)
• testviewspatialite_qgis3_5_56.zip (Gerhard Spieles)

---

Related issue(s): #22229 (relates), #23632 (relates), #26804 (relates)
Redmine related issue(s): 14232, 15709, 18973

---

[qgib]

Author Name: Reinhard Reiterer (Reinhard Reiterer)

---

See also: #23073 (Virtual Layer - Selecting multipart features fails)

Perhaps these issues are related, since virtual layers are based on SpatiaLite.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• regression was configured as 0
• easy_fix was configured as 0

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Worked as expected for SL views (virtual layer untested as they were not available) until 2.8.*

---

• regression was changed from 0 to 1
• priority_id was changed from Normal to High
• version was changed from 2.14.5 to 2.18.13

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• subject was changed from Select feature in spatial views leads to wrong results to Selecting features feature in spatial views and virtual layers leads to wrong results

[qgib]

Author Name: Vincent Dionne (Vincent Dionne)

---

The same problem is present in 2.18.13 when adding a spatialite layer through DB MANAGER -SQL Query.

Easy to replicate: DB Manager => SQLITE => SQL window => Select * from your_layer => add layer.

Feature selection will be wrong.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• relates was configured as select features in a spatialite view leads to wrong_results #22229

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• relates was configured as bad match of valeurs with virtual layer #23632

[qgib]

Author Name: Gerhard Spieles (Gerhard Spieles)

---

Issue is still present in 3.1.0-3 (see Mail Paolo Cavallini, QGIS tickets)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• version was changed from 2.18.13 to 3.1(master)
• operating_system was changed from win to

[qgib]

Author Name: Leon van der Meulen (@leonmvd)

---

Problem still persists in 3 as well with PostGIS layers. Ordinary file based layers are ok though

[qgib]

Author Name: Dominique Lyszczarz (@domlysz)

---

Confirmed with a Geopackage spatial view. Note it also affect manual label positioning with xy position stored in auxiliary layer : trying to move a label with the dedicated tool performs the shift for another feature's label.

[qgib]

Author Name: Hugo Mercier (@mhugo)

---

• relates was configured as Wrong identification of feature in a View #26804

[qgib]

Author Name: Hugo Mercier (@mhugo)

---

I see several issues in the provided project:

• virtual layers: selection works fine, but the identification tool identifies all the object
• spatialite views: selection selects the wrong feature, identification tool seems ok

---

• assigned_to_id was configured as Hugo Mercier

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

Could you please check again on current release and update the affected version if still valid?
Thanks.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Paolo Cavallini wrote:

Could you please check again on current release and update the affected version if still valid?
Thanks.

Please change status to "feedback" when needed.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Gerhard Spieles (Gerhard Spieles)

---

Hello,
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.

---

• version was changed from 3.1(master) to 3.5(master)
• 14042 was configured as testviewspatialite_qgis3_5_56.zip

---

• testviewspatialite_qgis3_5_56.zip (Gerhard Spieles)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Feedback to Open

[gioman]

Select/identify on virtual layers is ok (I think it has been fixed), while the issue with SL/GPKG views is duplicate of

#36291