SDE.ST_M() returns negative infinity

143
0
02-18-2022 02:19 PM
Bud
by
Notable Contributor

ArcMap & Enterprise 10.7.1 — Oracle 18c SDE.ST_GEOMETRY — SQL Developer 18:


I have an SDE.ST_GEOMETRY polyline FC that is M-enabled:

 

Bud_1-1645222454887.png


In an SQL client like SQL Developer, I can query for the M-value of the endpoint of the line:

select
    sde.st_m(sde.st_endpoint(shape))
from
    my_fc

Bud_2-1645222512963.png


The result of that query is -Infinity.  I didn't know that was possible and I wouldn't have thought to account for it when querying for possible values.


Question:

Is that behavior expected from ST_GEOMETRY functions? If anything, I would have expected the value to be Null, not -Infinity.

0 Kudos
0 Replies