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

Parse error in searched case expression #30

Closed
PhilippSalvisberg opened this issue Mar 26, 2024 · 2 comments
Closed

Parse error in searched case expression #30

PhilippSalvisberg opened this issue Mar 26, 2024 · 2 comments
Assignees
Labels
bug Something isn't working
Milestone

Comments

@PhilippSalvisberg
Copy link
Collaborator

Here's an example:

select case
          when length(dummy) > 1 then
             'yes'
          else
             'no'
       end case
  from dual;
@PhilippSalvisberg PhilippSalvisberg self-assigned this Mar 26, 2024
@PhilippSalvisberg PhilippSalvisberg added the bug Something isn't working label Mar 26, 2024
@PhilippSalvisberg
Copy link
Collaborator Author

The reason is the column alias case which is a keyword. This was handled in v4.5.0.

@PhilippSalvisberg PhilippSalvisberg added this to the v5.0.1 milestone Mar 26, 2024
@PhilippSalvisberg
Copy link
Collaborator Author

PhilippSalvisberg commented Mar 26, 2024

fixed with Azure DevOps commit e5756a1ed839ec8026e23da33528a5524d5075b0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant