当前使用版本(必填,否则不予处理)
3.4.3
该问题是如何引起的？(确定最新版也有问题再提!!!)
查询sql 子关联查询不通过
重现步骤(如果有就写完整)
SELECT
mi.ID,
mi.account_id,
mi.mdl_def_code,
mi.mdl_def_key,
mi.process_instance_id,
mi.service_ids,
mi.title,
mi.biz_key,
mi.biz_desc,
mi.urgent_level,
mi.is_test,
mi.source_id,
mi.data_status,
mi.urged_time,
mi.form_data,
mi.plan_start_time,
mi.plan_end_time,
mi.revision,
mi.created_by,
mi.created_time,
mi.updated_by,
mi.updated_time,
mi.is_del
FROM
mdl_instance mi
WHERE
mi.account_id = ?
AND mi.process_instance_id IN ( SELECT aht.proc_inst_id_ FROM act_hi_taskinst aht LEFT JOIN act_hi_identitylink ahi ON aht.id_ = ahi.task_id_ WHERE ahi.GROUP_ID_ IN ( ? ) )
AND mi.mdl_def_key IN ( ? )
AND mi.ID IN (
**SELECT DISTINCT ID
FROM
( SELECT ID, jsonb_array_elements ( form_data :: jsonb -> ? ) ->> 0 AS sdfjlsdf FROM mdl_instance mdinstance WHERE mdinstance.mdl_def_key IN ( ? ) ) mdl_temporary
WHERE
( mdl_temporary.sdfjlsdf :: VARCHAR LIKE CONCAT ( '%',?, '%' ) )**
)
问题出现 加粗的sql
报错信息
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "IN" "IN" at line 104, column 23.
Was expecting one of:
"&"
"&&"
"::"
";"
"<<"
">>"
"AND"
"COLLATE"
"CONNECT"
"EXCEPT"
"FOR"
"GROUP"
"HAVING"
"INTERSECT"
"MINUS"
"ORDER"
"START"
"UNION"
"["
"^"
"|"
<EOF>
Comment From: qmdx
请反馈至 https://github.com/JSQLParser/JSqlParser 如果 mp 分页无法通过解析，page 关闭优化