DB-Manager and Oracle: only <NULL> values in table preview

[qgib]

Author Name: Andreas Neumann (@andreasneumann)
Original Redmine Issue: 15241
Affected QGIS version: master
Redmine category:db_manager

---

I have a table that displays well in QGIS main canvas - both geometry and attribute table - but in the DB-Manager the attribute table only shows NULL values. The geometric preview in db manager is fine.

The primary key is on a varchar2 column - not sure if this matters. Perhaps DBmanager expects pkey on integer columns?

Attached is the table definition of the oracle table and a screenshot.

---

• hydranten_baar.sql (Andreas Neumann)
• oracle_db_manager_null_values.png (Andreas Neumann)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Please check if this issue is still valid on QGIS 3.4.5 or 3.6.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Andreas Neumann (@andreasneumann)

---

seems to work fine now

---

• resolution was changed from to worksforme
• status_id was changed from Feedback to Closed
• description was changed from I have a table that displays well in QGIS main canvas - both geometry and attribute table - but in the DB-Manager the attribute table only shows NULL values. The geometric preview in db manager is fine.

The primary key is on a varchar2 column - not sure if this matters. Perhaps DBmanager expects pkey on integer columns?

Attached is the table definition of the oracle table and a screenshot. to I have a table that displays well in QGIS main canvas - both geometry and attribute table - but in the DB-Manager the attribute table only shows NULL values. The geometric preview in db manager is fine.

The primary key is on a varchar2 column - not sure if this matters. Perhaps DBmanager expects pkey on integer columns?

Attached is the table definition of the oracle table and a screenshot.