{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/docs/issues/255","repository_url":"https://api.github.com/repos/cockroachdb/docs","labels_url":"https://api.github.com/repos/cockroachdb/docs/issues/255/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/docs/issues/255/comments","events_url":"https://api.github.com/repos/cockroachdb/docs/issues/255/events","html_url":"https://github.com/cockroachdb/docs/issues/255","id":152839141,"number":255,"title":"Create Index statement","user":{"login":"jseldess","id":15893490,"avatar_url":"https://avatars.githubusercontent.com/u/15893490?v=3","gravatar_id":"","url":"https://api.github.com/users/jseldess","html_url":"https://github.com/jseldess","followers_url":"https://api.github.com/users/jseldess/followers","following_url":"https://api.github.com/users/jseldess/following{/other_user}","gists_url":"https://api.github.com/users/jseldess/gists{/gist_id}","starred_url":"https://api.github.com/users/jseldess/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jseldess/subscriptions","organizations_url":"https://api.github.com/users/jseldess/orgs","repos_url":"https://api.github.com/users/jseldess/repos","events_url":"https://api.github.com/users/jseldess/events{/privacy}","received_events_url":"https://api.github.com/users/jseldess/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cockroachdb/docs/labels/help%20wanted","name":"help wanted","color":"159818"}],"state":"open","locked":false,"assignee":{"login":"sploiselle","id":19260003,"avatar_url":"https://avatars.githubusercontent.com/u/19260003?v=3","gravatar_id":"","url":"https://api.github.com/users/sploiselle","html_url":"https://github.com/sploiselle","followers_url":"https://api.github.com/users/sploiselle/followers","following_url":"https://api.github.com/users/sploiselle/following{/other_user}","gists_url":"https://api.github.com/users/sploiselle/gists{/gist_id}","starred_url":"https://api.github.com/users/sploiselle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sploiselle/subscriptions","organizations_url":"https://api.github.com/users/sploiselle/orgs","repos_url":"https://api.github.com/users/sploiselle/repos","events_url":"https://api.github.com/users/sploiselle/events{/privacy}","received_events_url":"https://api.github.com/users/sploiselle/received_events","type":"User","site_admin":false},"assignees":[{"login":"sploiselle","id":19260003,"avatar_url":"https://avatars.githubusercontent.com/u/19260003?v=3","gravatar_id":"","url":"https://api.github.com/users/sploiselle","html_url":"https://github.com/sploiselle","followers_url":"https://api.github.com/users/sploiselle/followers","following_url":"https://api.github.com/users/sploiselle/following{/other_user}","gists_url":"https://api.github.com/users/sploiselle/gists{/gist_id}","starred_url":"https://api.github.com/users/sploiselle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sploiselle/subscriptions","organizations_url":"https://api.github.com/users/sploiselle/orgs","repos_url":"https://api.github.com/users/sploiselle/repos","events_url":"https://api.github.com/users/sploiselle/events{/privacy}","received_events_url":"https://api.github.com/users/sploiselle/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/cockroachdb/docs/milestones/2","html_url":"https://github.com/cockroachdb/docs/milestones/Q2","labels_url":"https://api.github.com/repos/cockroachdb/docs/milestones/2/labels","id":1687873,"number":2,"title":"Q2","description":"","creator":{"login":"jseldess","id":15893490,"avatar_url":"https://avatars.githubusercontent.com/u/15893490?v=3","gravatar_id":"","url":"https://api.github.com/users/jseldess","html_url":"https://github.com/jseldess","followers_url":"https://api.github.com/users/jseldess/followers","following_url":"https://api.github.com/users/jseldess/following{/other_user}","gists_url":"https://api.github.com/users/jseldess/gists{/gist_id}","starred_url":"https://api.github.com/users/jseldess/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jseldess/subscriptions","organizations_url":"https://api.github.com/users/jseldess/orgs","repos_url":"https://api.github.com/users/jseldess/repos","events_url":"https://api.github.com/users/jseldess/events{/privacy}","received_events_url":"https://api.github.com/users/jseldess/received_events","type":"User","site_admin":false},"open_issues":27,"closed_issues":34,"state":"open","created_at":"2016-04-06T17:46:54Z","updated_at":"2016-06-28T18:23:56Z","due_on":"2016-06-30T04:00:00Z","closed_at":null},"comments":17,"created_at":"2016-05-03T18:11:47Z","updated_at":"2016-06-30T19:05:12Z","closed_at":null,"body":"Complete reference documentation for the `CREATE INDEX` statement: create-index.md\r\n\r\nIntro, Synopsis, and Required Privileges are complete. We need to replace or supplement **Parameters** with **Usage** and **Examples** sections. For style reference, see those sections in [`CREATE DATABASE`](https://www.cockroachlabs.com/docs/create-database.html) and [`GRANT`](https://www.cockroachlabs.com/docs/grant.html).\r\n\r\nMore reference:\r\n- https://github.com/cockroachdb/cockroach/blob/master/sql/create.go\r\n- https://github.com/cockroachdb/cockroach/blob/master/sql/testdata/create_index\r\n- PostgreSQL docs: http://www.postgresql.org/docs/9.5/static/sql-createindex.html\r\n- MySQL docs: http://dev.mysql.com/doc/refman/5.5/en/create-index.html"},"comment":{"url":"https://api.github.com/repos/cockroachdb/docs/issues/comments/229757470","html_url":"https://github.com/cockroachdb/docs/issues/255#issuecomment-229757470","issue_url":"https://api.github.com/repos/cockroachdb/docs/issues/255","id":229757470,"user":{"login":"RaduBerinde","id":16544120,"avatar_url":"https://avatars.githubusercontent.com/u/16544120?v=3","gravatar_id":"","url":"https://api.github.com/users/RaduBerinde","html_url":"https://github.com/RaduBerinde","followers_url":"https://api.github.com/users/RaduBerinde/followers","following_url":"https://api.github.com/users/RaduBerinde/following{/other_user}","gists_url":"https://api.github.com/users/RaduBerinde/gists{/gist_id}","starred_url":"https://api.github.com/users/RaduBerinde/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RaduBerinde/subscriptions","organizations_url":"https://api.github.com/users/RaduBerinde/orgs","repos_url":"https://api.github.com/users/RaduBerinde/repos","events_url":"https://api.github.com/users/RaduBerinde/events{/privacy}","received_events_url":"https://api.github.com/users/RaduBerinde/received_events","type":"User","site_admin":false},"created_at":"2016-06-30T19:05:12Z","updated_at":"2016-06-30T19:05:12Z","body":"@sploiselle - the indexes are stored as keys-values in our KV store which is ordered (we implement it on top of RocksDB which is an LSM tree). So they are not technically B-trees but it's the \"ordered\" property which is important and in that respect they are similar to B-trees.\r\n\r\nWe don't lock tables during index creation."}}
{"actor":{"display_login":"RaduBerinde"}}