JSqlParser cannot recognize \' #875

Activity

1. yanbeipang

   changed the title [-]Cannot parse SQL with "log" as column name, \'UPDATE\' within value[/-] [+]Cannot parse SQL with "skip" as column name, \'UPDATE\' within value[/+] on Oct 21, 2019
2. yanbeipang

   changed the title [-]Cannot parse SQL with "skip" as column name, \'UPDATE\' within value[/-] [+]Cannot parse SQL that contains \'UPDATE\' in column value[/+] on Oct 22, 2019
3. yanbeipang

   changed the title [-]Cannot parse SQL that contains \'UPDATE\' in column value[/-] [+]JSqlParser cannot recognize \'[/+] on Oct 22, 2019
4. manticore-projects

   added a commit that references this issue on Jan 16, 2023

   feat: allow `S_CHAR_LITERAL` to break lines

   ...

   This issue will close once commit db8f68e is merged into the 'master' branch.

   db8f68e
5. manticore-projects commented on Jan 16, 2023

   

   manticore-projects

   on Jan 16, 2023

   Contributor

   More actions

   Greetings!

   You will need to escape the single Quotes ' inside your Character Literal either SQL:2016 compliant with '' or lenient with \' and backslashEscaping activated. Please note that the later depends on PR #1715.

   Example

           String sqlStr="insert into standard_table(gmt_create, gmt_modified, config_name, standard_code) values (now(), now(), null, 'if \n"
                         + "@fac.sql_type in \n"
                         + "[ ''UPDATE'', ''DELETE'', ''INSERT'', ''INSERT_SELECT''] \n"
                         + "then \n"
                         + "@act.allow_submit \n"
                         + "end \n"
                         + "')"
                         ;
           TestUtils.assertSqlCanBeParsedAndDeparsed(
                   sqlStr
                   , true
                   , parser -> parser.withBackslashEscapeCharacter(false)
           );
   
           sqlStr="insert into standard_table(gmt_create, gmt_modified, config_name, standard_code) values (now(), now(), null, 'if \n"
                         + "@fac.sql_type in \n"
                         + "[ \\'UPDATE\\', \\'DELETE\\', \\'INSERT\\', \\'INSERT_SELECT\\'] \n"
                         + "then \n"
                         + "@act.allow_submit \n"
                         + "end \n"
                         + "')"
                   ;
           TestUtils.assertSqlCanBeParsedAndDeparsed(
                   sqlStr
                   , true
                   , parser -> parser.withBackslashEscapeCharacter(true)
           );
6. wumpz

   closed this as completedin #1715on Jan 20, 2023
7. wumpz

   closed this as completedin a00d77aon Jan 20, 2023