Skip to content

listagg parsing error #259

@devops-unitybars

Description

@devops-unitybars

Hello,
While parsing PL/SQL code that includes the LISTAGG(... ON OVERFLOW TRUNCATE) construction using the ZPA Toolkit, we encountered incorrect tokenization. This leads to faulty rule execution in affected cases.
Example:
select listagg(my_text_field, ';' on overflow truncate) from my_table;

Due to the incorrect parsing, certain rules behave unexpectedly:

Image Additionally, when executing any test in the zpa-main project that involves the ON OVERFLOW TRUNCATE clause, an exception is thrown: Image

We kindly ask you to investigate and resolve this parsing issue.
Thank you.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions