Hi all,
Im using sdo_nn_distance function.
In 12c Im having proper response while in 19c the sdo_nn_distance is returning 0 for all columns.
I didn't made any data changes.
query below:
SELECT /*+ ordered use_nl(cb) index(cb idx1_city_bourder_geo_idx) */ CB.CITY_ID, SDO_NN_DISTANCE(1)
FROM CITY_BOURDER CB
WHERE SDO_NN(CB.BOUNDARY, MDSYS.SDO_GEOMETRY(2001, 4326, MDSYS.SDO_POINT_TYPE(IN_LON, IN_LAT, NULL), NULL, NULL), 'sdo_batch_size=3', 1) = 'TRUE';
Im not receiving any errors, column for sdo_nn_distance result is 0.
I have gone through documentation, I couldn't find anything related Spatial ,changes https://docs.oracle.com/en/database/oracle/oracle-database/19/spatl/spatial-and-graph-developers-guide.pdf.
I have spatial package only versions are different.
Using sdo_distance is solving the issue but since there is specific feature is defined (sdo_nn_distance) I would like to use it. In spatial studio I didn't came across this function is it removed?
Thank you for your supports.