[teiid-issues] [JBoss JIRA] (TEIID-2384) Managing Spatial Data Types
[
https://issues.jboss.org/browse/TEIID-2384?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2384:
---------------------------------------
oracle and others seem to use null rather than 0 for an unknown srid.
So we may want to use an Integer field on the GeometryType and update the FROM Text/Binary
methods appropriately.
Checked with postgis and they mark the functions as strict/null on null, so we'll keep
the current behavior. It is a minor TODO to make the pushdown for mysql/oracle match
this.
Added st_geomfromwkb as the dominant function as it matches the spec with an alias to
st_geomfrombinary (why they have the inconsistency isn't clear).
add get/set srid functions
This has also been added. The set srid function will create a new geometry type value and
reuse the existing blob reference.
Managing Spatial Data Types
---------------------------
Key: TEIID-2384
URL: https://issues.jboss.org/browse/TEIID-2384
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 8.2
Reporter: luca gioppo
Assignee: Steven Hawkins
Labels: spatial, types
Fix For: 8.10
It would be useful to be able to consume data from spatial database exposing the VDB as a
spatial database to other application (imagine geoserver).
TEIID could be strategic for merging georeferenced data and make it available to those
systems.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)