为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:win11
【CPU】:x86
【问题描述】*:
处理大字段时,使用LISTAGG2函数报字符串截断
简化SQL:SELECT LISTAGG2("TASK_COMPLETION"."RESULT", ',')
FROM "TASK_COMPLETION"
WHERE ("PROJECT_ID" = 16 )
报错信息:-6108: 字符串截断
该字段数据长度为
SELECT LENGTHB("RESULT") FROM "TASK_COMPLETION" WHERE "TASK_ID" = 105; 结果为120990
SELECT RESULT FROM "TASK_COMPLETION"
WHERE ("PROJECT_ID" = 16 ) 结果为,(已删除部分字符)
[{"id":"PbJQ7HG3yy","type":"brushlabels","value":{"rle":[0,7,133,160,57,27,255,255,255,0,255,255,224,31,255,252,3,214,247,128,70,171,28,204,119,184,175,2,58,152,204,248,56,24,4,100,248,93,2,55,104,250,178,31,252,126,81,229,225,124,8,239,35,166,142,62,55,152,216,163,71,140,214,49,238,13,110,1,26,100,124,122,175,254,63,24,246,163,194,142,166,56,232,220,163,87,140,246,50,104,195,248,52,24,4,105,177,197,237,255,248,248,163,199,142,210,57,232,225,35,112,141,102,52,24,203,35,21,224,200,224,17,139,199,13,29,156,123,220,4,79,254,62,136,244,112,222,4,118,177,196,198,201,25,220,98,188,23,236,2,49,232,207,227,64,141,98,62,254,2,175,255,31,140,120,145,207,198,243,26,47,5,223,0,141,102,61,94,3,23,255,31,76,122,113,206,198,181,25,127,5,175,0,140,130,54,168,235,248,13,127,252,121,113,207,198,229,26,12,97,252,20,44,2,48,136,205,35,8,205,96,17,159,70,251,28,156,118,209,224,102,191,248,251,35,156,140,147,19,128,70,113,26,84,110,81,202,71,113,192,69,255,227,247,191,129,29,236,118,17,209,199,45,28,76,111,145,174,198,115,24,183,4,211,0,142,66,223,252,120,241,196,198,155,24,118,79,0,140,106,55,232,248,243,31,252,116,24,78,2,52,28,198,1,24,164,101,113,160,70,177,27,124,112,113,206,71,103,30,52,124,17,251,240,16,191,248,240,99,130,141,10,48,142,9,118,1,27,14,43,255,143,150,58,152,211,112,184,4,97,17,167,70,241,28,4,112,177,211,71,127,30,38,103,255,142,198,51,157,86,1,24,132,101,145,163,198,203,27,252,114,241,215,71,133,30,220,126,91,207,254,60,104,220,99,64,140,159,130,85,128,71,217,141,255,227,232,142,50,50,105,192,35,41,143,135,59,255,199,181,25,102,227,0,140,126,51,88,209,227,98,141,230,56,248,233,163,187,143,78,62,173,175,255,31,164,116,145,161,112,73,176,8,207,178,63,252,121,177,181,199,151,156,224,17,154,198,175,27,133,184,8,235,35,211,143,179,45,255,198,205,193,192,192,35,35,141,186,58,184,247,114,63,252,115,241,147,240,114,112,8,207,227,107,183,1,28,124,120,241,241,71,255,31,108,122,145,215,70,189,24,143,247,135,0],"format":"rle","brushlabels":["Airplane"]},"origin":"manual","to_name":"image","from_name":"tag","image_rotation":0,"original_width":474,"original_height":260}]
建议升级到8.1.4.170或更高版本后,使用 listagg2在尝试

使用LISTAGG2 用法一致,返回类型为clob
LISTAGG返回为varchar有长度限制