Create Spatial Index for Shapefiles with Space in Name

[Geoheber]

Problem in Function OGRShapeDataSource::ExecuteSQL

If an OGRLayer contains a shapefile which has been loaded out of a file which name has a space in its filename, the name of this layer contains the space, too. If one want to create a spatial index by calling

m_poDS->ExecuteSQL("CREATE SPATIAL INDEX ON sweden rivers",NULL,NULL);

for example, the call fails because in ExecuteSQL the string is tokenized by the space sign, so the name it tries to look up is only "sweden". It doesn't find this layer and fails. One cannot quote the name such as

m_poDS->ExecuteSQL("CREATE SPATIAL INDEX ON 'sweden rivers'",NULL,NULL);

because this isn't handled in GetLayerByName. So, there isn't any possibility if one have only an OGRLayer without further infos to create a spatial index on it.

Workaround: If one knows its an OGRShapeLayer, one can call CreateSpatialIndex() directly.

[Geoheber]

Now I found its realizable by double-quotes, so it is not a bug!

m_poDS->ExecuteSQL("CREATE SPATIAL INDEX ON \"sweden rivers\"",NULL,NULL);