[mapserver-users] Mapserver 7.0.6 from MS4W does not find spatial index from Spatialite

Fri Aug 25 05:32:14 PDT 2017

Hi,

I have a Spatialite database which has a valid and consistent spatial index if I ask spatialite-gui to check it. However Mapserver 7.0.6 from MS4W 3.2.2 does not find it.

Layer is defined as

CONNECTIONTYPE OGR
DEBUG 5
CONNECTION "\ms4w_data\apps\wms-wfs.sqlite"
DATA "select * from states"

[Fri Aug 25 15:17:41 2017].225000 OGROPen(\ms4w_data\apps\wms-wfs.sqlite)
[Fri Aug 25 15:17:41 2017].235000 msConnPoolRegister(states,\ms4w_data\apps\wms-wfs.sqlite,00A0F2D0)
[Fri Aug 25 15:17:41 2017].236000 msOGRFileOpen(): Layer select * from states has spatial index disabled
[Fri Aug 25 15:17:41 2017].236000 msOGRFileWhichShapes: SQL = select * from states WHERE  MbrIntersects("Geometry", BuildMbr(-110.556532,27.919128,-78.556643,44.907341)).

I wonder what is the check that is performed. Obviously not either of these two:

select spatial_index_enabled from geometry_columns where f_table_name='states';
returns 1
select checkspatialindex('states','geometry');
returns 1

-Jukka Rahkonen-

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170825/9cddc82b/attachment.htm>