WallProvider 在WallVisitor处理之后会加入到LRUCache whiteLis

检测的代码

// first step, check whiteList boolean mulltiTenant = config.getTenantTablePattern() != null && config.getTenantTablePattern().length() > 0; if (!mulltiTenant) { WallCheckResult checkResult = checkWhiteAndBlackList(sql); if (checkResult != null) { checkResult.setSql(sql); return checkResult; } }

----------省略代码--------------------

WallVisitor visitor = createWallVisitor(); visitor.setSqlEndOfComment(endOfComment);

    if (statementList.size() > 0) {
        boolean lastIsHint = false;
        for (int i=0; i<statementList.size(); i++) {
            SQLStatement stmt = statementList.get(i);
            if ((i == 0 || lastIsHint) && stmt instanceof MySqlHintStatement) {
                lastIsHint = true;
                continue;
            }
            try {
                stmt.accept(visitor);
            } catch (ParserException e) {
                violations.add(new SyntaxErrorViolation(e, sql));
            }
        }
    }

------------------省略代码----------------------- 下面的代码会将执行的sql加入到一个白名单缓存中，加入到sql在第二次处理时不会再经过WallVisitor的处理,缓存进去的sql也不是经过WallVisitor处理后的sql，所以在配置了最大查询条数（selectLimit）时，就不生效了

WallSqlStat sqlStat = null; if (violations.size() > 0) { violationCount.incrementAndGet();

        if ((!updateCheckHandlerEnable) && sql.length() < MAX_SQL_LENGTH) {
            sqlStat = addBlackSql(sql, tableStat, context.getFunctionStats(), violations, syntaxError);
        }
    } else {
        if ((!updateCheckHandlerEnable) && sql.length() < MAX_SQL_LENGTH) {
            sqlStat = addWhiteSql(sql, tableStat, context.getFunctionStats(), syntaxError);
        }
    }

原提问者GitHub用户vinartis