My-Sql Group concat with concat

Question

我正在使用下面的查询来获取数据，但是我得到了截断的结果

SELECT group_concat(concat(`cl`.`payment_info`, '<=>', `cl`.`total_amount`) SEPARATOR '<==>') AS payment_info

Array
(
    [0] => Array
        (
            [payment_info] => [{"payment_date":"12\/12\/2016","payment_percentage":"30.00","payment_status"
:"Paid"},{"payment_date":"13\/12\/2016","payment_percentage":"20.00","payment_status":"Unpaid"},{"payment_date"
:"","payment_percentage":"","payment_status":"Unpaid"},{"payment_date":"","payment_percentage":"","payment_status"
:"Unpaid"},{"payment_date":"","payment_percentage":"","payment_status":"Unpaid"}]<=>0.00<==>[{"payment_date"
:"12\/12\/2016","payment_percentage":"50.00","payment_status":"Paid"},{"payment_date":"13\/12\/2016"
,"payment_percentage":"40.00","payment_status":"Unpaid"},{"payment_date":"","payment_percentage":"","payment_status"
:"Unpaid"},{"payment_date":"","payment_percentage":"","payment_status":"Unpaid"},{"payment_date":"","payment_percentage"
:"","payment_status":"Unpaid"}]<=>548.43<==>[{"payment_date":"12\/12\/2016","payment_percentage":"30
.00","payment_status":"Paid"},{"payment_date":"13\/12\/2016","payment_percentage":"20.00","payment_status"
:"Unpaid"},{"payment_date":"","payment_percentage":"","payment_status":"
        )

)

当数据量很大的时候，我面临着这个问题，否则这个查询就能正常工作，请告诉我哪里出了错。

在付款信息中，json格式的数据被保存，而在金额中，金额被保存。payment_info数据类型为文本

Answer 1

您必须设置group_concat_max_len.默认长度为1024个字符。请参阅手册信息

group_concat_max_len

Description: Maximum length in bytes of the returned result for a GROUP_CONCAT() function.
Commandline: --group-concat-max-len=#
Scope: Global, Session
Dynamic: Yes
Data Type: numeric
Default Value: 1024
Range - 32-bit: 4 to 4294967295
Range - 64-bit: 4 to 18446744073709547520