CASE with alias is not properly parsed

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:

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

Thank you for reporting this bug

Still confirmed today on 5.2.2-dev

Can confirm that this bug is still happening in 6.0.0.

I made a pull request with my attempt to fix it

Navigation Menu