Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Group By results in RuntimeException[BUG] #342

Closed
ghost opened this issue Dec 17, 2021 · 0 comments · Fixed by #1189
Closed

Group By results in RuntimeException[BUG] #342

ghost opened this issue Dec 17, 2021 · 0 comments · Fixed by #1189
Assignees
Labels
bug Something isn't working v2.5.0 'Issues and PRs related to version v2.5.0'

Comments

@ghost
Copy link

ghost commented Dec 17, 2021

Describe the bug
Group By results in RuntimeException.

Or for query issues:

  1. Run the query '
    select str1, date0, C1, case when not C1 is null then C1 else {ts '1899-12-28 00:00:00'} end as C2, case when C1 is null then 0 else 1 end as C3 from (select str1, date0, date0 as C1 from calcs ) as ITBL group by str1, date0, C1
    '
  2. See error RuntimeException image

Expected behavior
Return valid results without an exception.

Additional context
The query works as expected without group by.
image

@ghost ghost added Beta bug Something isn't working untriaged labels Dec 17, 2021
@dai-chen dai-chen added the v2.5.0 'Issues and PRs related to version v2.5.0' label Dec 16, 2022
@dai-chen dai-chen self-assigned this Dec 16, 2022
@dai-chen dai-chen linked a pull request Dec 22, 2022 that will close this issue
6 tasks
@dai-chen dai-chen moved this to Done in SQL Engineering Dec 23, 2022
GumpacG pushed a commit that referenced this issue Aug 22, 2023
…ges (#2017)

* Applied formatting improvements to Antlr files based on spotless changes (#342)

Signed-off-by: Matthew Wells <matthew.wells@improving.com>

* added spacing to # names back into parser files

Signed-off-by: Matthew Wells <matthew.wells@improving.com>

---------

Signed-off-by: Matthew Wells <matthew.wells@improving.com>
Yury-Fridlyand pushed a commit that referenced this issue Aug 23, 2023
…n spotless changes (#2017) (#2023)

* Applied formatting improvements to Antlr files based on spotless changes (#2017)

* Applied formatting improvements to Antlr files based on spotless changes (#342)

Signed-off-by: Matthew Wells <matthew.wells@improving.com>

* added spacing to # names back into parser files

Signed-off-by: Matthew Wells <matthew.wells@improving.com>

---------

Signed-off-by: Matthew Wells <matthew.wells@improving.com>

* Update sql/src/main/antlr/OpenSearchSQLParser.g4

Signed-off-by: Mitchell Gale <Mitchell.gale@improving.com>

* fixed extra semi colon

Signed-off-by: Mitchell Gale <Mitchell.Gale@improving.com>

---------

Signed-off-by: Matthew Wells <matthew.wells@improving.com>
Signed-off-by: Mitchell Gale <Mitchell.gale@improving.com>
Signed-off-by: Mitchell Gale <Mitchell.Gale@improving.com>
Co-authored-by: Matthew Wells <matthew.wells@improving.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working v2.5.0 'Issues and PRs related to version v2.5.0'
Projects
No open projects
Status: Done
Development

Successfully merging a pull request may close this issue.

2 participants