{"action":"created","comment":{"url":"https://api.github.com/repos/pingcap/docs-cn/pulls/comments/139869856","pull_request_review_id":63860982,"id":139869856,"diff_hunk":"@@ -7,18 +7,18 @@ category: compatibility\n \n ## 概述\n \n-为了在功能上与最新版的MySQL（版本 5.7 及以上）保持同步，同时更好地支持文档存储类业务，我们在最新版本的 TiDB 中加入了 JSON 的支持。用户可以在 TiDB 的表中使用 JSON 类型的字段，同时以生成列（generated column）的方式为 JSON 文档内部的字段建立索引。基于此，用户可以很灵活地处理那些 schema 不确定地业务，同时不必受限于传统文档数据库糟糕的读性能及匮乏的事务支持。\n+为了在功能上兼容 MySQL 5.7 及以上，同时更好地支持文档类型存储，我们在最新版本的 TiDB 中加入了 JSON 的支持。TiDB 所支持的文档是指以 JSON 为编码类型的键值对的组合。用户可以在 TiDB 的表中使用 JSON 类型的字段，同时以生成列（generated column）的方式为 JSON 文档内部的字段建立索引。基于此，用户可以很灵活地处理那些 schema 不确定的业务，同时不必受限于传统文档数据库糟糕的读性能及匮乏的事务支持。\n \n ## JSON功能介绍\n \n-TiDB的 JSON 主要参考了 MySQL 5.7 的用户接口。例如，可以创建一个表，包含一个JSON字段来存储那些复杂的信息：\n+TiDB的 JSON 主要参考了 MySQL 5.7 的用户接口。例如，可以创建一个表，包含一个 JSON 字段来存储那些复杂的信息：","path":"sql/json-functions-generated-column.md","position":10,"original_position":10,"commit_id":"9a2a287d0a00f18e2e55887d267449ca2a670f2b","original_commit_id":"9a2a287d0a00f18e2e55887d267449ca2a670f2b","user":{"login":"andelf","id":72891,"avatar_url":"https://avatars1.githubusercontent.com/u/72891?v=4","gravatar_id":"","url":"https://api.github.com/users/andelf","html_url":"https://github.com/andelf","followers_url":"https://api.github.com/users/andelf/followers","following_url":"https://api.github.com/users/andelf/following{/other_user}","gists_url":"https://api.github.com/users/andelf/gists{/gist_id}","starred_url":"https://api.github.com/users/andelf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andelf/subscriptions","organizations_url":"https://api.github.com/users/andelf/orgs","repos_url":"https://api.github.com/users/andelf/repos","events_url":"https://api.github.com/users/andelf/events{/privacy}","received_events_url":"https://api.github.com/users/andelf/received_events","type":"User","site_admin":false},"body":"a space after TiDB","created_at":"2017-09-20T03:49:17Z","updated_at":"2017-09-20T03:51:45Z","html_url":"https://github.com/pingcap/docs-cn/pull/329#discussion_r139869856","pull_request_url":"https://api.github.com/repos/pingcap/docs-cn/pulls/329","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/pingcap/docs-cn/pulls/comments/139869856"},"html":{"href":"https://github.com/pingcap/docs-cn/pull/329#discussion_r139869856"},"pull_request":{"href":"https://api.github.com/repos/pingcap/docs-cn/pulls/329"}}},"pull_request":{"url":"https://api.github.com/repos/pingcap/docs-cn/pulls/329","id":141996634,"html_url":"https://github.com/pingcap/docs-cn/pull/329","diff_url":"https://github.com/pingcap/docs-cn/pull/329.diff","patch_url":"https://github.com/pingcap/docs-cn/pull/329.patch","issue_url":"https://api.github.com/repos/pingcap/docs-cn/issues/329","number":329,"state":"open","locked":false,"title":"Update the wording","user":{"login":"queenypingcap","id":19528243,"avatar_url":"https://avatars2.githubusercontent.com/u/19528243?v=4","gravatar_id":"","url":"https://api.github.com/users/queenypingcap","html_url":"https://github.com/queenypingcap","followers_url":"https://api.github.com/users/queenypingcap/followers","following_url":"https://api.github.com/users/queenypingcap/following{/other_user}","gists_url":"https://api.github.com/users/queenypingcap/gists{/gist_id}","starred_url":"https://api.github.com/users/queenypingcap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/queenypingcap/subscriptions","organizations_url":"https://api.github.com/users/queenypingcap/orgs","repos_url":"https://api.github.com/users/queenypingcap/repos","events_url":"https://api.github.com/users/queenypingcap/events{/privacy}","received_events_url":"https://api.github.com/users/queenypingcap/received_events","type":"User","site_admin":false},"body":"","created_at":"2017-09-20T02:19:40Z","updated_at":"2017-09-20T03:51:45Z","closed_at":null,"merged_at":null,"merge_commit_sha":"bec2488e8545df4ef9d94702993638122f85425a","assignee":null,"assignees":[],"requested_reviewers":[{"login":"hicqu","id":8407317,"avatar_url":"https://avatars1.githubusercontent.com/u/8407317?v=4","gravatar_id":"","url":"https://api.github.com/users/hicqu","html_url":"https://github.com/hicqu","followers_url":"https://api.github.com/users/hicqu/followers","following_url":"https://api.github.com/users/hicqu/following{/other_user}","gists_url":"https://api.github.com/users/hicqu/gists{/gist_id}","starred_url":"https://api.github.com/users/hicqu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hicqu/subscriptions","organizations_url":"https://api.github.com/users/hicqu/orgs","repos_url":"https://api.github.com/users/hicqu/repos","events_url":"https://api.github.com/users/hicqu/events{/privacy}","received_events_url":"https://api.github.com/users/hicqu/received_events","type":"User","site_admin":false}],"milestone":null,"commits_url":"https://api.github.com/repos/pingcap/docs-cn/pulls/329/commits","review_comments_url":"https://api.github.com/repos/pingcap/docs-cn/pulls/329/comments","review_comment_url":"https://api.github.com/repos/pingcap/docs-cn/pulls/comments{/number}","comments_url":"https://api.github.com/repos/pingcap/docs-cn/issues/329/comments","statuses_url":"https://api.github.com/repos/pingcap/docs-cn/statuses/9a2a287d0a00f18e2e55887d267449ca2a670f2b","head":{"label":"pingcap:wording","ref":"wording","sha":"9a2a287d0a00f18e2e55887d267449ca2a670f2b","user":{"login":"pingcap","id":11855343,"avatar_url":"https://avatars3.githubusercontent.com/u/11855343?v=4","gravatar_id":"","url":"https://api.github.com/users/pingcap","html_url":"https://github.com/pingcap","followers_url":"https://api.github.com/users/pingcap/followers","following_url":"https://api.github.com/users/pingcap/following{/other_user}","gists_url":"https://api.github.com/users/pingcap/gists{/gist_id}","starred_url":"https://api.github.com/users/pingcap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pingcap/subscriptions","organizations_url":"https://api.github.com/users/pingcap/orgs","repos_url":"https://api.github.com/users/pingcap/repos","events_url":"https://api.github.com/users/pingcap/events{/privacy}","received_events_url":"https://api.github.com/users/pingcap/received_events","type":"Organization","site_admin":false},"repo":{"id":64188788,"name":"docs-cn","full_name":"pingcap/docs-cn","owner":{"login":"pingcap","id":11855343,"avatar_url":"https://avatars3.githubusercontent.com/u/11855343?v=4","gravatar_id":"","url":"https://api.github.com/users/pingcap","html_url":"https://github.com/pingcap","followers_url":"https://api.github.com/users/pingcap/followers","following_url":"https://api.github.com/users/pingcap/following{/other_user}","gists_url":"https://api.github.com/users/pingcap/gists{/gist_id}","starred_url":"https://api.github.com/users/pingcap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pingcap/subscriptions","organizations_url":"https://api.github.com/users/pingcap/orgs","repos_url":"https://api.github.com/users/pingcap/repos","events_url":"https://api.github.com/users/pingcap/events{/privacy}","received_events_url":"https://api.github.com/users/pingcap/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pingcap/docs-cn","description":"TiDB/TiKV/PD documents in Chinese.","fork":false,"url":"https://api.github.com/repos/pingcap/docs-cn","forks_url":"https://api.github.com/repos/pingcap/docs-cn/forks","keys_url":"https://api.github.com/repos/pingcap/docs-cn/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pingcap/docs-cn/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pingcap/docs-cn/teams","hooks_url":"https://api.github.com/repos/pingcap/docs-cn/hooks","issue_events_url":"https://api.github.com/repos/pingcap/docs-cn/issues/events{/number}","events_url":"https://api.github.com/repos/pingcap/docs-cn/events","assignees_url":"https://api.github.com/repos/pingcap/docs-cn/assignees{/user}","branches_url":"https://api.github.com/repos/pingcap/docs-cn/branches{/branch}","tags_url":"https://api.github.com/repos/pingcap/docs-cn/tags","blobs_url":"https://api.github.com/repos/pingcap/docs-cn/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pingcap/docs-cn/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pingcap/docs-cn/git/refs{/sha}","trees_url":"https://api.github.com/repos/pingcap/docs-cn/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pingcap/docs-cn/statuses/{sha}","languages_url":"https://api.github.com/repos/pingcap/docs-cn/languages","stargazers_url":"https://api.github.com/repos/pingcap/docs-cn/stargazers","contributors_url":"https://api.github.com/repos/pingcap/docs-cn/contributors","subscribers_url":"https://api.github.com/repos/pingcap/docs-cn/subscribers","subscription_url":"https://api.github.com/repos/pingcap/docs-cn/subscription","commits_url":"https://api.github.com/repos/pingcap/docs-cn/commits{/sha}","git_commits_url":"https://api.github.com/repos/pingcap/docs-cn/git/commits{/sha}","comments_url":"https://api.github.com/repos/pingcap/docs-cn/comments{/number}","issue_comment_url":"https://api.github.com/repos/pingcap/docs-cn/issues/comments{/number}","contents_url":"https://api.github.com/repos/pingcap/docs-cn/contents/{+path}","compare_url":"https://api.github.com/repos/pingcap/docs-cn/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pingcap/docs-cn/merges","archive_url":"https://api.github.com/repos/pingcap/docs-cn/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pingcap/docs-cn/downloads","issues_url":"https://api.github.com/repos/pingcap/docs-cn/issues{/number}","pulls_url":"https://api.github.com/repos/pingcap/docs-cn/pulls{/number}","milestones_url":"https://api.github.com/repos/pingcap/docs-cn/milestones{/number}","notifications_url":"https://api.github.com/repos/pingcap/docs-cn/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pingcap/docs-cn/labels{/name}","releases_url":"https://api.github.com/repos/pingcap/docs-cn/releases{/id}","deployments_url":"https://api.github.com/repos/pingcap/docs-cn/deployments","created_at":"2016-07-26T04:04:37Z","updated_at":"2017-09-20T02:17:30Z","pushed_at":"2017-09-20T02:19:41Z","git_url":"git://github.com/pingcap/docs-cn.git","ssh_url":"git@github.com:pingcap/docs-cn.git","clone_url":"https://github.com/pingcap/docs-cn.git","svn_url":"https://github.com/pingcap/docs-cn","homepage":null,"size":3207,"stargazers_count":571,"watchers_count":571,"language":"TeX","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":149,"mirror_url":null,"open_issues_count":36,"forks":149,"open_issues":36,"watchers":571,"default_branch":"master"}},"base":{"label":"pingcap:master","ref":"master","sha":"1a1767c4a952cde990366de9d066a43ede86bac7","user":{"login":"pingcap","id":11855343,"avatar_url":"https://avatars3.githubusercontent.com/u/11855343?v=4","gravatar_id":"","url":"https://api.github.com/users/pingcap","html_url":"https://github.com/pingcap","followers_url":"https://api.github.com/users/pingcap/followers","following_url":"https://api.github.com/users/pingcap/following{/other_user}","gists_url":"https://api.github.com/users/pingcap/gists{/gist_id}","starred_url":"https://api.github.com/users/pingcap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pingcap/subscriptions","organizations_url":"https://api.github.com/users/pingcap/orgs","repos_url":"https://api.github.com/users/pingcap/repos","events_url":"https://api.github.com/users/pingcap/events{/privacy}","received_events_url":"https://api.github.com/users/pingcap/received_events","type":"Organization","site_admin":false},"repo":{"id":64188788,"name":"docs-cn","full_name":"pingcap/docs-cn","owner":{"login":"pingcap","id":11855343,"avatar_url":"https://avatars3.githubusercontent.com/u/11855343?v=4","gravatar_id":"","url":"https://api.github.com/users/pingcap","html_url":"https://github.com/pingcap","followers_url":"https://api.github.com/users/pingcap/followers","following_url":"https://api.github.com/users/pingcap/following{/other_user}","gists_url":"https://api.github.com/users/pingcap/gists{/gist_id}","starred_url":"https://api.github.com/users/pingcap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pingcap/subscriptions","organizations_url":"https://api.github.com/users/pingcap/orgs","repos_url":"https://api.github.com/users/pingcap/repos","events_url":"https://api.github.com/users/pingcap/events{/privacy}","received_events_url":"https://api.github.com/users/pingcap/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pingcap/docs-cn","description":"TiDB/TiKV/PD documents in Chinese.","fork":false,"url":"https://api.github.com/repos/pingcap/docs-cn","forks_url":"https://api.github.com/repos/pingcap/docs-cn/forks","keys_url":"https://api.github.com/repos/pingcap/docs-cn/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pingcap/docs-cn/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pingcap/docs-cn/teams","hooks_url":"https://api.github.com/repos/pingcap/docs-cn/hooks","issue_events_url":"https://api.github.com/repos/pingcap/docs-cn/issues/events{/number}","events_url":"https://api.github.com/repos/pingcap/docs-cn/events","assignees_url":"https://api.github.com/repos/pingcap/docs-cn/assignees{/user}","branches_url":"https://api.github.com/repos/pingcap/docs-cn/branches{/branch}","tags_url":"https://api.github.com/repos/pingcap/docs-cn/tags","blobs_url":"https://api.github.com/repos/pingcap/docs-cn/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pingcap/docs-cn/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pingcap/docs-cn/git/refs{/sha}","trees_url":"https://api.github.com/repos/pingcap/docs-cn/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pingcap/docs-cn/statuses/{sha}","languages_url":"https://api.github.com/repos/pingcap/docs-cn/languages","stargazers_url":"https://api.github.com/repos/pingcap/docs-cn/stargazers","contributors_url":"https://api.github.com/repos/pingcap/docs-cn/contributors","subscribers_url":"https://api.github.com/repos/pingcap/docs-cn/subscribers","subscription_url":"https://api.github.com/repos/pingcap/docs-cn/subscription","commits_url":"https://api.github.com/repos/pingcap/docs-cn/commits{/sha}","git_commits_url":"https://api.github.com/repos/pingcap/docs-cn/git/commits{/sha}","comments_url":"https://api.github.com/repos/pingcap/docs-cn/comments{/number}","issue_comment_url":"https://api.github.com/repos/pingcap/docs-cn/issues/comments{/number}","contents_url":"https://api.github.com/repos/pingcap/docs-cn/contents/{+path}","compare_url":"https://api.github.com/repos/pingcap/docs-cn/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pingcap/docs-cn/merges","archive_url":"https://api.github.com/repos/pingcap/docs-cn/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pingcap/docs-cn/downloads","issues_url":"https://api.github.com/repos/pingcap/docs-cn/issues{/number}","pulls_url":"https://api.github.com/repos/pingcap/docs-cn/pulls{/number}","milestones_url":"https://api.github.com/repos/pingcap/docs-cn/milestones{/number}","notifications_url":"https://api.github.com/repos/pingcap/docs-cn/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pingcap/docs-cn/labels{/name}","releases_url":"https://api.github.com/repos/pingcap/docs-cn/releases{/id}","deployments_url":"https://api.github.com/repos/pingcap/docs-cn/deployments","created_at":"2016-07-26T04:04:37Z","updated_at":"2017-09-20T02:17:30Z","pushed_at":"2017-09-20T02:19:41Z","git_url":"git://github.com/pingcap/docs-cn.git","ssh_url":"git@github.com:pingcap/docs-cn.git","clone_url":"https://github.com/pingcap/docs-cn.git","svn_url":"https://github.com/pingcap/docs-cn","homepage":null,"size":3207,"stargazers_count":571,"watchers_count":571,"language":"TeX","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":149,"mirror_url":null,"open_issues_count":36,"forks":149,"open_issues":36,"watchers":571,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/pingcap/docs-cn/pulls/329"},"html":{"href":"https://github.com/pingcap/docs-cn/pull/329"},"issue":{"href":"https://api.github.com/repos/pingcap/docs-cn/issues/329"},"comments":{"href":"https://api.github.com/repos/pingcap/docs-cn/issues/329/comments"},"review_comments":{"href":"https://api.github.com/repos/pingcap/docs-cn/pulls/329/comments"},"review_comment":{"href":"https://api.github.com/repos/pingcap/docs-cn/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/pingcap/docs-cn/pulls/329/commits"},"statuses":{"href":"https://api.github.com/repos/pingcap/docs-cn/statuses/9a2a287d0a00f18e2e55887d267449ca2a670f2b"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"andelf"}}