Symptom
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)
Read more...
Environment
-
SAP IQ 16.0 SP11 PL11
Product
Keywords
"SUBSTR"; "814618"; "CR814618"; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.