Skip to content

Oracle SQL XMLSERIALIZE syntax not supported #1564

Closed
#2560
Closed
Oracle SQL XMLSERIALIZE syntax not supported#1564
#2560
Assignees
manticore-projects
Labels
improvement

Description

@xiongtx
xiongtx
opened on Jun 11, 2022

Oracle's XMLSERIALIZE differs from the parser's expectations in that it has a CONTENT keyword. The following example doesn't parse:

SELECT XMLSERIALIZE(CONTENT XMLTYPE('<Owner>Grandco</Owner>')) AS xmlserialize_doc
   FROM DUAL;
2. Unhandled net.sf.jsqlparser.JSQLParserException

1. Caused by net.sf.jsqlparser.parser.ParseException
   Encountered unexpected token: "XMLSERIALIZE" "XMLSERIALIZE" at line 1,
   column 8.
   
   Was expecting one of:
   
       "!"  "(" "*" "NOT" "STRAIGHT_JOIN"

Activity

  1. manticore-projects
    self-assigned this
    on Jun 12, 2022
  2. manticore-projects
    added
    improvement
    on Jun 12, 2022

  3. manticore-projects commented on Jun 12, 2022

    @manticore-projects
    manticore-projects
    on Jun 12, 2022
    Contributor

    Greetings,

    thank you for reporting, I will see what I can do about.

  4. wumpz commented on Jun 28, 2022

    @wumpz
    wumpz
    on Jun 28, 2022
    Member

    Only a special expression of XMLSERIALIZE is supported at the moment

    SELECT xmlserialize(xmlagg(xmltext(COMMENT_LINE) ORDER BY COMMENT_SEQUENCE) AS varchar (1024)) FROM mytable GROUP BY COMMENT_NUMBER

  5. wumpz commented on Jun 28, 2022

    @wumpz
    wumpz
    on Jun 28, 2022
    Member

    JSqlParserCC.jjt line 4675

  6. manticore-projects
    closed this as completedin #2560on Sep 10, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

improvement

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions