-
-
Notifications
You must be signed in to change notification settings - Fork 1.4k
Description
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
- sql
UPDATE t_device_alarm_define SET product_code='tf1qxz2ncr1y64so', code='E1', level='ERROR', name='{"de":null,"es":null,"fr":null,"cs-CZ":null,"en-US":null,"zh-CN":null}', reason='{"de":null,"es":null,"fr":null,"cs-CZ":null,"en-US":"High voltage protection222222222222222222222222222222222222222222222","zh-CN":"高压保护1111111111111111111111111111111111111111111111111111111111111111111"}', solution='{"de":"测试-Stromausfall Überprüfen Sie die Installationsumgebung und ob die Pumpe den Anforderungen entspricht, wenn dies nicht gelöst werden kann, wenden Sie sich bitte an das After-Sales-Personal","es":null,"fr":"测试-Panne d'électricité pour vérifier l'environnement d'installation et si la pompe à eau répond aux exigences, si elle ne peut pas être résolue, veuillez contacter le personnel après - vente","cs-CZ":"测试-Vypnutí proudu zkontrolujte, zda instalační prostředí a čerpadlo splňují požadavky, pokud to není možné vyřešit, obraťte se prosím na poprodejní personál","en-US":"Stop the power outage and check if the installation environment and water pump meet the requirements. If the problem cannot be solved, please contact after-sales personnel","zh-CN":"停机断电检查安装环境以及水泵是否符合要求,若不能解决请联系售后人员"}', push_message_status=1, create_time='2025-09-30 09:07:48', update_time='2025-09-30 09:29:17' WHERE id=1723956044668174337
```
- java
public static void main(String[] args) throws JSQLParserException {
String sql = "UPDATE t_device_alarm_define SET product_code='tf1qxz2ncr1y64so', code='E1', level='ERROR', name='{\"de\":null,\"es\":null,\"fr\":null,\"cs-CZ\":null,\"en-US\":null,\"zh-CN\":null}', reason='{\"de\":null,\"es\":null,\"fr\":null,\"cs-CZ\":null,\"en-US\":\"High voltage protection222222222222222222222222222222222222222222222\",\"zh-CN\":\"高压保护1111111111111111111111111111111111111111111111111111111111111111111\"}', solution='{\"de\":\"测试-Stromausfall Überprüfen Sie die Installationsumgebung und ob die Pumpe den Anforderungen entspricht, wenn dies nicht gelöst werden kann, wenden Sie sich bitte an das After-Sales-Personal\",\"es\":null,\"fr\":\"测试-Panne d'électricité pour vérifier l'environnement d'installation et si la pompe à eau répond aux exigences, si elle ne peut pas être résolue, veuillez contacter le personnel après - vente\",\"cs-CZ\":\"测试-Vypnutí proudu zkontrolujte, zda instalační prostředí a čerpadlo splňují požadavky, pokud to není možné vyřešit, obraťte se prosím na poprodejní personál\",\"en-US\":\"Stop the power outage and check if the installation environment and water pump meet the requirements. If the problem cannot be solved, please contact after-sales personnel\",\"zh-CN\":\"停机断电检查安装环境以及水泵是否符合要求,若不能解决请联系售后人员\"}', push_message_status=1, create_time='2025-09-30 09:07:48', update_time='2025-09-30 09:29:17' WHERE id=1723956044668174337";
Statement stmt = CCJSqlParserUtil.parse(sql);
StringBuilder buffer = new StringBuilder();
StatementDeParser deparser = new StatementDeParser(buffer);
stmt.accept(deparser);
System.out.println(buffer);
}
- exception
Caused by: net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "\u00e9lectricit\u00e9" <S_IDENTIFIER>
at line 1, column 624.
Was expecting one of:
"LIMIT"
"ORDER"
"OUTPUT"
"PREFERRING"
"RETURN"
"RETURNING"
"WHERE"
<EOF>
<ST_SEMICOLON>
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:352)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:125)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:91)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:64)
at io.github.future0923.debug.tools.base.hutool.sql.SqlFormatter.main(SqlFormatter.java:348)
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "\u00e9lectricit\u00e9" <S_IDENTIFIER>
at line 1, column 624.
Was expecting one of:
"LIMIT"
"ORDER"
"OUTPUT"
"PREFERRING"
"RETURN"
"RETURNING"
"WHERE"
<EOF>
<ST_SEMICOLON>
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:205)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:345)
... 4 more
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "\u00e9lectricit\u00e9" <S_IDENTIFIER>
at line 1, column 624.
Was expecting one of:
"LIMIT"
"ORDER"
"OUTPUT"
"PREFERRING"
"RETURN"
"RETURNING"
"WHERE"
<EOF>
<ST_SEMICOLON>
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:53111)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:52929)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:436)
at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:341)
at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:338)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)