Skip to Content
0
Sep 24, 2018 at 08:06 AM

Hana and 'is distinct from' operator

541 Views

Hello!

In PostgreSQL and MySQL exists 'is distinct from' operator (SQL:2003).
Is it possible to achieve the same functionality in SAP Hana?
It is very important for our usage, we have a large number of such queries.

Example: CONN_ID column is defined as nullable integer. I have to select rows where CONN_ID has changed (also to NULL or from NULL).

SELECT
   A."MATNR" as a_material,
   B."MATNR" as b_material,
   A."CONN_ID" as old_id,
   B."CONN_ID" as new_id
  FROM "MATERIAL_CONN_VIEW" A full outer join "MATERIAL_CONN_LATEST" B on (A."MATNR" = B."MATNR")
  WHERE
    (A."CONN_ID" != B."CONN_ID");  /* <=> or 'is distinct from' ? */