Bug report #15241

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

Added by Andreas Neumann about 8 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:worksforme
Crashes QGIS or corrupts data:No Copied to github as #:23177

Description

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 - DDL statement for table creation (4.97 KB) Andreas Neumann, 2016-07-08 05:26 AM

oracle_db_manager_null_values.png - Screenshot with QGIS main canvas on left and db manager with NULL values on the right (374 KB) Andreas Neumann, 2016-07-08 05:26 AM

History

#1 Updated by Giovanni Manghi about 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Giovanni Manghi over 5 years ago

  • Status changed from Open to Feedback

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

#3 Updated by Andreas Neumann over 5 years ago

  • Resolution set to worksforme
  • Status changed from Feedback to Closed
  • Description updated (diff)

seems to work fine now

Also available in: Atom PDF