Ticket #2178 (closed bug: invalid)

Opened 3 years ago

Last modified 3 years ago

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@…
Platform Version: Platform: Linux
Must Fix for Release: No 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

Changed 3 years ago by lutra

  • cc a.furieri@… added

Changed 3 years ago by esseffe

  • status changed from new to closed
  • resolution set to invalid

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

Changed 3 years ago by Barryrowlingson

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?

Note: See TracTickets for help on using tickets.