{"action":"created","issue":{"url":"https://api.github.com/repos/youtube/vitess/issues/540","labels_url":"https://api.github.com/repos/youtube/vitess/issues/540/labels{/name}","comments_url":"https://api.github.com/repos/youtube/vitess/issues/540/comments","events_url":"https://api.github.com/repos/youtube/vitess/issues/540/events","html_url":"https://github.com/youtube/vitess/issues/540","id":65632358,"number":540,"title":"Does vitess support some common features for MySQL?","user":{"login":"Juckey","id":11327448,"avatar_url":"https://avatars.githubusercontent.com/u/11327448?v=3","gravatar_id":"","url":"https://api.github.com/users/Juckey","html_url":"https://github.com/Juckey","followers_url":"https://api.github.com/users/Juckey/followers","following_url":"https://api.github.com/users/Juckey/following{/other_user}","gists_url":"https://api.github.com/users/Juckey/gists{/gist_id}","starred_url":"https://api.github.com/users/Juckey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Juckey/subscriptions","organizations_url":"https://api.github.com/users/Juckey/orgs","repos_url":"https://api.github.com/users/Juckey/repos","events_url":"https://api.github.com/users/Juckey/events{/privacy}","received_events_url":"https://api.github.com/users/Juckey/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-01T08:30:17Z","updated_at":"2015-04-01T16:46:06Z","closed_at":null,"body":"Does vitess support some common features for MySQL as follows:\r\n1、rewriteBatchedStatements=true\r\n2、useServerPrepStmts=true\r\n3、correlation sql operations such as:join、paging、sort、subquery\r\n4、BLOB、BINARY、VARBINARY\r\n5、SAVEPOINT operation\r\n6、SET statement\r\n7、update existed column value for sharded table"},"comment":{"url":"https://api.github.com/repos/youtube/vitess/issues/comments/88550392","html_url":"https://github.com/youtube/vitess/issues/540#issuecomment-88550392","issue_url":"https://api.github.com/repos/youtube/vitess/issues/540","id":88550392,"user":{"login":"sougou","id":589370,"avatar_url":"https://avatars.githubusercontent.com/u/589370?v=3","gravatar_id":"","url":"https://api.github.com/users/sougou","html_url":"https://github.com/sougou","followers_url":"https://api.github.com/users/sougou/followers","following_url":"https://api.github.com/users/sougou/following{/other_user}","gists_url":"https://api.github.com/users/sougou/gists{/gist_id}","starred_url":"https://api.github.com/users/sougou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sougou/subscriptions","organizations_url":"https://api.github.com/users/sougou/orgs","repos_url":"https://api.github.com/users/sougou/repos","events_url":"https://api.github.com/users/sougou/events{/privacy}","received_events_url":"https://api.github.com/users/sougou/received_events","type":"User","site_admin":false},"created_at":"2015-04-01T16:46:06Z","updated_at":"2015-04-01T16:46:06Z","body":"1,2. It looks like some of these settings are related to the Java API. We currently don't have an officially good API yet (we do have some experimental ones you can try). I'd be very surprised if what we have now supports those settings.\r\n3. We support join, paging (limit clauses), sorts and subqueries, as long as they're targeting a single shard.\r\n4. We support blob, binary & varbinary.\r\n5. SAVEPOINT is not supported yet.\r\n6. We allow SET statements that we just pass through to MySQL, but we haven't used them ourselves. So, we don't know what effect they'll have.\r\n7. Not sure what the question is. We support update, delete and insert statements, but they're restricted to a single shard per statement."}}