3204163 - Is it correct handling of null values in select -- SAP IQ

A specific query returns empty row when NULL value is involved.

   > Create table #test ( deal_name varchar(10) NOT NULL, tranche_name varchar(10) NOT NULL, tranche_type varchar(10) NULL )
   > Insert into #test values ( 'abc','*',NULL )
   > Select * from #test where tranche_type !='ABC'

       => (0 rows)

Above Select query doesn't return any row, but it's required a verification whether this behavior is correct or not.

• SAP IQ16.1 SP04
• SAP IQ16.1 SP05

NULL , Not equal , incorrect , CR826490, 826490 , , KBA , BC-SYB-IQ , Sybase IQ , Problem