Skip to content

[BUG] JSQLParser 4.9 : Failed to parse listagg with "on overflow truncate" #2003

@fourhundredfortyfour

Description

@fourhundredfortyfour

String sql = "select LISTAGG(field, ',' on overflow truncate '...') from dual";
PlainSelect plainSelect = (PlainSelect) CCJSqlParserUtil.parse(sql);

fails with

net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 1, column 15.

Was expecting one of:

"."
"::"
"["
"^"
<EOF>
<ST_SEMICOLON>

Software Information:

  • JSqlParser 4.9
  • Oracle

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions