Skip to content

My SQL contains “FOR XML PATH”, it can not pass the CCJSqlParserUtil.parse (SQL); #479

Closed

Description

@305088020

my sql is

SELECT
            SHEBEI_ID AS ID,*,(
                SELECT
                  *
                FROM
                  V_BANKA_NEW BANKA
                WHERE
                  BANKA.BANKA_DELETE_FLAG = 0
                AND SHEBEI.SHEBEI_ID = BANKA.BANKA_PEISHUSHEBEI
                FOR XML PATH('data')
            ) BANKA
        FROM
          V_SHEBEI_NEW SHEBEI

it contains "FOR XML PATH"
Run CCJSqlParserUtil.parse(sql); error reporting

Activity

  1. wumpz commented on Jul 26, 2017

    @wumpz
    Member

    Give us the exception throwed.

  2. 305088020 commented on Jul 26, 2017

    @305088020
    Author

    e00beda4-d352-4d59-b871-e0a9f3229cc9

  3. wumpz commented on Jul 26, 2017

    @wumpz
    Member

    Looked into it. JSqlParser does not yet support for xml path construct.

  4. thapld commented on Feb 19, 2019

    @thapld

    Have any idea can resolve this problem?

  5. wumpz commented on Feb 19, 2019

    @wumpz
    Member

    @thapld Started analyzing problem. hope I can provide a solution soon.

  6. reopened this on Feb 19, 2019
  7. added a commit that references this issue on Feb 19, 2019
    0b5f586
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions