René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error on table rename, column rename, add constraints with cascade","articleBody":"Hello, Wumpz!\r\n\r\n**I understand that you are busy, so you can just ignore this message.**\r\n\r\nI have some issues:\r\n\r\n`CREATE TABLE table_qwert\r\n(\r\n    column_1 INT,\r\n    column_2 INT,\r\n    column_3 INT,\r\n    CONSTRAINT table_qwert_db_object_id_fk FOREIGN KEY (column_1) REFERENCES db_object (id)\r\n  ON UPDATE CASCADE\r\n  ON DELETE CASCADE\r\n);\r\n\r\nCaused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: \"ON\" \"ON\"\r\n    at line 8, column 3.\r\n\r\nWas expecting one of:\r\n\r\n    \")\"\r\n    \",\"\r\n\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:16995) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16848) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.CreateTable(CCJSqlParser.java:9451) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:171) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:250) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:152) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\t... 97 common frames omitted\r\n\r\n##################################################################################\r\n\r\nALTER TABLE attachment CHANGE content test LONGBLOB;\r\n\r\nCaused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: \"CHANGE\" \u003cS_IDENTIFIER\u003e\r\n    at line 1, column 24.\r\n\r\nWas expecting one of:\r\n\r\n    \"ADD\"\r\n    \"DROP\"\r\n    \"MODIFY\"\r\n\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:16995) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16848) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.AlterExpression(CCJSqlParser.java:10673) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.AlterTable(CCJSqlParser.java:10686) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:159) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:250) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:152) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\t... 97 common frames omitted\r\n\r\n\r\n##############################################################################\r\n\r\nRENAME TABLE `group` TO `member`;\r\n\r\nCaused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: \"RENAME\" \u003cS_IDENTIFIER\u003e\r\n    at line 1, column 1.\r\n\r\nWas expecting one of:\r\n\r\n    \"(\"\r\n    \";\"\r\n    \"ALTER\"\r\n    \"CALL\"\r\n    \"COMMIT\"\r\n    \"DELETE\"\r\n    \"DROP\"\r\n    \"EXEC\"\r\n    \"EXECUTE\"\r\n    \"INSERT\"\r\n    \"MERGE\"\r\n    \"REPLACE\"\r\n    \"SELECT\"\r\n    \"SET\"\r\n    \"TRUNCATE\"\r\n    \"UPDATE\"\r\n    \"UPSERT\"\r\n    \"USE\"\r\n    \"WITH\"\r\n\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:16995) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:16848) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:208) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:250) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\tat net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:152) ~[jsqlparser-1.2-20180105.233414-16.jar:na]\r\n\t... 97 common frames omitted`","author":{"url":"https://github.com/Golg013","@type":"Person","name":"Golg013"},"datePublished":"2018-01-22T09:25:06.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/571/JSqlParser/issues/571"}