In QGIS, I have a spatialite multipolygon layer that have full objects in attribute table but do not display random ones as I scroll and pan around:
Vietnam map at zoom level 1:16000000 - some provinces missing in the northern part creating holes.
Scroll mouse wheel to zoom closer one level (1:8000000). The northern most province in the view is missing.
Zoom closer to the southern part.
Moving one step closer. The large number of missing polygons make it hard to mark all of them with circles.
When I pan around, the polygons may re-appear at some places and disappear at some others. If I export this layer as shapefile and add to the map, there is no missing polygon at all.
Does anyone know how to fix this?