Encountered unexpected token: “＞=“ ＜OP_GREATERTHANEQUALS＞ at line 17, column 40. Was expecting

问题：

sql在navicat中就可以正常执行，在程序中就报错

Encountered unexpected token: ">=" <OP_GREATERTHANEQUALS> at line 17, column 40. Was expecting one of: "&" ")" "::" "<<" ">>" "COLLATE" "[" "^" "|"

Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT
        yghmdbid,count(*) sl,ygmc as gkmc,DATE_FORMAT(jcgsj,'%Y-%m-%d') as time
        FROM
        jcggz
        WHERE
        yghmdbid != ''
         
            AND jcgsj >= ?
         
         
            AND jcgsj <= ?
         
         
            and ((ship_length BETWEEN 12 AND 100))
         
         
            and ((750 > ship_tot_power >= 450) OR (3000 > ship_tot_power >= 750))
         
         
            and ((ship_tot_ton BETWEEN 0 AND 50) OR (ship_tot_ton BETWEEN 100 AND 200))
         
         
        GROUP BY yghmdbid
        ORDER BY sl 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:68)
	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.$Proxy323.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
	... 119 common frames omitted
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: ">=" <OP_GREATERTHANEQUALS>
    at line 17, column 40.

Was expecting one of:

    "&"
    ")"
    "::"
    "<<"
    ">>"
    "COLLATE"
    "["
    "^"
    "|"

	at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
	at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:9750)
	at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:9696)
	at net.sf.jsqlparser.parser.CCJSqlParser.XorExpression(CCJSqlPar

 解决办法：

在mapper层方法上加注解即可

@InterceptorIgnore(tenantLine = "true")