Cannot select correct features in Virtual Layer

[qgib]

Author Name: Joseph Liam (Joseph Liam)
Original Redmine Issue: 19838
Affected QGIS version: 2.18.22
Redmine category:virtual_layers

---

I created a virtual layer which contains a copy of features from another layer (be it point, line or polygon) using the expression:

@select * FROM "some_layer"@

Now when I use the Select Features tool and try to select either one or a group of features, it would select other features which I did not highlight (as shown in the image provided).

But the selection doesn't seem to be random. When I try to select the same features each time, other features which lie somewhere else are instead selected. I tried changing the projection CRS but the issue remained.

---

• image11.png (Joseph Liam)

---

Related issue(s): #22229 (relates)
Redmine related issue(s): 14232

---

[qgib]

Author Name: Joseph Liam (Joseph Liam)

---

A related question had been asked on GIS Stack Exchange: https://gis.stackexchange.com/questions/261615/selection-feature-acting-weird-on-queried-layer-in-qgis

[qgib]

Author Name: Gerhard Spieles (Gerhard Spieles)

---

Same issue in Spatialite Views #22229

[qgib]

Author Name: Andrea Giudiceandrea (@agiudiceandrea)

---

Did you try with QGIS 3.3.0-master?

[qgib]

Author Name: Harrissou Santanna (@DelazJ)

---

Can you try the query with naming the fields you want to add to the virtual layer ? cf https://docs.qgis.org/testing/en/docs/user_manual/managing_data_source/create_layers.html#supported-query-language

---

• status_id was changed from Open to Feedback

[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: Joseph Liam (Joseph Liam)

---

Harrissou Santanna wrote:

Can you try the query with naming the fields you want to add to the virtual layer ? cf https://docs.qgis.org/testing/en/docs/user_manual/managing_data_source/create_layers.html#supported-query-language

Tried quering with naming fields in the expression (e.g. @select geometry, fieldName FROM "some_layer"@), same result when trying to select features.

[qgib]

Author Name: Joseph Liam (Joseph Liam)

---

Andrea Giudiceandrea wrote:

Did you try with QGIS 3.3.0-master?

It seems to work on QGIS 3.2.0 at least, can't test master at the moment. I was hoping a fix for the LTR version. This is used in a plugin for QGIS 2.18 and was hoping for a fix until I have the time to port over to QGIS 3 :)

[qgib]

Author Name: Harrissou Santanna (@DelazJ)

---

Is this still valid in 3.4.2?

[qgib]

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

---

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Closing for lack of feedback.

---

• resolution was changed from to no timely feedback
• status_id was changed from Feedback to Closed

[jorgealmerio]

Please reopen this! Same thing is happening here with a *.VRT file with Qgis 3.16.1.

Versão do QGIS	3.16.1-Hannover	Código da versão do QGIS	b381a90
Compilado sobre Qt	5.11.2	Rodando sobre Qt	5.11.2
Compilado sobre GDAL/OGR	3.1.4	Rodando sobre GDAL/OGR	3.1.4
Compilado sobre GEOS	3.8.1-CAPI-1.13.3	Rodando sobre GEOS	3.8.1-CAPI-1.13.3
Compilado no SQLite	3.29.0	Executando contra SQLite	3.29.0
Versão do cliente PostgreSQL	11.5	Versão SpatiaLite	4.3.0
Versão do QWT	6.1.3	Versão QScintilla2	2.10.8
Compilado com PROJ	6.3.2	Em execução com PROJ	Rel. 6.3.2, May 1st, 2020
Versão SO	Windows 7 SP 1 (6.1)
Ativar complementos python	c3d; CalculateGeometry; changeDataSource; coordinator; flowTrace; GroupStats; ImportPhotos; MemoryLayerSaver; pluginbuilder3; PluginLoadTimes; plugin_reloader; QEsg; quick_map_services; splitmultipart; SpreadsheetLayers; uteis; valuetool; VectorBender; wnt; db_manager; processing

SES_redes_Trechos.zip

[gioman]

Please reopen this! Same thing is happening here with a *.VRT file with Qgis 3.16.1.

@jorgealmerio would you mind opening a new ticket? I would like avoid reopen very old tickets that unlikely anyone will have a look at. Thanks!