Bug report #8730
"Only look in the layer registry", but table scan still performed
|Affected QGIS version:
|Pull Request or Patch supplied:
|Crashes QGIS or corrupts data:
|Copied to github as #:
I have "Only look in the layer registry" option activated, but when rendering the dialog to pick a layer to open I see queries sent to the backend for data in the actual tables (or views). I would expect queries to only look in layer registries instead (geometry_columns, geography_column etc).
Maybe it's my expectance being wrong, in which case there is probably a miswording of that option (it says "_only_ look...").
Reword "Only look in the layer registries" option
The wording was confusing in that real table scans can still be
performed when the srid or type in the registries are found to
be unconstrained. The real effect of the option is to hide
layers which are not in the registries.
#1 Updated by Sandro Santilli about 10 years ago
- Affected QGIS version changed from 2.0.1 to master
I confirm this still happens in current master. It's with views having SRID=0 advertised in geometry_columns.
Running the full view scan (very slow) finds a real srid of 4326. Using estimated data relief the problem a little bit.
So, to recap: "Only look in layers registry" still looks in the actual datasource. Sounds like a bug to me.