In 7.2.3 and 7.2.4, I can write query with CONCAT. 7.2.2 doesn't seem to support it. However, my need for this function comes from the bad csv format returned from the REST API.
If payload is included in the query, and I request the search results in application/csv, the field is not quoted, and there are commas in the payload. This breaks the csv format. With 7.2.3 and 7.2.4, I can do "CONCAT('"', utf8(payload), '"')" to add a pair of quotes and make the csv format valid. Since CONCAT is not in 7.2.2, I can not use this solution.
Is there a way to do something similar to CONCAT in 7.2.2? If not is there a way to get the result in the correct CSV format (e. g. add quotes to string fields in the result)?