May 07, 2018 at 10:59 AM

Error while executing ST_COVERS in sql Hana SPS02

99 Views

HI

The below query fails in with error

Could not execute 'select * from "sap.ain.metaData::InstallationLocation.Address" where NEW ST_Polygon('POLYGON ...' in 296 ms 842 µs . SAP DBTech JDBC: [2048]: column store error: search table error: [6879] A spatial error occurred in the evaluator;object=NEO_AINCOMMITSTAGE::AIN_DEV:sap.ain.metaData::InstallationLocation.Addressen

Query

select * from "sap.ain.metaData::InstallationLocation.Address" where NEW ST_Polygon('POLYGON ((75.7232666015625 13.221229745578954, 75.27008056640625 12.71536762877211, 76.1846923828125 12.093038580274138, 76.61865234374999 13.007233869059881, 75.7232666015625 13.221229745578954))').ST_COVERS("Geometry") = 1;

The field Geometry is of type ST_GEOMETRY.

The version of hana is 2.00.023.00.1513691289 (fa/hana2sp02).

Could you please help.

Thank you

Regards

Vidhya