oracle解析within group报错

[canglangX]

com.alibaba.druid.sql.parser.ParserException: syntax error, error in :''，') WITHIN GROUP (ORDER BY pi.inst_name)
', expect BY, actual (, pos 798, line 24, column 51, token (
at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:863)
at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:871)
at com.alibaba.druid.sql.parser.SQLSelectParser.parseGroupBy(SQLSelectParser.java:825)
at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:478)
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62)
at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:872)
at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:109)
at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:369)
at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:109)
at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:6369)
at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:1069)
at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:463)
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62)
at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSource(SQLSelectParser.java:1111)
at com.alibaba.druid.sql.parser.SQLSelectParser.parseFrom(SQLSelectParser.java:1102)
at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:474)
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseSelect(SQLStatementParser.java:4469)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:4857)

[canglangX]

@lizongbo

[canglangX]

测试sql ： select listagg(name, ',') within group( order by name) as name from userinfo

[lizongbo]

你自己反馈问题连版本号都不提供，而我验证了1.2.22是正常解析的。

看了git提交记录，listagg的语法在2017年就支持了。

  for (String sql : new String[]{
            "select listagg(name, ',') within group( order by name) as name from userinfo",
        }) {
            SQLStatementParser parser1 = SQLParserUtils.createSQLStatementParser(sql, DbType.oracle);
            List<SQLStatement> statementList1 = parser1.parseStatementList();
            System.out.println("原始的sql===" + sql);
            String sqleNew = statementList1.get(0).toString();
            System.out.println("生成的sql===" + sqleNew);
            SQLStatementParser parser2 = SQLParserUtils.createSQLStatementParser(sqleNew, DbType.oracle);
            List<SQLStatement> statementList2 = parser2.parseStatementList();
            String sqleNew2 = statementList2.get(0).toString();
            System.out.println("再次解析生成的sql===" + sqleNew);
            assertEquals(sqleNew, sqleNew2);


        }