https://userapps.support.sap.com/sap/support/knowledge/en/2112928
2112928 - SAP IQ: A query with a column having UNIQUE index and duplicate values, returns a wrong...
A query with a column having UNIQUE index and duplicate values, may return a wrong result set when a hash join plan is chosen.