search

Trivadis / plsql-cop-cli

db* CODECOP Command Line
Other
24 stars 1 forks source link

Parse error in searched case expression #30

Closed PhilippSalvisberg closed 3 months ago

PhilippSalvisberg commented 3 months ago

Here's an example:

select case
          when length(dummy) > 1 then
             'yes'
          else
             'no'
       end case
  from dual;
PhilippSalvisberg commented 3 months ago

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

PhilippSalvisberg commented 3 months ago

fixed with Azure DevOps commit e5756a1ed839ec8026e23da33528a5524d5075b0