Repository navigation
Encountered unexpected token: "\n\n\n" <ST_SEMICOLON> #1988
Description
Activity
- pinned this issue
on Apr 9, 2024 Greetings!
Two empty lines
\n\n\nterminate a statement. There is no good reason for a statement to contain more than 1 empty line, but there are many good reasons to split statements at empty lines when you don't want to write semicolons.If you still insist on empty lines then just use something like
String.replaceAll("\n\n+", "\n").@manticore-projects Hello, I don't think it's that simple. Consider the following SQL statement, it cannot simply replace empty lines:
update shop_info set title=?, content='abc def' where id=?
With JSQLParser 4.10 Snapshot, you can use the method
CCJSqlParserUtil.sanitizeSingleSql( sqlStr)to sanitize your statement. It will remove the redundant empty lines using a regular expression which honorsStringLiteral.@Test void testSingleStatementWithEmptyLines() throws JSQLParserException { String sqlStr = "update shop_info set title=?,\n" + "\n" + "\n" + "\n" + "content='abc\n" + "\n" + "\n" + "\n" + "def'\n" + "where id=?"; Statement statement = CCJSqlParserUtil.parse( CCJSqlParserUtil.sanitizeSingleSql( sqlStr) ); TestUtils.assertStatementCanBeDeparsedAs(statement, "update shop_info set title=?,\n" + "content='abc\n" + "\n" + "\n" + "\n" + "def'\n" + "where id=?", true); }
- changed the title
[-][BUG] JSQLParser Version : 4.6 : Encountered unexpected token: "\n\n\n" <ST_SEMICOLON> at line 1, column 39.[/-][+]Encountered unexpected token: "\n\n\n" <ST_SEMICOLON>[/+]on May 1, 2024 - marked [BUG] JSQLParser 5.0: RDBMS : SQL was automatically intercepted #2193 as a duplicate of this issue
on Mar 19, 2025
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
SQL Example:
Software Information:
Tips:
Please write in English and avoid Screenshots (as we can't copy and paste content from it).
Try your example online with the latest JSQLParser and share the link in the error report.
Do provide Links or References to the specific Grammar and Syntax you are trying to use.
http://jsqlformatter.manticore-projects.com/jsqlformatter/demo.html?args=-c%20KoBQIgggKgogBAZwBYHsAOB9AlgOwGYpxwDKMUcALlhQDYCmAvAPwA0AUBx2gE7oLNEA6gAkYAJXhYAJsyA