Description

csakhogy

opened on Apr 27, 2023

Issue body actions

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

Activity

1. manticore-projects commented on Apr 27, 2023

   

   manticore-projects

   on Apr 27, 2023

   Contributor

   More actions

   Greetings.

   I can not reproduce your concern as it parses without any problem here.
   You can test it online and interactively.
2. csakhogy commented on Apr 28, 2023

   

   csakhogy

   on Apr 28, 2023

   Author

   More actions

   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.
3. manticore-projects

   self-assigned this

   on Apr 29, 2023
4. manticore-projects

   added

   improvement

   on Apr 29, 2023
5. manticore-projects commented on Apr 29, 2023

   

   manticore-projects

   on Apr 29, 2023

   Contributor

   More actions

   @todo: Implement Oracle's HAVING before GROUP BY .
6. manticore-projects

   added 2 commits that reference this issue on Apr 29, 2023

   feat: Oracle `HAVING` before `GROUP BY`

   This issue will close once commit 4efb99f is merged into the 'master' branch.

   4efb99f

   feat: ClickHouse `Select...` ``FINAL` modifier

   This issue will close once commit 4b7f21c is merged into the 'master' branch.

   4b7f21c
7. manticore-projects

   closed this as completedin 41b6fceon Jun 1, 2023
8. manticore-projects

   closed this as completedin #1778on Jun 1, 2023
9. manticore-projects

   added a commit that references this issue on Jun 15, 2023

   Assorted Fixes #8 (#1807)

   This issue will close once commit a815f5f is merged into the 'master' branch.

   a815f5f
10. manticore-projects

    added a commit that references this issue on Jun 27, 2023

    Backslash Quotation of Single-Quote `'\\''` (#1813)

    This issue will close once commit c79dfff is merged into the 'master' branch.

    c79dfff

Issue actions