{"action":"created","issue":{"url":"https://api.github.com/repos/pingcap/tidb/issues/310","repository_url":"https://api.github.com/repos/pingcap/tidb","labels_url":"https://api.github.com/repos/pingcap/tidb/issues/310/labels{/name}","comments_url":"https://api.github.com/repos/pingcap/tidb/issues/310/comments","events_url":"https://api.github.com/repos/pingcap/tidb/issues/310/events","html_url":"https://github.com/pingcap/tidb/issues/310","id":110143847,"number":310,"title":"string function support ","user":{"login":"siddontang","id":1080370,"avatar_url":"https://avatars.githubusercontent.com/u/1080370?v=3","gravatar_id":"","url":"https://api.github.com/users/siddontang","html_url":"https://github.com/siddontang","followers_url":"https://api.github.com/users/siddontang/followers","following_url":"https://api.github.com/users/siddontang/following{/other_user}","gists_url":"https://api.github.com/users/siddontang/gists{/gist_id}","starred_url":"https://api.github.com/users/siddontang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/siddontang/subscriptions","organizations_url":"https://api.github.com/users/siddontang/orgs","repos_url":"https://api.github.com/users/siddontang/repos","events_url":"https://api.github.com/users/siddontang/events{/privacy}","received_events_url":"https://api.github.com/users/siddontang/received_events","type":"User","site_admin":false},"labels":[{"id":257000644,"url":"https://api.github.com/repos/pingcap/tidb/labels/easy","name":"easy","color":"bfe5bf","default":false},{"id":256872089,"url":"https://api.github.com/repos/pingcap/tidb/labels/help%20wanted","name":"help wanted","color":"159818","default":true},{"id":257000608,"url":"https://api.github.com/repos/pingcap/tidb/labels/todo","name":"todo","color":"207de5","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2015-10-07T03:05:46Z","updated_at":"2016-12-09T10:07:20Z","closed_at":null,"body":"- [x] ASCII() Return numeric value of left-most character\n- [ ] BIN()   Return a string containing binary representation of a number\n- [ ] BIT_LENGTH()    Return length of argument in bits\n- [ ] CHAR_LENGTH()   Return number of characters in argument\n- [ ] CHAR()  Return the character for each integer passed\n- [ ] CHARACTER_LENGTH()  Synonym for CHAR_LENGTH()\n- [x] CONCAT_WS() Return concatenate with separator\n- [x] CONCAT()    Return concatenated string\n- [ ] ELT()   Return string at index number\n- [ ] EXPORT_SET()    Return a string such that for every bit set in the value bits, you get an on string and for every unset bit, you get - [ ] an off string\n- [ ] FIELD() Return the index (position) of the first argument in the subsequent arguments\n- [ ] FIND_IN_SET()   Return the index position of the first argument within the second argument\n- [ ] FORMAT()    Return a number formatted to specified number of decimal places\n- [ ] HEX()   Return a hexadecimal representation of a decimal or string value\n- [ ] INSERT()    Insert a substring at the specified position up to the specified number of characters\n- [ ] INSTR() Return the index of the first occurrence of substring\n- [ ] LCASE() Synonym for LOWER()\n- [ ] LEFT()  Return the leftmost number of characters as specified\n- [ ] LENGTH()    Return the length of a string in bytes\n- [ ] LIKE    Simple pattern matching\n- [ ] LOAD_FILE() Load the named file\n- [ ] LOCATE()    Return the position of the first occurrence of substring\n- [x] LOWER() Return the argument in lowercase\n- [ ] LPAD()  Return the string argument, left-padded with the specified string\n- [ ] LTRIM() Remove leading spaces\n- [ ] MAKE_SET()  Return a set of comma-separated strings that have the corresponding bit in bits set\n- [ ] MATCH   Perform full-text search\n- [ ] MID()   Return a substring starting from the specified position\n- [ ] NOT LIKE    Negation of simple pattern matching\n- [ ] NOT REGEXP  Negation of REGEXP\n- [ ] OCT()   Return a string containing octal representation of a number\n- [ ] OCTET_LENGTH()  Synonym for LENGTH()\n- [ ] ORD()   Return character code for leftmost character of the argument\n- [ ] POSITION()  Synonym for LOCATE()\n- [ ] QUOTE() Escape the argument for use in an SQL statement\n- [ ] REGEXP  Pattern matching using regular expressions\n- [ ] REPEAT()    Repeat a string the specified number of times\n- [x] REPLACE()   Replace occurrences of a specified string\n- [x] REVERSE()   Reverse the characters in a string\n- [ ] RIGHT() Return the specified rightmost number of characters\n- [ ] RLIKE   Synonym for REGEXP\n- [ ] RPAD()  Append string the specified number of times\n- [ ] RTRIM() Remove trailing spaces\n- [ ] SOUNDEX()   Return a soundex string\n- [ ] SOUNDS LIKE Compare sounds\n- [x] SPACE() Return a string of the specified number of spaces\n- [x] STRCMP()    Compare two strings\n- [ ] SUBSTR()    Return the substring as specified\n- [x] SUBSTRING_INDEX()   Return a substring from a string before the specified number of occurrences of the delimiter\n- [x] SUBSTRING() Return the substring as specified\n- [x] TRIM()  Remove leading and trailing spaces\n- [ ] UCASE() Synonym for UPPER()\n- [ ] UNHEX() Return a string containing hex representation of a number\n- [x] UPPER() Convert to uppercase\n"},"comment":{"url":"https://api.github.com/repos/pingcap/tidb/issues/comments/265978041","html_url":"https://github.com/pingcap/tidb/issues/310#issuecomment-265978041","issue_url":"https://api.github.com/repos/pingcap/tidb/issues/310","id":265978041,"user":{"login":"coocood","id":891222,"avatar_url":"https://avatars.githubusercontent.com/u/891222?v=3","gravatar_id":"","url":"https://api.github.com/users/coocood","html_url":"https://github.com/coocood","followers_url":"https://api.github.com/users/coocood/followers","following_url":"https://api.github.com/users/coocood/following{/other_user}","gists_url":"https://api.github.com/users/coocood/gists{/gist_id}","starred_url":"https://api.github.com/users/coocood/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coocood/subscriptions","organizations_url":"https://api.github.com/users/coocood/orgs","repos_url":"https://api.github.com/users/coocood/repos","events_url":"https://api.github.com/users/coocood/events{/privacy}","received_events_url":"https://api.github.com/users/coocood/received_events","type":"User","site_admin":false},"created_at":"2016-12-09T10:07:20Z","updated_at":"2016-12-09T10:07:20Z","body":"@a6802739 \r\nIt seems like you haven't forked tidb yet.\r\nPlease describe what you have done and what error you have got, thank you."}}
{"actor":{"display_login":"coocood"}}