JSQLParserException: MySQL style single quoted string with line break and backslash escaped single quote

[SylphiaWindy]

Test case to reproduce:

    @Test
    public void testInsertWithStringWithLineBreakAndEscapedSingleQuote() throws JSQLParserException {
        assertSqlCanBeParsedAndDeparsed(
                "INSERT INTO `table_a` (`code`) VALUES ('\n" +
                        "    print(\\'a string\\')\n" +
                        "')"
        );
    }

Not only select statement, but also in insert values

[manticore-projects]

Greetings.

Your quotes are wrong, this will work:

INSERT INTO table_a ( code )
VALUES ( '\n print(''a string'')\n' )
;

Translates to

String test =
              "INSERT INTO table_a (\n" +
              "    code )\n" +
              "VALUES ( '\\n print(''a string'')\\n' )\n" +
              ";";

[SylphiaWindy]

Though not recommended, it is supported and executable with MySQL.

[manticore-projects]

Please retest with latest JSQLParser 4.6 since quoting has been improved.

INSERT INTO table_a ( code )
VALUES ( '\n print(\'a string\')\n' )
;

Parses fine now.

[manticore-projects]

Closed, since no further question has been asked.