sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

CASE with alias is not properly parsed

Open ghost opened this issue 1 year ago • 1 comments

Feeding this SQL to the Parser:

SELECT
  CASE 
    WHEN a.kol = 1 THEN 'one'
    ELSE a.kol
  END as 'case'
FROM foo a;

will result in errors, and calling build() on the statement will result in this SQL:

SELECT CASE 'case' ELSE a.kol AS `END` END FROM foo AS `a`

The errors array contains these errors:

  • An alias was previously found.
  • An alias was expected.
  • Unexpected keyword.
  • Unexpected end of CASE expression

I encountered this problem since I upgraded from 5.8.2 to 5.9.1.

ghost avatar Oct 02 '24 10:10 ghost

Thank you for reporting this bug

Still confirmed today on 5.2.2-dev

williamdes avatar Dec 21 '24 13:12 williamdes