SelectTool on Oracle layer selects always ALL features

[qgib]

Author Name: Richard Duivenvoorde (@rduivenvoorde)
Original Redmine Issue: 16869
Affected QGIS version: master
Redmine category:data_provider/oracle

---

In latest master, loading an Oracle layer and trying to select a couple of features with the selectTool, ALL features are selected (or at least turn yellow).

Same machine, same layer/db, but with 2.18.10 this is ok.

Selecttool is also working OK if I select a postgis layer on that same machine/QGIS. So to me it seems Oracle provider related.

---

• nokey.png (Richard Duivenvoorde)

[qgib]

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

---

Which primary key does the table have?

[qgib]

Author Name: Richard Duivenvoorde (@rduivenvoorde)

---

Well, apparently none when I look into the 'open layer' dialog (see screendump).

And looking into the DDL of the table, there is NOT a primary key on one of the columns...

And trying to create a primary key, I fail because some rows have null values for fields...

Is a primary key always needed? 2.18.10 seems to work without it?

---

• 11177 was configured as nokey.png

---

• nokey.png (Richard Duivenvoorde)

[qgib]

Author Name: Richard Duivenvoorde (@rduivenvoorde)

---

Additional observation (but probably same reason): no rows are shown in attribute table.

In case of such a table, QGIS can apparently load and show the features. Should/Could we maybe generate an internal id for these?

[qgib]

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

---

• assigned_to_id removed Jürgen Fischer

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• priority_id was changed from Normal to High

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Applied in changeset 7ffc148.

---

• status_id was changed from Open to Closed
• done_ratio was changed from 0 to 100

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• resolution was changed from to fixed/implemented