Re: Setting group_concat_max_len
Well, you could calculate the exact size needed:
SELECT @gcml :=
SUM(LENGTH( XML )) -- The main part
+ COUNT(*)-1 -- the commas
FROM ...
SET @group_concat_max_len = @gcml;
SELECT GROUP_CONCAT(XML) ...
Subject
Views
Written By
Posted
18769
May 25, 2010 04:00PM
3511
May 28, 2010 07:18PM
2991
May 29, 2010 10:33PM
3959
May 30, 2010 04:48PM
Re: Setting group_concat_max_len
2352
May 30, 2010 06:43PM
2231
June 04, 2010 06:27AM
2023
June 04, 2010 07:10AM
3852
June 04, 2010 10:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.