Hi, we are currently testing Informix Server 15.0.0.2.
On a fresh initialized DB (with oninit -i...) the group_concat() aggregate function is now built in. Which would be great.
Additional info: In Informix 14 we had our own implementation of group_concat() based on community/documentation suggestions which collides with the now built in on dbexport / dbimport. However, this allone would be no big deal to come around.
But the sample query (again: fresh Informix 15.0.0.2 DB with oninit -i...)
select procname[1,2], group_concat(procname) from sysprocedures group by 1;
against any database (sysmaster, sysadmin) raises the error
9406: Cannot resolve support function for user-defined aggregate group_concat(llvc_gc_init).
We found this link https://www.ibm.com/mysupport/s/defect/aCIKe000000Xq4pOAC/dt421548?language=no which directs to Known Issue DT421548. But the issue was closed as User Error and the problem conclusion cites
This feature is undocumented at this time. A future documentation update will include details necessary for proper use of the feature.
But we could not find more documentation.
What would be the best way to come around this and to make group_concat() working?
------------------------------
Wilhelm Seyerl
------------------------------