We would like to be able to support geometry types with open street map data, for example:
ALTER TABLE osm_points_of_interest
ADD COLUMN points_of_interest GEOMETRY GENERATED ALWAYS AS (ST_GeomFromText(geometry_wkt, 4326, 'axis-order=long-lat')) STORED NOT NULL SRID 4326,
ADD SPATIAL INDEX idx_points_of_interest (points_of_interest);
We would like to be able to support geometry types with open street map data, for example:
Currently this fails in parsing:
CREATE TABLEwith aSPATIAL INDEXorALTER TABLE .. ADD SPATIAL INDEXis not currently supported by this PR (butCREATE SPATIAL INDEXworks)