Symptom
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.
Read more...
Environment
- SAP IQ16.1 SP04
- SAP IQ16.1 SP05
Product
SAP IQ 16.1
Keywords
NULL , Not equal , incorrect , CR826490, 826490 , , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.