{"action":"created","issue":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1149","repository_url":"https://api.github.com/repos/MyCATApache/Mycat-Server","labels_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1149/labels{/name}","comments_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1149/comments","events_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1149/events","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/1149","id":182730622,"number":1149,"title":"mycat批量更新","user":{"login":"lakersh3","id":22811655,"avatar_url":"https://avatars.githubusercontent.com/u/22811655?v=3","gravatar_id":"","url":"https://api.github.com/users/lakersh3","html_url":"https://github.com/lakersh3","followers_url":"https://api.github.com/users/lakersh3/followers","following_url":"https://api.github.com/users/lakersh3/following{/other_user}","gists_url":"https://api.github.com/users/lakersh3/gists{/gist_id}","starred_url":"https://api.github.com/users/lakersh3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lakersh3/subscriptions","organizations_url":"https://api.github.com/users/lakersh3/orgs","repos_url":"https://api.github.com/users/lakersh3/repos","events_url":"https://api.github.com/users/lakersh3/events{/privacy}","received_events_url":"https://api.github.com/users/lakersh3/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-10-13T08:50:55Z","updated_at":"2016-10-20T07:53:50Z","closed_at":null,"body":"     最近遇到的问题，发现1.5和1.6版本都会出现问题。当执行1个批量更新后，例如拼写100个下面的语句update table_1 set column_1 = 1 where 1=1 and condition_1=1  ;然后1条sql发送给mycat，下来当再执行别的查询语句时，就报错Caused by: java.sql.SQLException: ResultSet is from UPDATE. No Data。同一个方法内的调用，spring做的事务管理，后端采用的是mysql。\r\n    当不使用mycat，直接连mysql就不报错"},"comment":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/comments/255034642","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/1149#issuecomment-255034642","issue_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/1149","id":255034642,"user":{"login":"lakersh3","id":22811655,"avatar_url":"https://avatars.githubusercontent.com/u/22811655?v=3","gravatar_id":"","url":"https://api.github.com/users/lakersh3","html_url":"https://github.com/lakersh3","followers_url":"https://api.github.com/users/lakersh3/followers","following_url":"https://api.github.com/users/lakersh3/following{/other_user}","gists_url":"https://api.github.com/users/lakersh3/gists{/gist_id}","starred_url":"https://api.github.com/users/lakersh3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lakersh3/subscriptions","organizations_url":"https://api.github.com/users/lakersh3/orgs","repos_url":"https://api.github.com/users/lakersh3/repos","events_url":"https://api.github.com/users/lakersh3/events{/privacy}","received_events_url":"https://api.github.com/users/lakersh3/received_events","type":"User","site_admin":false},"created_at":"2016-10-20T07:53:50Z","updated_at":"2016-10-20T07:53:50Z","body":"       如果jdbcUrl如下jdbc:mysql://10.21.17.201:3316/mycat?rewriteBatchedStatements=true，加上rewriteBatchedStatements参数后，批量更新时就会拼写出一长串update语句（以分号分隔），发送到mycat执行后，如果同一事物内还有其他的执行语句，就会报错。java.sql.SQLException: ResultSet is from UPDATE. No Data."}}
{"actor":{"display_login":"lakersh3"}}