inconsistent implementation error in SQL query

[Former Member]

Hi Experts,

Please check following query. It was running properly in SPS10. Recently, we have upgrated to SPS11. Now, I am not able to execute below mentioned query.

I am using single (same table) for fuzzy search.

select * from "SCHEMA_NAME"."TBL1" A where (
SELECT SCORE() AS SCORE FROM "SCHEMA_NAME"."TBL1" B
WHERE CONTAINS(B."EMP_NAME",'John', FUZZY(0.8))
and A."EMP_ID"=B."EMP_ID" ) >0.7

I am getting following error.

SAP DBTech JDBC: [2048]: column store error: search table error:  [23056] Internal error during join: inconsistent implementation

[Former Member]

Which SAP HANA 1.00 SPS 11 Revision do you use?

[Former Member]

Hi,

We are using 1.00.112.02.1459851171 (fa/newdb100_rel)

[Former Member]

I found one bug for Rev. 110, but not for 112.02. As this seems to be a clear regression, I would suggest you to open a SAP incident for clarification.