2757808 - SAP IQ - using SUBSTR function with '0' start parameter returns 0 row result when using count(*) function

After upgrading IQ server from 15.4 to 16.0, using SUBSTR function with '0' start parameter returns 0 row result when using count(*) function.

SELECT count(*)
FROM TAB001
WHERE TRIM(SUBSTR(COL001,0, locate(COL001,'-',0)-1 )) = TRIM(CAST(2 AS VARCHAR(5)))

    count()
-----------
          0
(1 rows)
Execution time: 0.11 seconds

If specifying '*' instead of 'count(*)', correct result is returned.

Returning rows:

select *
FROM TAB001
WHERE TRIM(SUBSTR(COL001,0, locate(COL001,'-',0)-1 )) = TRIM(CAST(2 AS VARCHAR(5)))
...
(20228 rows)

• SAP IQ 16.0 SP11 PL11

"SUBSTR"; "814618"; "CR814618"; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem