2594965 - In SAP IQ 16.1, the load failed with conversion error when using NULL mask

• Upgrade from SAP IQ 16.0 SP11 to SAP IQ 16.1.
• Load command fail with conversion error when the command contain NULL mask and masking value in the data file contain spaces.
  
  For example:
  
  LOAD TABLE test_tabe(col1 null('NULL', 'na') ,col2 null('na'))
  from  '/tmp/mydata.dat'
  delimited by '|' ROW delimited by '\n'
  QUOTES OFF ESCAPES OFF
  FORMAT BCP MESSAGE LOG '/tmp/mydata_msg.log'
  ROW LOG '/tmp/mydata_row.log';
  
  
• The following error reported:
• For a float data type:
  Cannot convert na  to Unknown TypeID (10)(16,8) (column col1)
  SQLCODE=-157, ODBC 3 State="07006"
• For a tinyint data type:
  Cannot convert na         to tinyint(3) (column col2)
  SQLCODE=-157, ODBC 3 State="07006"

SAP IQ 16.1

CR813485, NULL, , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed