Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

[BUG] JSQLParser 4.8 : MYSQL : not able to parse _utf8mb4 dialects #2006

Open
aarthiganga01 opened this issue May 15, 2024 · 0 comments
Open

Comments

@aarthiganga01
Copy link

aarthiganga01 commented May 15, 2024

Failing SQL Feature:

  • JSQLParser fails to parse SQL statements that include the MySQL-specific _utf8mb4 character set prefix followed by a string literal with a space in between. This prefix is used in MySQL to specify that a string literal should be interpreted as UTF-8 encoded. When encountering this syntax, the parser throws an error.
  • net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "'%Felipe%'" <S_CHAR_LITERAL>

SQL Example:

  • select short_name
    from player_table
    where  ( `short_name` LIKE  _utf8mb4 '%Felipe%'  ) 

Software Information:

  • JSQLParser 4.8
  • MYSQL
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant