Bug report #12774
Attribute table only show first 99 rows from SQL Server views
|Affected QGIS version:||2.8.1||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||not reproducable|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||20873|
Whenever I add a non spatial SQL Server layer from a view and check the attribute table there are only 99 rows returned. I have tried this on several views and on a local and server side DB with the same results.
#3 Updated by Giovanni Manghi over 5 years ago
- Status changed from Open to Feedback
Jason Moore wrote:
Found that views return all rows if the setting Options->Data Sources->Attribute table row cache is set to anything but "All". When set to all attribute table returns 99 or 100 rows.
do you mean "attribute table behavior" or "attribute table row cache"? does it happens for other datasources?