上传者: 19749625
|
上传时间: 2024-08-12 11:37:51
|
文件大小: 854KB
|
文件类型: JAR
如下sql,JSON_OBJECT函数中存在CAST函数,随后报出ParseException问题!
SELECT JSON_ARRAYAGG(obj) FROM (SELECT trt.relevance_id,JSON_OBJECT('id',CAST(trt.id AS CHAR),'taskName',trt.task_name,'openStatus',trt.open_status,'taskSort',trt.task_sort) as obj FROM tb_review_task trt ORDER BY trt.task_sort ASC)
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "SELECT"
at line 18, column 10.
Was expecting one of:
"!"
"("
"NOT"