SQLASTOutputVisitor类中参数parameterizedMergeInList=false时，解析出来的问号个数和参数值个数不对应

[qxo]

visit(SQLInListExpr x)方法目前有一代码段如下：

 if (parameterizedMergeInList) {
                        List<Object> subList = new ArrayList<Object>(x.getTargetList().size());
                        for (SQLExpr target : x.getTargetList()) {
                            ExportParameterVisitorUtils.exportParameter(subList, target);
                        }
                        if (subList != null) {
                            parameters.add(subList);
                        }
                    } else {
                        for (SQLExpr target : x.getTargetList()) {
                            ExportParameterVisitorUtils.exportParameter(this.parameters, target);
                        }
                    }

当前parameterizedMergeInList默认为false,会导致解析出来的,sql中的问号个数和参数值个数不对应哦！

以下的测试代码

  String sql = "select * from test_tab1 where name='name' and id in  ('A','B')";
       final StringBuilder out = new StringBuilder();
       final ExportParameterVisitor visitor = new OracleExportParameterVisitor(out);
       // visitor.setParameterizedMergeInList(true);
        SQLStatementParser parser = new OracleStatementParser(sql);
        final SQLStatement parseStatement = parser.parseStatement();
        parseStatement.accept(visitor);
        final List<Object> plist = visitor.getParameters();
        sql = out.toString();
        System.out.println("src:"+sql);
        System.out.println("sql:"+sql+" params:"+plist);

[wenshao]

没问题哈，默认值是false

[wenshao]

已修复问题，请用新版本 https://github.com/alibaba/druid/releases/tag/1.1.0