为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:mysql下有一条sql如下:
SELECT
JSON_ARRAYAGG(JSON_OBJECT('value', property_name, 'locale', preferred_language)) AS property_name,
property_id
FROM
t_property_language
WHERE
is_deleted = 0
GROUP BY
property_id;
在达梦下替换为
SELECT
json_array(json_object('value', property_name, 'locale', preferred_language)) AS property_name,
property_id
FROM
t_property_language
WHERE
is_deleted = 0
group by
property_id;
执行结果
达梦不支持这查询语法,不知是否是我使用的函数不对,还是达梦没有类似的功能?
语法改写:
SELECT
'[' || LISTAGG(
'{"value": "' || property_name || '", "locale": "' || preferred_language || '"}',
','
) || ']' AS property_name,
property_id
FROM
t_property_language
WHERE
is_deleted = 0
GROUP BY
property_id;