Bug report #13473

oracle show 0 when asked for 'show feature count' in layer list

Added by Richard Duivenvoorde over 4 years ago. Updated over 4 years ago.

Status:Closed
Priority:Normal
Assignee:Jürgen Fischer
Category:Data Provider/Oracle
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No Copied to github as #:21520

Description

see title and screenshot

I loaded a shp file with 354 features in oracle via ogr2ogr

Loaded both the shp and the table in oracle, and in the layer manager/list asked 'Show feature count' in context menu.

As you can see it shows zero, BUT the features are ok and visible...

zero.png (86.2 KB) Richard Duivenvoorde, 2015-10-01 02:31 AM


Related issues

Related to QGIS Application - Bug report #14758: Wrong feature count for rules with geometry expression Closed 2016-05-03

History

#1 Updated by Jürgen Fischer over 4 years ago

  • Status changed from Open to Feedback

Are you using estimated metadata data and is the table analyzed? Otherwise Oracle claims that the number of rows is 0.

If

SELECT num_rows FROM all_tables WHERE owner='SOMEONE' AND table_name='SOMETABLE';

returns 0, although the table isn't empty it should change after running

ANALYZE TABLE sometable COMPUTE STATISTICS;

If you get ORA-38029 you should run

exec DBMS_STATS.UNLOCK_TABLE_STATS('SOMEUSER','SOMETABLE');

first.

#2 Updated by Giovanni Manghi over 4 years ago

  • Resolution set to invalid
  • Status changed from Feedback to Closed

closing for lack of feedback.

Also available in: Atom PDF