Use of SDO_GEOM.SDO_INTERSECTION in INSERT AS SELECT in 11.2.0.4 gives incorrect result
(Doc ID 2041414.1)
Last updated on FEBRUARY 07, 2019
Applies to:
Oracle Spatial and Graph - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]Information in this document applies to any platform.
Symptoms
The use of sdo_geom.sdo_intersection in a select to populate a table in
11.2.0.4 is not working properly. Example sql:
insert into
test
select /*+ ORDERED NOPARALLEL */ l.LEASE_NUMBER, L.TRACT_NUMBER, U.UNIT_ID,
(sdo_geom.sdo_area(sdo_geom.sdo_intersection(l.shape,u.shape,
0.05),0.05)/sdo_geom.sdo_area(l.shape,0.05)*100) pct_area_in_unit,
sdo_geom.sdo_intersection(l.shape,u.shape, 0.05) shape
from <table1> u, <table2> l
where sdo_anyinteract(l.shape, u.shape) = 'TRUE'
AND (sdo_geom.sdo_area(sdo_geom.sdo_intersection(l.shape,u.shape,
0.05),0.05)/sdo_geom.sdo_area(l.shape,0.05)*100) > 0.00099;
This statement does not return an error but just inserts NULL instead of calculated polygon.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |