JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

[BUG] [5.1] : MYSQL : SQL Parsed Error

Open zhengyangyong opened this issue 7 months ago • 2 comments

Failing SQL Feature:

Can't be parsed:

SELECT a as 测试() from b

Error Message:

Caused by: net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 1, column 15.  Encountered: '\uff08' (65288),
	at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:11253)
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_scan_token(CCJSqlParser.java:48356)
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_158(CCJSqlParser.java:35386)
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_2_158(CCJSqlParser.java:32337)
	at net.sf.jsqlparser.parser.CCJSqlParser.Alias(CCJSqlParser.java:11006)
	at net.sf.jsqlparser.parser.CCJSqlParser.SelectItem(CCJSqlParser.java:10923)
	at net.sf.jsqlparser.parser.CCJSqlParser.SelectItemsList(CCJSqlParser.java:10877)
	at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:10252)
	at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:9421)
	at net.sf.jsqlparser.parser.CCJSqlParser.SelectWithWithItems(CCJSqlParser.java:9394)
	at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:411)
	at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:322)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:166)

Software Information:

  • JSqlParser version : 5.1
  • Database : MySQL

zhengyangyong avatar Apr 14 '25 02:04 zhengyangyong

we need support \uff08 and \uff09

zhengyangyong avatar Apr 14 '25 02:04 zhengyangyong

Greetings!

This is not about Unicode support and the following works without any problem:

SELECT a AS 测试
FROM b
;

This issue is about the Alias with brackets:

SELECT a AS c() FROM b
;

Unsupported.

manticore-projects avatar Apr 18 '25 07:04 manticore-projects