In Spatial Developer's Guide to Oracle 21 c:
Spatial Developer's Guide (0 Bytes)there is an example of a query with FROM_GEOHASH function:
SELECT sdo_cs.from_GeoHash('u4pruydqqvj', 4326) FROM DUAL;
SDO_GEOMETRY(2002, 4326, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(10.407439, 57.64911, 10.4074404, 57.6491113))
The geometry that query returns is an invalid one, i.e. the query
select SDO_GEOMETRY(2002, 4326, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(10.407439, 57.64911, 10.4074404, 57.6491113)).st_isvalid() from dual;
returns 0.
It has 2002 in its SDO_GTYPE field, as if it was a LINE, but it also has (1, 1003, 3) in SDO_ELEM_INFO as if it was an optimized rectangle (if SDO_GTYPE was 2003). Is this a known problem? Shouldn't it be a point geometry? I did similar question in my database and the problem is the same (so that example in documentation shows the real situation).
Thanks for any help.