[BUG] "WITH" item using "GROUP BY" clause cannot be parsed

[csakhogy]

Failing SQL Feature:

• ParseException: Encountered unexpected token: "group" "GROUP"
• Example: WITH item using GROUP BY (and optionally HAVING) clause(s) cannot be parsed

SQL Example:

with mytbl as (select owner, count(*) from all_tables group by owner)
select *
from mytbl

Software Information:

• JSqlParser version 4.60
• Oracle v19c

[manticore-projects]

Greetings.

I can not reproduce your concern as it parses without any problem here.
You can test it online and interactively.

[csakhogy]

Sorry, my fault, I over-simplified the sample SQL script. The bug appears when the statement has both GROUP BY and HAVING and one changes the order of them which is - somewhat in contrast to SQL standards - allowed in Oracle dialect.
To be closed.

[manticore-projects]

@todo: Implement Oracle's HAVING before GROUP BY .