Informix 15.0.0.2: Aggregate function group_concat now built-in created but the underlying functions are not.
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
------------------------------
Try select procname[1,2], group_concat(procname,', ') from sysprocedures group by 1; The group_concat() needs a separator. ------------------------------ Vladimir Kolobrodov ------------------------------
Thank you a lot. After adding a temp SBLOBspace, we got it working! Cheers! ------------------------------ Wilhelm Seyerl ------------------------------