注册

dm8查询出来的列变成了大写

DM_281173 2024/12/20 317 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:"SELECT "account" AS account, " +
"WM_CONCAT( DISTINCT ORG_NAME ) AS orgName, " +
"WM_CONCAT( DISTINCT ROLE ) AS role, " +
"WM_CONCAT( DISTINCT DEPARTMENT ) AS department, " +
"WM_CONCAT( DISTINCT MAIN_JOB ) AS mainJob, " +
"WM_CONCAT( DISTINCT RESULT_DESC ) AS resultDesc, " +
"MAX(create_time) AS createTime " +
"FROM " +
"user_center_exception_event_log " +
"WHERE 1=1" +
" AND create_time BETWEEN TO_DATE(?2,'YYYY-MM-DD HH24:MI:SS') " +
" AND TO_DATE(?3,'YYYY-MM-DD HH24:MI:SS') " +
" AND IF(IFNULL(?1,'') !='', name like CONCAT(?1,'%'), 1=1 )" + //IF(IFNULL(?1,'') !='', org_id=?1, 1=1)
" AND result <> 1 " +
" AND IF(?4 is not null, tenant_id=?4 , 1=1) " +
"GROUP BY account " +
"HAVING COUNT(DISTINCT result_desc) > 1 ORDER BY createTime Desc" 返回的结果中 account 变成了大写 image.png

回答 0
暂无回答
扫一扫
联系客服