{"action":"opened","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6820","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6820/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6820/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6820/events","html_url":"https://github.com/orientechnologies/orientdb/issues/6820","id":183415352,"number":6820,"title":"documentation of substring() is incorrect","user":{"login":"rdelangh","id":15123823,"avatar_url":"https://avatars.githubusercontent.com/u/15123823?v=3","gravatar_id":"","url":"https://api.github.com/users/rdelangh","html_url":"https://github.com/rdelangh","followers_url":"https://api.github.com/users/rdelangh/followers","following_url":"https://api.github.com/users/rdelangh/following{/other_user}","gists_url":"https://api.github.com/users/rdelangh/gists{/gist_id}","starred_url":"https://api.github.com/users/rdelangh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rdelangh/subscriptions","organizations_url":"https://api.github.com/users/rdelangh/orgs","repos_url":"https://api.github.com/users/rdelangh/repos","events_url":"https://api.github.com/users/rdelangh/events{/privacy}","received_events_url":"https://api.github.com/users/rdelangh/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-10-17T13:25:37Z","updated_at":"2016-10-17T13:25:37Z","closed_at":null,"body":"## OrientDB Version, operating system, or hardware.\r\nall\r\n\r\nThe documentation about 'substring' in all versions about Methods (http://orientdb.com/docs/master/SQL-Methods.html) is incorrect : \r\n\r\nIt now says : \r\n\r\nReturns a substring of the original cutting from 'begin' and getting 'length' characters. 'begin' starts from 0 to string length - 1.\r\n\r\nThe second parameter of this function, is not the length of the substring to be returned, but the end-position of the original string.\r\n\r\nSELECT 'abcdef'.substring(2,2) FROM ...\r\nreturns nothing whereas according to the documentation this should be 'cd'\r\n\r\nSELECT 'abcdef'.substring(2,3) FROM ...\r\nreturns 'c' whereas according to the documentation this should be 'cde'\r\n\r\nSELECT 'abcdef'.substring(2,4) FROM ...\r\nreturns 'cd' whereas according to the documentation this should be 'cdef'"}}
{"actor":{"display_login":"rdelangh"}}