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-
_______________________________________________
mapserver-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-users
