search

jdeolive / geodb

Spatial database bindings for Java.
MIT License
67 stars 25 forks source link

Unable to create multiple spatial indexes per table #11

Open jdeolive opened 12 years ago

jdeolive commented 12 years ago

The issue is the name clash in the name of the spatial index table... _HATBOX

create table spatial (id INT AUTO_INCREMENT PRIMARY KEY);
call AddGeometryColumn(NULL, 'SPATIAL', 'FOO', 4326, 'POINT', 2);
call AddGeometryColumn(NULL, 'SPATIAL', 'BAR', 4326, 'POLYGON', 2);
call CreateSpatialIndex(NULL, 'SPATIAL', 'FOO', 4326);
call CreateSpatialIndex(NULL, 'SPATIAL', 'BAR', 4326);