{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5153","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5153/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5153/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5153/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5153","id":112099914,"number":5153,"title":"OrderBy and Limit - wrong order?","user":{"login":"andreashannig","id":11479315,"avatar_url":"https://avatars.githubusercontent.com/u/11479315?v=3","gravatar_id":"","url":"https://api.github.com/users/andreashannig","html_url":"https://github.com/andreashannig","followers_url":"https://api.github.com/users/andreashannig/followers","following_url":"https://api.github.com/users/andreashannig/following{/other_user}","gists_url":"https://api.github.com/users/andreashannig/gists{/gist_id}","starred_url":"https://api.github.com/users/andreashannig/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andreashannig/subscriptions","organizations_url":"https://api.github.com/users/andreashannig/orgs","repos_url":"https://api.github.com/users/andreashannig/repos","events_url":"https://api.github.com/users/andreashannig/events{/privacy}","received_events_url":"https://api.github.com/users/andreashannig/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"luigidellaquila","id":459289,"avatar_url":"https://avatars.githubusercontent.com/u/459289?v=3","gravatar_id":"","url":"https://api.github.com/users/luigidellaquila","html_url":"https://github.com/luigidellaquila","followers_url":"https://api.github.com/users/luigidellaquila/followers","following_url":"https://api.github.com/users/luigidellaquila/following{/other_user}","gists_url":"https://api.github.com/users/luigidellaquila/gists{/gist_id}","starred_url":"https://api.github.com/users/luigidellaquila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luigidellaquila/subscriptions","organizations_url":"https://api.github.com/users/luigidellaquila/orgs","repos_url":"https://api.github.com/users/luigidellaquila/repos","events_url":"https://api.github.com/users/luigidellaquila/events{/privacy}","received_events_url":"https://api.github.com/users/luigidellaquila/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/64","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.1.x%20(next%20hotfix)","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/64/labels","id":1282180,"number":64,"title":"2.1.x (next hotfix)","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":132,"closed_issues":9,"state":"open","created_at":"2015-08-31T15:18:49Z","updated_at":"2015-10-20T13:06:59Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2015-10-19T08:44:32Z","updated_at":"2015-10-20T13:06:59Z","closed_at":"2015-10-20T13:06:59Z","body":"In the GratefulDeadConcerts database (Version 2.1.4) the query\r\n```\r\nselect expand(out('sung_by')) from v order by name desc\r\n```\r\ncalculates the result (1):\r\n\r\nrid | name\r\n------------ | -------------\r\n# 9:156 | Weir_Hart\r\n# 9:61 | Weir\r\n... | ...\r\n\r\nWhen adding a limit \r\n```\r\nselect expand(out('sung_by')) from v order by name desc *limit 2*\r\n```\r\ni expected to receive the first two records from (1). Instead the query returns\r\n\r\nrid | name\r\n------------ | -------------\r\n# 9:74 | Spencer_Davis\r\n# 9:8 | Garcia\r\n\r\nIs this a bug or is there an error in the query?"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/149562202","html_url":"https://github.com/orientechnologies/orientdb/issues/5153#issuecomment-149562202","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5153","id":149562202,"user":{"login":"luigidellaquila","id":459289,"avatar_url":"https://avatars.githubusercontent.com/u/459289?v=3","gravatar_id":"","url":"https://api.github.com/users/luigidellaquila","html_url":"https://github.com/luigidellaquila","followers_url":"https://api.github.com/users/luigidellaquila/followers","following_url":"https://api.github.com/users/luigidellaquila/following{/other_user}","gists_url":"https://api.github.com/users/luigidellaquila/gists{/gist_id}","starred_url":"https://api.github.com/users/luigidellaquila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luigidellaquila/subscriptions","organizations_url":"https://api.github.com/users/luigidellaquila/orgs","repos_url":"https://api.github.com/users/luigidellaquila/repos","events_url":"https://api.github.com/users/luigidellaquila/events{/privacy}","received_events_url":"https://api.github.com/users/luigidellaquila/received_events","type":"User","site_admin":false},"created_at":"2015-10-20T13:06:59Z","updated_at":"2015-10-20T13:06:59Z","body":"fixed also in develop branch.\r\nClosing, please reopen if I missed something\r\n\r\nThanks\r\n\r\nLuigi"}}