{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/33260","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/33260/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/33260/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/33260/events","html_url":"https://github.com/cockroachdb/cockroach/issues/33260","id":392494392,"node_id":"MDU6SXNzdWUzOTI0OTQzOTI=","number":33260,"title":"sql: UPDATE while schema change can result in error","user":{"login":"dendon","id":18039715,"node_id":"MDQ6VXNlcjE4MDM5NzE1","avatar_url":"https://avatars3.githubusercontent.com/u/18039715?v=4","gravatar_id":"","url":"https://api.github.com/users/dendon","html_url":"https://github.com/dendon","followers_url":"https://api.github.com/users/dendon/followers","following_url":"https://api.github.com/users/dendon/following{/other_user}","gists_url":"https://api.github.com/users/dendon/gists{/gist_id}","starred_url":"https://api.github.com/users/dendon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dendon/subscriptions","organizations_url":"https://api.github.com/users/dendon/orgs","repos_url":"https://api.github.com/users/dendon/repos","events_url":"https://api.github.com/users/dendon/events{/privacy}","received_events_url":"https://api.github.com/users/dendon/received_events","type":"User","site_admin":false},"labels":[{"id":1002858167,"node_id":"MDU6TGFiZWwxMDAyODU4MTY3","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/A-schema-changes","name":"A-schema-changes","color":"22c97b","default":false},{"id":922047169,"node_id":"MDU6TGFiZWw5MjIwNDcxNjk=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/A-sql-mutations","name":"A-sql-mutations","color":"22aa88","default":false},{"id":78928345,"node_id":"MDU6TGFiZWw3ODkyODM0NQ==","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/C-bug","name":"C-bug","color":"c5def5","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-12-19T08:42:39Z","updated_at":"2018-12-19T14:37:06Z","closed_at":null,"author_association":"NONE","body":"**Describe the problem**\r\n\r\ndoing UPDATEs can result in errors while a CREATE INDEX is running.\r\n\r\nerror message & query:\r\n```\r\nERROR:  value type is not BYTES: UNKNOWN\r\nUPDATE \"cache\" SET \"value\" = $1, \"updated\" = $2, \"expires\" = $3 WHERE \"id\" = $4\r\n```\r\nschema:\r\n```\r\nCREATE TABLE cache\r\n(\r\n  id SERIAL PRIMARY KEY\r\n);\r\n\r\nALTER TABLE cache ADD COLUMN method STRING NOT NULL DEFAULT '' CREATE IF NOT EXISTS FAMILY family_method;\r\nALTER TABLE cache ADD COLUMN name STRING NOT NULL DEFAULT '' CREATE IF NOT EXISTS FAMILY family_name;\r\nALTER TABLE cache ADD COLUMN value STRING NOT NULL DEFAULT '' CREATE IF NOT EXISTS FAMILY family_value;\r\nALTER TABLE cache ADD COLUMN locked INT NOT NULL DEFAULT 0 CREATE IF NOT EXISTS FAMILY family_locked;\r\nALTER TABLE cache ADD COLUMN created INT NOT NULL DEFAULT 0 CREATE IF NOT EXISTS FAMILY family_created;\r\nALTER TABLE cache ADD COLUMN updated INT NOT NULL DEFAULT 0 CREATE IF NOT EXISTS FAMILY family_updated;\r\nALTER TABLE cache ADD COLUMN expires INT NOT NULL DEFAULT 0 CREATE IF NOT EXISTS FAMILY family_expires;\r\n\r\nCREATE INDEX method_name ON cache (method, name);\r\n```\r\n\r\nschema change:\r\n```\r\nCREATE INDEX method_name_storing_value ON cache (method, name) STORING (value);\r\n```\r\n\r\n**Environment:**\r\nCockroachDB CCL v2.1.2 (x86_64-unknown-linux-gnu, built 2018/12/10 20:15:47, go1.10.3)\r\n"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/448617487","html_url":"https://github.com/cockroachdb/cockroach/issues/33260#issuecomment-448617487","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/33260","id":448617487,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0ODYxNzQ4Nw==","user":{"login":"knz","id":642886,"node_id":"MDQ6VXNlcjY0Mjg4Ng==","avatar_url":"https://avatars3.githubusercontent.com/u/642886?v=4","gravatar_id":"","url":"https://api.github.com/users/knz","html_url":"https://github.com/knz","followers_url":"https://api.github.com/users/knz/followers","following_url":"https://api.github.com/users/knz/following{/other_user}","gists_url":"https://api.github.com/users/knz/gists{/gist_id}","starred_url":"https://api.github.com/users/knz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/knz/subscriptions","organizations_url":"https://api.github.com/users/knz/orgs","repos_url":"https://api.github.com/users/knz/repos","events_url":"https://api.github.com/users/knz/events{/privacy}","received_events_url":"https://api.github.com/users/knz/received_events","type":"User","site_admin":false},"created_at":"2018-12-19T14:37:06Z","updated_at":"2018-12-19T14:37:06Z","author_association":"MEMBER","body":"cc @vivekmenezes we'll need to investigate this too"}}
{"actor":{"display_login":"knz"}}