SAP Knowledge Base Article - Preview

2748481 - LIST function result is wrong with IQ 16.1 -- SAP IQ

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.