QGIS is assuming first column from Oracle DB is the primary key

[qgib]

Author Name: Belinda Baker (Belinda Baker)
Original Redmine Issue: 21717
Affected QGIS version: 3.4.0
Redmine category:data_provider/oracle
Assignee: Jürgen Fischer

---

When trying to load a table into Oracle with primary key GID (1st column) with non unique IDs, an error shows "Primary key field 'GID' for view not unique." when adding a new column ID with unique IDs (based on row numbers) as new primary key (last column) and using refresh icon in Browser pane, the same error message appears despite ID becoming new primary key. Oracle provider even retains previous information about Oracle PK's or is assuming the first column is PK.

[qgib]

Author Name: Belinda Baker (Belinda Baker)

---

Test scenario would be create table/view with non unique IDs in first column, set last column with unique IDs as primary key and see if Oracle message log in QGIS logs any error (especially Primary key field 'xxx' for view not unique.)