{"action":"created","issue":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1314","repository_url":"https://api.github.com/repos/MyCATApache/Mycat-Server","labels_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1314/labels{/name}","comments_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1314/comments","events_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1314/events","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/1314","id":197798915,"number":1314,"title":"MYCAT 全局sequence 查询语句，默认druid sql解析器报错","user":{"login":"jiangchengshi","id":21210629,"avatar_url":"https://avatars.githubusercontent.com/u/21210629?v=3","gravatar_id":"","url":"https://api.github.com/users/jiangchengshi","html_url":"https://github.com/jiangchengshi","followers_url":"https://api.github.com/users/jiangchengshi/followers","following_url":"https://api.github.com/users/jiangchengshi/following{/other_user}","gists_url":"https://api.github.com/users/jiangchengshi/gists{/gist_id}","starred_url":"https://api.github.com/users/jiangchengshi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jiangchengshi/subscriptions","organizations_url":"https://api.github.com/users/jiangchengshi/orgs","repos_url":"https://api.github.com/users/jiangchengshi/repos","events_url":"https://api.github.com/users/jiangchengshi/events{/privacy}","received_events_url":"https://api.github.com/users/jiangchengshi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-12-28T05:38:50Z","updated_at":"2016-12-29T00:50:40Z","closed_at":null,"body":"INSERT INTO C_CART\r\n(cartId, customerId, productSubId, distProdSubId, storeId, num, msg, isDel, delTime, createtime)\r\nVALUES\r\n(next value for MYCATSEQ_CART, ?, ?, ?, ?, ?, ?, ?, ?, ?)\r\n\r\n在 控制台 运行， 报错信息(部分)：\r\ncaught err: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :' FOR MYCATSEQ_CART',expect UPDATE, actual IDENTIFIER MYCATSEQ_CART\r\nat com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:239)\r\nat com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:247)\r\nat com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.query(MySqlSelectParser.java:179)\r\nat com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62)\r\nat com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseSelect(MySqlStatementParser.java:237)\r\nat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:183)\r\nat com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2065)\r\nat io.mycat.server.util.SchemaUtil.parseSchema(SchemaUtil.java:25)\r\nat io.mycat.server.ServerConnection.execute(ServerConnection.java:214)\r\nat io.mycat.server.handler.SelectHandler.handle(SelectHandler.java:105)\r\nat io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:79)\r\nat io.mycat.net.FrontendConnection.query(FrontendConnection.java:317)\r\nat io.mycat.net.FrontendConnection.query(FrontendConnection.java:337)\r\nat io.mycat.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:71)\r\n\r\n\r\n\r\n 我已反馈给 druid 大神 @wenshao， 麻烦你们也关注下，推动下这个问题， 是否能更改下语法规则？\r\nhttps://github.com/alibaba/druid/issues/1559"},"comment":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/comments/269565192","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/1314#issuecomment-269565192","issue_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1314","id":269565192,"user":{"login":"HashZhang","id":15627489,"avatar_url":"https://avatars.githubusercontent.com/u/15627489?v=3","gravatar_id":"","url":"https://api.github.com/users/HashZhang","html_url":"https://github.com/HashZhang","followers_url":"https://api.github.com/users/HashZhang/followers","following_url":"https://api.github.com/users/HashZhang/following{/other_user}","gists_url":"https://api.github.com/users/HashZhang/gists{/gist_id}","starred_url":"https://api.github.com/users/HashZhang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/HashZhang/subscriptions","organizations_url":"https://api.github.com/users/HashZhang/orgs","repos_url":"https://api.github.com/users/HashZhang/repos","events_url":"https://api.github.com/users/HashZhang/events{/privacy}","received_events_url":"https://api.github.com/users/HashZhang/received_events","type":"User","site_admin":false},"created_at":"2016-12-29T00:50:40Z","updated_at":"2016-12-29T00:50:40Z","body":"你可以这么写就插入了：\r\n`INSERT INTO C_CART\r\n(customerId, productSubId, distProdSubId, storeId, num, msg, isDel, delTime, createtime)\r\nVALUES\r\n( ?, ?, ?, ?, ?, ?, ?, ?, ?)`\r\n你不用自己写next value for MYCATSEQ_CART，这个是MyCat帮你改写的\r\n"}}
{"actor":{"display_login":"HashZhang"}}