Skip to Content
0
Apr 02, 2019 at 04:36 AM

Bug report - SAP HANA Date Type for NULL value in SQL statement

3310 Views

Version: SAP HANA Version (fa/hana1sp12)

Bug:
There have one record with DATE datatype column, and the value is NULL in this column. Then system judge it is as valid value instead of invalid value when I command SQL statement with filter DATE IS NULL condition.

For example:
###[It should be correct, but system think it is incorrect.]

select RELEASE_DATE from table WHERE ORDER_NUMBER=number and release_date is null;


###[It should be incorrect, but system think it is correct.]

--
select RELEASE_DATE from table WHERE ORDER_NUMBER=number and release_date = '00000000';


--
select RELEASE_DATE from table WHERE ORDER_NUMBER=number' and release_date = '';

--
select RELEASE_DATE from table WHERE ORDER_NUMBER=number and release_date is not null;

Attachments

6vdwk.png (4.1 kB)
cqksb.png (4.5 kB)
psj2l.png (4.5 kB)
hmpeb.png (4.5 kB)
uqumn.png (4.4 kB)