Is this an issue of syntax structure priority?

[openai0229]

I am using MySQL version 8.0+, so I need this syntax, so I tried the following operation

In this case, it seems that it can be correctly parsed as a statement.

But when I removed the last semicolon, it seemed incorrect and was divided into two SQL statements.
Is it because of the priority of grammar structure?

[kaby76]

Which mysql grammar? There are two:

• https://github.com/antlr/grammars-v4/tree/7f917add1199e8b050a7117814899ebab50a3c3b/sql/mysql/Oracle
• https://github.com/antlr/grammars-v4/tree/7f917add1199e8b050a7117814899ebab50a3c3b/sql/mysql/Positive-Technologies

[openai0229]

Sorry, I should have written it directly instead of selecting it in the picture.
The grammar file I am using is the second one.