{"action":"created","issue":{"url":"https://api.github.com/repos/zendesk/maxwell/issues/178","labels_url":"https://api.github.com/repos/zendesk/maxwell/issues/178/labels{/name}","comments_url":"https://api.github.com/repos/zendesk/maxwell/issues/178/comments","events_url":"https://api.github.com/repos/zendesk/maxwell/issues/178/events","html_url":"https://github.com/zendesk/maxwell/issues/178","id":120496749,"number":178,"title":"Maxwel Crashing when Altering table with ADD INDEX  specified by Order","user":{"login":"danfiza","id":3473187,"avatar_url":"https://avatars.githubusercontent.com/u/3473187?v=3","gravatar_id":"","url":"https://api.github.com/users/danfiza","html_url":"https://github.com/danfiza","followers_url":"https://api.github.com/users/danfiza/followers","following_url":"https://api.github.com/users/danfiza/following{/other_user}","gists_url":"https://api.github.com/users/danfiza/gists{/gist_id}","starred_url":"https://api.github.com/users/danfiza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danfiza/subscriptions","organizations_url":"https://api.github.com/users/danfiza/orgs","repos_url":"https://api.github.com/users/danfiza/repos","events_url":"https://api.github.com/users/danfiza/events{/privacy}","received_events_url":"https://api.github.com/users/danfiza/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-04T22:10:32Z","updated_at":"2015-12-07T18:06:17Z","closed_at":"2015-12-07T18:06:17Z","body":"It looks like Maxwell is crashing when I ALTER a table with an ADD INDEX clause specified with an ORDER.\r\n\r\nEx:\r\n\r\nALTER TABLE `test` \r\nADD COLUMN `test_col` ENUM('Y', 'N') NULL DEFAULT 'N',\r\nADD INDEX `test_col` (`test_col_index` ASC);\r\n\r\nResults in an error stack like the below:\r\ncom.zendesk.maxwell.schema.ddl.MaxwellSQLSyntaxError: ASC\r\n\tat com.zendesk.maxwell.schema.ddl.MysqlParserListener.visitErrorNode(MysqlParserListener.java:85)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:41)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)\r\n\tat com.zendesk.maxwell.schema.ddl.SchemaChange.parse(SchemaChange.java:67)\r\n\tat com.zendesk.maxwell.MaxwellReplicator.processQueryEvent(MaxwellReplicator.java:273)\r\n\tat com.zendesk.maxwell.MaxwellReplicator.getEvent(MaxwellReplicator.java:253)\r\n\tat com.zendesk.maxwell.MaxwellReplicator.work(MaxwellReplicator.java:89)\r\n\tat com.zendesk.maxwell.RunLoopProcess.runLoop(RunLoopProcess.java:31)\r\n\tat com.zendesk.maxwell.Maxwell.run(Maxwell.java:89)\r\n\tat com.zendesk.maxwell.Maxwell.main(Maxwell.java:95)\r\n16:59:24,374 INFO  SchemaPosition - Storing final position"},"comment":{"url":"https://api.github.com/repos/zendesk/maxwell/issues/comments/162610253","html_url":"https://github.com/zendesk/maxwell/issues/178#issuecomment-162610253","issue_url":"https://api.github.com/repos/zendesk/maxwell/issues/178","id":162610253,"user":{"login":"osheroff","id":260084,"avatar_url":"https://avatars.githubusercontent.com/u/260084?v=3","gravatar_id":"","url":"https://api.github.com/users/osheroff","html_url":"https://github.com/osheroff","followers_url":"https://api.github.com/users/osheroff/followers","following_url":"https://api.github.com/users/osheroff/following{/other_user}","gists_url":"https://api.github.com/users/osheroff/gists{/gist_id}","starred_url":"https://api.github.com/users/osheroff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/osheroff/subscriptions","organizations_url":"https://api.github.com/users/osheroff/orgs","repos_url":"https://api.github.com/users/osheroff/repos","events_url":"https://api.github.com/users/osheroff/events{/privacy}","received_events_url":"https://api.github.com/users/osheroff/received_events","type":"User","site_admin":false},"created_at":"2015-12-07T18:06:17Z","updated_at":"2015-12-07T18:06:17Z","body":"fixed by https://github.com/zendesk/maxwell/pull/180"}}