{"action":"created","issue":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/2089","repository_url":"https://api.github.com/repos/arangodb/arangodb","labels_url":"https://api.github.com/repos/arangodb/arangodb/issues/2089/labels{/name}","comments_url":"https://api.github.com/repos/arangodb/arangodb/issues/2089/comments","events_url":"https://api.github.com/repos/arangodb/arangodb/issues/2089/events","html_url":"https://github.com/arangodb/arangodb/issues/2089","id":181524060,"number":2089,"title":"cant use FLOOR and RAND in LIMIT","user":{"login":"akhilbatra898","id":6381580,"avatar_url":"https://avatars.githubusercontent.com/u/6381580?v=3","gravatar_id":"","url":"https://api.github.com/users/akhilbatra898","html_url":"https://github.com/akhilbatra898","followers_url":"https://api.github.com/users/akhilbatra898/followers","following_url":"https://api.github.com/users/akhilbatra898/following{/other_user}","gists_url":"https://api.github.com/users/akhilbatra898/gists{/gist_id}","starred_url":"https://api.github.com/users/akhilbatra898/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akhilbatra898/subscriptions","organizations_url":"https://api.github.com/users/akhilbatra898/orgs","repos_url":"https://api.github.com/users/akhilbatra898/repos","events_url":"https://api.github.com/users/akhilbatra898/events{/privacy}","received_events_url":"https://api.github.com/users/akhilbatra898/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-10-06T20:59:16Z","updated_at":"2016-10-07T07:13:42Z","closed_at":null,"body":"## my environment running ArangoDB\r\nI'm using the latest ArangoDB of the respective release series:\r\n- [ ] 2.8\r\n- [ 1] 3.0\r\n- [ ] self-compiled devel branch\r\n\r\nOn this operating system:\r\n- [ ] DCOS on\r\n  - [ ] AWS\r\n  - [ ] Azure\r\n  - [ ] own infrastructure\r\n- [ ] Linux \r\n  - [ ] Debian .deb\r\n  - [1 ] Ubuntu .deb\r\n  - [ ] SUSE   .rpm\r\n  - [ ] RedHat .rpm\r\n  - [ ] Fedora .rpm\r\n  - [ ] Gentoo\r\n  - [ ] docker - official docker library\r\n  - [ ] other:\r\n- [ ] Windows, version: \r\n- [ ] MacOS, version:\r\n\r\n### this is an AQL-related issue:\r\n[ ] I'm using graph features\r\n\r\nI'm issuing AQL via:\r\n- [ ] web interface with this browser:     running on this OS:\r\n- [ 1] arangosh\r\n- [ ] this Driver:\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nThe following problem occurs: \r\ni run this command in arangosh\r\nbut it gives error\r\n`db._query('FOR v in profiles LIMIT FLOOR(RAND()+1),1 RETURN v._key').toArray()`\r\n\r\n\r\nInstead I would be expecting: \r\n\r\na random vertex with its key\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/comments/252169532","html_url":"https://github.com/arangodb/arangodb/issues/2089#issuecomment-252169532","issue_url":"https://api.github.com/repos/arangodb/arangodb/issues/2089","id":252169532,"user":{"login":"akhilbatra898","id":6381580,"avatar_url":"https://avatars.githubusercontent.com/u/6381580?v=3","gravatar_id":"","url":"https://api.github.com/users/akhilbatra898","html_url":"https://github.com/akhilbatra898","followers_url":"https://api.github.com/users/akhilbatra898/followers","following_url":"https://api.github.com/users/akhilbatra898/following{/other_user}","gists_url":"https://api.github.com/users/akhilbatra898/gists{/gist_id}","starred_url":"https://api.github.com/users/akhilbatra898/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akhilbatra898/subscriptions","organizations_url":"https://api.github.com/users/akhilbatra898/orgs","repos_url":"https://api.github.com/users/akhilbatra898/repos","events_url":"https://api.github.com/users/akhilbatra898/events{/privacy}","received_events_url":"https://api.github.com/users/akhilbatra898/received_events","type":"User","site_admin":false},"created_at":"2016-10-07T07:13:42Z","updated_at":"2016-10-07T07:13:42Z","body":"I am aware of this way. \r\nBut sort is expensive. For every single query sort cost will be added. And i have million nodes in database"}}
{"actor":{"display_login":"akhilbatra898"}}