Bug report #13473
oracle show 0 when asked for 'show feature count' in layer list
|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|
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...
#1 Updated by Jürgen Fischer about 7 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.
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