René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"DISABLE Keyword causing parser if used as column name","articleBody":"Bug 1\r\n\r\nI reported a similar issue with the CHANGE keyword. We have a legacy app that uses the Mysql keyword \"DISABLE\" as a column name. Since it's legacy, we can't easily change the column name, and it is causing the sql parser to break. \r\n\r\n\r\nTo Reproduce\r\nSteps to reproduce the behavior:\r\n2. Parsing \"INSERT INTO SOMESCHEMA.TEST (DISABLE, TESTCOLUMN) VALUES(1, 1)\" SQL using JSqlParser throws JsqlParserException.\r\n\r\nCaused by: net.sf.jsqlparser.JSQLParserException at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:51) at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:40) ... 53 more Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “DISABLE” “DISABLE” at line 1, column 15. Was expecting one of: “(” “ACTION” “ANY”...\r\n\r\nConfiguration\r\n\r\nMysql\r\nJava 8\r\nJSqlParser 2.1\r\n\r\nBug 2\r\n\r\nDouble quotes seem to not get parsed correctly\r\n\r\n1. Parsing SELECT\r\n(IFNULL(DOCUMENT_TABLE.TITLE,\"\") || \", \" || IFNULL(WF.DISPLAY_NAME,\"\") || IFNULL(\" # \" || DOCUMENT_TABLE.SOME$NUMBER,\"\")  || IFNULL(\" rev. \" || DOCUMENT_TABLE.REVISION,\"\")) AS REQUIRMENT_DESCRIPTION\r\n\r\nFROM\r\nDOC.DOC_DOCUMENT AS DOCUMENT_TABLE\r\nLEFT JOIN ENGINE.PHASE_SETTINGS AS PHASE ON (DOCUMENT_TABLE.SOME$CURRENT_PHASE = PHASE.PHASE_ID)\r\nLEFT JOIN ENGINE.WF_SETTINGS AS WF ON (PHASE.WORKFLOW_ID = WF.WORKFLOW_ID)\r\n\r\nWHERE\r\nDOCUMENT_TABLE.DOC_ID = 2113978200\r\n\r\nCauses  Jsqlparser exception on the quotation marks simliar to above statement.\r\n\r\n","author":{"url":"https://github.com/naumaan123","@type":"Person","name":"naumaan123"},"datePublished":"2020-02-07T17:54:25.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/945/JSqlParser/issues/945"}