Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#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


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 Changed 6 years ago by lutra

  • Cc a.furieri@… added

comment:2 Changed 6 years ago by esseffe

  • Resolution set to invalid
  • Status changed from new to closed

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:

comment:3 Changed 6 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.