SAP Knowledge Base Article - Preview

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

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.