ParameterizedOutputVisitorUtils.parameterize未能全参数化

druid 最新版本，测试代码如下：

@test public void testMergeSql() { String sql = "select\n" + " ifnull(sum(case when test_time >= '2019-04-01 11:22:33' and test_time < '2019-04-30 12:33:44' then 1 ELSE 0 end),0) today_count,\n" + " ifnull(sum(case when test_time >= '2019-04-01 11:22:33' and test_time < '2019-04-30 12:33:44' then 1 ELSE 0 end),0) month_count,\n" + " ifnull(sum(case when invest_time is not null then test_col1 ELSE 0 end),0) total_amt\n" + " \n" + " from notify_aaa\n" + " where abc='123' "; System.out.println(sql); String mergedSql = ParameterizedOutputVisitorUtils.parameterize(sql, "mysql", null, null); System.out.println(mergedSql); }

执行结果为：

SELECT ifnull(SUM(CASE WHEN test_time >= '2019-04-01 11:22:33' AND test_time < '2019-04-30 12:33:44' THEN 1 ELSE 0 END), ?) AS today_count , ifnull(SUM(CASE WHEN test_time >= '2019-04-01 11:22:33' AND test_time < '2019-04-30 12:33:44' THEN 1 ELSE 0 END), ?) AS month_count , ifnull(SUM(CASE WHEN invest_time IS NOT NULL THEN test_col1 ELSE 0 END), ?) AS total_amt FROM notify_aaa WHERE abc = ?

可以看到test_time字段后面的具体日期没有参数化成问号。

断点分析代码发现，在进入SQLASTOutputVisitor的public boolean visit(SQLAggregateExpr x)方法，this.parameterized = false; 导致不会参数化了。

原提问者GitHub用户lizongbo