Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle xmlparse(content ...) not supported #2146

Open
krislint opened this issue Jan 16, 2025 · 1 comment
Open

Oracle xmlparse(content ...) not supported #2146

krislint opened this issue Jan 16, 2025 · 1 comment

Comments

@krislint
Copy link

krislint commented Jan 16, 2025

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

  • Brief description of the failing SQL feature
  • xmlagg can't be parsed

SQL Example:

  • Simplified Query Example, focusing on the failing feature
         select xmlagg(xmlparse(content  sn.CODE||',')order by sn.CODE).getclobval() as SN
         from GV_SYS_CODEINFO sn
    

Software Information:

  • JSqlParser version 5.1
  • Database Oracle 11g

Exception in thread "main" net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 1, column 14.

Was expecting one of:

<EOF>
<ST_SEMICOLON>

at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:352)
@manticore-projects
Copy link
Contributor

Greetings.

xmlparse(content sn.CODE||',') is not supported.

@manticore-projects manticore-projects changed the title NOT SUPPORT Oracle xmlagg function Oracle xmlparse(content ...) not supported Jan 16, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants