当前使用版本(必填,否则不予处理)

3.5.1

该问题是如何引起的?(确定最新版也有问题再提!!!)

mapper sql动态拼接 ,提示无法解析sql, sql单独拉出来,再控制台是可以执行,是什么原因呢

重现步骤(如果有就写完整)

报错信息

com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: select o.* from t_trade_order o where o.deleted = 0 and o.id in (select order_id from t_trade_order_line ol left join t_item_product p on ol.product_id = p.id and p.deleted = 0 left join t_item_sku s on ol.sku_id = s.id and s.deleted = 0 where ol.deleted = 0

                                          and JSON_CONTAINS(ol.sku_specs_json,JSON_OBJECT('specsOptionName',?))

                                       )









            order by id desc
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
at com.baomidou.mybatisplus.extension.plugins.inner.TenantLineInnerInterceptor.beforeQuery(TenantLineInnerInterceptor.java:65)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy318.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
... 81 common frames omitted

Comment From: miemieYaho

jsqlparser 这个组件不能解析

Comment From: kagelasi

那应该怎么解决这个问题呀,着急等