#2178 closed bug (invalid)
Spatialite VIEWs give ERROR in attribute table
Reported by: | Barryrowlingson | Owned by: | nobody |
---|---|---|---|
Priority: | major: does not work as expected | Milestone: | Version 1.4.0 |
Component: | Data Provider | Version: | Trunk |
Keywords: | Cc: | a.furieri@… | |
Must Fix for Release: | No | Platform: | Linux |
Platform Version: | Awaiting user input: | no |
Description
I have a spatialite DB with tables, they work fine in Qgis.
If I create a view:
CREATE VIEW vmapdata AS SELECT * from mapdata
and add a row to geometry_columns (identical to the row for table mapdata) then I can load the view as a layer in Qgis, and it plots it. I can use the query tool and get attribute values in the popup dialog but if I get the whole attribute table it is full of "ERROR" values.
Change History (3)
comment:1 by , 14 years ago
Cc: | added |
---|
comment:2 by , 14 years ago
Resolution: | → invalid |
---|---|
Status: | new → closed |
comment:3 by , 14 years ago
If I do that to create my view, I don't see the view in qgis.
Qgis seems to ignore the "GIS layer Authorization" options set in Spatial-gui and shows anything with a listing in geometry_columns. It doesn't show the spatial view I just created according to the guidelines, I guess because that has its geometry specified in views_geometry_columns.
This is with 1.3.0-Mimas - has the spatialite provider been updated to fix this?
This one is not at all a bug: it's an attempt to force
spatialite beyond it's specific architectural limits.
Spatial Views are fully supported in spatialite-2.4.0,
but you are required to follow the guide-lines you can
find here:
http://www.gaia-gis.it/spatialite-2.4.0/Using-Views-Basic.pdf
http://www.gaia-gis.it/spatialite-2.4.0/Using-Views-Advanced.pdf