2495580 - Setting a null equal to a null on a date - SAP IQ

• Setting a null equal to a null on a datetime column causes a failure.
• For example, running the following command:

create table #sue1 (authorization_date datetime null, transaction_date datetime null)
insert #sue1 values(null, '2017-03-03')
insert #sue1 values(null,null)
update #sue1 set authorization_date =transaction_date
WHERE authorization_date IS NULL

• Returns the following error message in IQ 16.1

Could not execute statement.
DateTime is invalid (0)
-- (oslib/hos_date.cxx 55617)
SQLCODE=-1006167, ODBC 3 State="HY000"
Line 1, column 1

SAP IQ 16.1

KBA , BC-SYB-IQ , Sybase IQ , Problem