ON gets mistaken for a keyword here.
Image

There should be no error, the query works.
MariaDB 11.4.4
sql-parser 5.10 & master