MyBatis-Plus 如果使用TenantLineInnerInterceptor插件,导致存储过程语法报错

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

3.4.0

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

在拦截器里配置了TenantLineInnerInterceptor,

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

使用mapper里调用存储过程, @Select("{call CW_GL_JE_DETAIL_POST_BJ_NW(#{ov_retcode,mode=OUT,jdbcType=NUMERIC},#{ov_errmsg,mode=OUT,jdbcType=VARCHAR})}") @Options(statementType = StatementType.CALLABLE) void callfinanceDetailPost(ProcResult procResult);

报错信息

CW_GL_JE_DETAIL_POST_BJ_NW( ?, ? ) }

Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: {

    call CW_GL_JE_DETAIL_POST_BJ_NW(
    ?,
    ?
    )
    }
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 25 more

Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: { call CW_GL_JE_DETAIL_POST_BJ_NW( ?, ? ) } at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39) at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:35) at com.baomidou.mybatisplus.extension.plugins.inner.TenantLineInnerInterceptor.beforeQuery(TenantLineInnerInterceptor.java:69) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:61) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy289.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ... 32 more Caused by: net.sf.jsqlparser.JSQLParserException at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:65) at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:40) at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:32) ... 37 more Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "{" "{" at line 1, column 1.

Was expecting one of:

"CALL"
"COMMENT"
"COMMIT"
"DECLARE"
"DELETE"
"DESCRIBE"
"DROP"
"EXEC"
"EXECUTE"
"EXPLAIN"
"GRANT"
"INSERT"
"MERGE"
"SET"
"SHOW"
"TRUNCATE"
"UPDATE"
"UPSERT"
"USE"
"VALUES"
"WITH"

at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:25031)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:24875)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:244)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:81)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
... 39 more

发现拦截在了com.baomidou.mybatisplus.extension.plugins.inner.TenantLineInnerInterceptor.beforeQuery(TenantLineInnerInterceptor.java:69) 这一行,还请排除掉存储过程 比如 if (ms.getStatementType() == StatementType.CALLABLE) { log.info("类型为存储过程,返回"); return; }

Comment From: miemieYaho

文档有注解用

Comment From: xiaohan815

请问文档哪里写了呢?我这个是多租户的插件与存储过程不兼容导致的

Comment From: miemieYaho

插件主体里