MySQL trim函数，使用ExportParameterVisitor提取变量参数错误

[wangweicugw]

Druid版本

1.2.20

测试用例

    public static void main(String[] args) {
        String sql = "select trim(' ABC ') from t";
        SQLStatement statement = SQLUtils.parseSingleMysqlStatement(sql);
        StringBuilder stringBuilder = new StringBuilder();
        MySqlExportParameterVisitor visitor = new MySqlExportParameterVisitor(new ArrayList<>(), stringBuilder, true);
        visitor.setShardingSupport(false);
        visitor.setParameterizedMergeInList(false);
        visitor.setParameterizedQuesUnMergeInList(true);
        visitor.setPrettyFormat(false);
        visitor.setUppCase(false);
        visitor.config(VisitorFeature.OutputParameterizedQuesUnMergeOr, true);
        statement.accept(visitor);
        System.out.println("visitor.getParameters() = " + visitor.getParameters());
        System.out.println(stringBuilder);
    }

实际输出

visitor.getParameters() = [ABC]
select ? from t

期望输出

visitor.getParameters() = [ABC]
select trim(?) from t

[wangweicugw]

这样处理是想要在内存中处理trim函数么？

com.alibaba.druid.sql.visitor.SQLASTOutputVisitor#visit(com.alibaba.druid.sql.ast.expr.SQLMethodInvokeExpr)

    public boolean visit(SQLMethodInvokeExpr x) {
        SQLExpr owner = x.getOwner();
        if (owner != null) {
            printMethodOwner(owner);
        }

        if (parameterized) {
            List<SQLExpr> arguments = x.getArguments();
            if (x.methodNameHashCode64() == FnvHash.Constants.TRIM
                    && arguments.size() == 1
                    && arguments.get(0) instanceof SQLCharExpr && x.getTrimOption() == null && x.getFrom() == null) {
                print('?');

                if (parameters != null) {
                    SQLCharExpr charExpr = (SQLCharExpr) arguments.get(0);
                    parameters.add(charExpr.getText().trim());
                }

                replaceCount++;
                return false;
            }
        }

        String function = x.getMethodName();
        if (function != null) {
            printFunctionName(function);
        }
        printMethodParameters(x);
        return false;
    }