[BUG] JSQLParser 5.0: RDBMS : SQL was automatically intercepted

[CodergreenV]

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

SQL was automatically intercepted

SQL Example:

select * from user
         WHERE  userId = ?







                and (
                userHead like '%' || ? || '%'
                or itemName like '%' || ? || '%'
                or itemCode like '%' || ? || '%'
                )

Software Information:

• JSqlParser 5.0
• Database MySQL

Tips:

When there are more than 2 consecutive /n, the SQL will be automatically truncated. I use System. out. println (statement); printed the results

My Demo is

String sql = "select * from user\n" +
                "         WHERE  userId = ?\n" +
                "\n" +
                "\n" +
                "\n" +
                "\n" +
                "\n" +
                "\n" +
                "\n" +
                "                and (\n" +
                "                userHead like '%' || ? || '%'\n" +
                "                or itemName like '%' || ? || '%'\n" +
                "                or itemCode like '%' || ? || '%'\n" +
                "                )";
        CCJSqlParser parser = CCJSqlParserUtil.newParser(sql);
        parser.withSquareBracketQuotation(true);
        try {
            Statement statement = parser.Statement();
            System.out.println(statement);
        }catch (ParseException e) {
            throw new RuntimeException(e);
        }

[manticore-projects]

Duplicate #1988

2 empty lines \n\n terminate a statement.