In mailmerge based on query containing a LIST() column, the LIST column is not visible

[parsely]

A complex query has been stripped down to:

SELECT LIST( "text" ) "all_text", "item" 
    FROM "tbltest" GROUP BY "tbltest"."item"

In a mailmerge document, the “all_text” field is incorporated in the middle of a line of text.
The result is that in the merged document the field is not visible, in fact the whole line that contained the field is not present.
This behaviour is upon a manual merge to file - one document (and also by macro that works OK in other cases)

Is this the expected behaviour? What can be done about it?

firefox embedded and

Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-GB (nl_NL.UTF-8); UI: en-GB
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.1
Calc: threaded

[RobertG]

Change the code by changing the listed text to VARCHAR:

SELECT CAST(LIST( "text" ) AS VARCHAR(1000)) "all_text", "item" 
    FROM "tbltest" GROUP BY "tbltest"."item"