当前使用版本(必填,否则不予处理)
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
那应该怎么解决这个问题呀,着急等