{"action":"created","issue":{"url":"https://api.github.com/repos/pingcap/tidb/issues/1431","repository_url":"https://api.github.com/repos/pingcap/tidb","labels_url":"https://api.github.com/repos/pingcap/tidb/issues/1431/labels{/name}","comments_url":"https://api.github.com/repos/pingcap/tidb/issues/1431/comments","events_url":"https://api.github.com/repos/pingcap/tidb/issues/1431/events","html_url":"https://github.com/pingcap/tidb/issues/1431","id":165010711,"node_id":"MDU6SXNzdWUxNjUwMTA3MTE=","number":1431,"title":"Check field length when doing DDL.","user":{"login":"shenli","id":1192573,"node_id":"MDQ6VXNlcjExOTI1NzM=","avatar_url":"https://avatars0.githubusercontent.com/u/1192573?v=4","gravatar_id":"","url":"https://api.github.com/users/shenli","html_url":"https://github.com/shenli","followers_url":"https://api.github.com/users/shenli/followers","following_url":"https://api.github.com/users/shenli/following{/other_user}","gists_url":"https://api.github.com/users/shenli/gists{/gist_id}","starred_url":"https://api.github.com/users/shenli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shenli/subscriptions","organizations_url":"https://api.github.com/users/shenli/orgs","repos_url":"https://api.github.com/users/shenli/repos","events_url":"https://api.github.com/users/shenli/events{/privacy}","received_events_url":"https://api.github.com/users/shenli/received_events","type":"User","site_admin":false},"labels":[{"id":256872089,"node_id":"MDU6TGFiZWwyNTY4NzIwODk=","url":"https://api.github.com/repos/pingcap/tidb/labels/help%20wanted","name":"help wanted","color":"159818","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-07-12T07:22:53Z","updated_at":"2018-11-24T21:36:23Z","closed_at":"2018-11-24T21:36:23Z","author_association":"MEMBER","body":"--error ER_TOO_BIG_FIELDLENGTH\nCREATE TABLE b15776 (a char(4294967295));\n\n\"M × w bytes, 0 <= M <= 255, where w is the number of bytes required for the maximum-length character in the character set. See Section 15.8.3, “Physical Row Structure of InnoDB Tables” for information about CHAR data type storage requirements for InnoDB tables.\"\nSee: http://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html\n"},"comment":{"url":"https://api.github.com/repos/pingcap/tidb/issues/comments/441397294","html_url":"https://github.com/pingcap/tidb/issues/1431#issuecomment-441397294","issue_url":"https://api.github.com/repos/pingcap/tidb/issues/1431","id":441397294,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTM5NzI5NA==","user":{"login":"morgo","id":57982,"node_id":"MDQ6VXNlcjU3OTgy","avatar_url":"https://avatars2.githubusercontent.com/u/57982?v=4","gravatar_id":"","url":"https://api.github.com/users/morgo","html_url":"https://github.com/morgo","followers_url":"https://api.github.com/users/morgo/followers","following_url":"https://api.github.com/users/morgo/following{/other_user}","gists_url":"https://api.github.com/users/morgo/gists{/gist_id}","starred_url":"https://api.github.com/users/morgo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/morgo/subscriptions","organizations_url":"https://api.github.com/users/morgo/orgs","repos_url":"https://api.github.com/users/morgo/repos","events_url":"https://api.github.com/users/morgo/events{/privacy}","received_events_url":"https://api.github.com/users/morgo/received_events","type":"User","site_admin":false},"created_at":"2018-11-24T21:36:23Z","updated_at":"2018-11-24T21:36:23Z","author_association":"MEMBER","body":"I believe this has been fixed:\r\n```\r\nMySQL [test]> CREATE TABLE b15776 (a char(4294967295));\r\nERROR 1074 (42000): Column length too big for column 'a' (max = 255); use BLOB or TEXT instead\r\n```\r\n\r\nI am going to close this issue now.  Please feel free to re-open it if you have any questions.  Thanks!"}}
{"actor":{"display_login":"morgo"}}