Symptom
LIST function returns wrong result in IQ 16.1, but IQ16.0 SP11.x made correct result.
* SAP IQ16.0 SP11.19
select list(ccc||'-'||myid,',' order by myid desc) from #a;
-----------------------------
ee-5,dd-4,zc-3,bb-2,ya-1
-----------------------------
* SAP IQ16.1 SP03 returned wrong result
-----------------------------
zc-3,ya-1,ee-5,dd-4,bb-2
-----------------------------
Read more...
Environment
SAP IQ16.1
Keywords
KBA , BC-SYB-IQ , Sybase IQ , 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.