2540796 - SUBSTR fires invalid parameter 3 (-1) when involved in joins - SAP IQ

SUBSTRING function returns the error below when it is involved in joins.

The same SUBSTRING runs successfully on a single table with the same data.

select dp_id
from T1 , T2 , T3 , T4
where
      substring(T1.dp_id,1,charindex('.', T1.dp_id)-1) = T2.olas_id
      and T3.file_id = T1.dp_id
      and T4.file_id = T1.dp_id
      and T4.ingestion_date between '2017-03-03 19:39:13.626' and '2017-06-30 16:23:52.630'

Function 'SUBSTR' has invalid parameter '3' ('-1')
SQLCODE=-1090, ODBC 3 State="08004"
Line 1, column 1

SAP IQ 16.0 SP 11 PL 11

CR#811011 ;  CR811011 ; 811011 ; SUBSTR ; SQLCODE=-1090 ; -1090 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed