Spatialite point layers are not displayed when the primary key is created in text type and a spatial index exists at the same time

[qgib]

Author Name: Claas Leiner (@claasleiner)
Original Redmine Issue: 20547
Affected QGIS version: 3.4.1
Redmine category:data_provider
Assignee: Julien Cabieces

---

In QGIS 3.41, SpatiaLite point layers will not be displayed if there is a spatial index.
It is possible to zoom to the layer und the data in the attribute-table is correct. But I can't see any points.

When I remove the spatial index, the I can load the Layer and see the points.

With Polygon-Layers is no problem.

Greetings, Claas

---

• test.sqlite.zip (Claas Leiner)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

I cannot confirm here with my own data, can you attach a sample dataset?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Claas Leiner (@claasleiner)

---

The problem occurs when the primary key is created in text type and a spatial index exists at the same time. (in test.sqlite the table kunden1 with the primary key knr)
In the table kunden2, the primary key is the field nr (integer). This layer is displayed correctly in qgis 3.4.1.
In QGIS 2.18.25 both layers are displayed correctly.

[qgib]

Author Name: Claas Leiner (@claasleiner)

---

sample dataset test.sqlite

---

• 13802 was configured as test.sqlite.zip

---

• test.sqlite.zip (Claas Leiner)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Feedback to Open
• subject was changed from Spatialite point layers are not displayed if there is a spatial index to Spatialite point layers are not displayed when the primary key is created in text type and a spatial index exists at the same time

[qgib]

Author Name: Julien Cabieces (Julien Cabieces)

---

Proposed PR : #8832

---

• assigned_to_id was configured as Julien Cabieces
• pull_request_patch_supplied was changed from 0 to 1
• status_id was changed from Open to In Progress

[qgib]

Author Name: Julien Cabieces (Julien Cabieces)

---

Applied in changeset c478ba9.

---

• done_ratio was changed from 0 to 100
• status_id was changed from In Progress to Closed