{"action":"closed","issue":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/1866","repository_url":"https://api.github.com/repos/arangodb/arangodb","labels_url":"https://api.github.com/repos/arangodb/arangodb/issues/1866/labels{/name}","comments_url":"https://api.github.com/repos/arangodb/arangodb/issues/1866/comments","events_url":"https://api.github.com/repos/arangodb/arangodb/issues/1866/events","html_url":"https://github.com/arangodb/arangodb/issues/1866","id":159630635,"number":1866,"title":"LIMIT 0, 1 returns 0 documents whereas LIMIT 0, 2 returns 1.","user":{"login":"thwd-duda","id":16421096,"avatar_url":"https://avatars.githubusercontent.com/u/16421096?v=3","gravatar_id":"","url":"https://api.github.com/users/thwd-duda","html_url":"https://github.com/thwd-duda","followers_url":"https://api.github.com/users/thwd-duda/followers","following_url":"https://api.github.com/users/thwd-duda/following{/other_user}","gists_url":"https://api.github.com/users/thwd-duda/gists{/gist_id}","starred_url":"https://api.github.com/users/thwd-duda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thwd-duda/subscriptions","organizations_url":"https://api.github.com/users/thwd-duda/orgs","repos_url":"https://api.github.com/users/thwd-duda/repos","events_url":"https://api.github.com/users/thwd-duda/events{/privacy}","received_events_url":"https://api.github.com/users/thwd-duda/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-06-10T13:04:20Z","updated_at":"2016-06-10T13:10:45Z","closed_at":"2016-06-10T13:10:45Z","body":"I am executing the following query:\r\n```\r\nFOR o IN iNlbRILoxUd LIMIT 0, 1 FILTER o._key == \"lVxIycCeLdCB\" RETURN o\r\n```\r\nAnd getting 0 results.\r\n\r\nIf I change the `LIMIT`-clause to `LIMIT 0, 2`, then I get one result. Which is what I expected to get using `LIMIT 0, 1`.\r\n\r\n`iNlbRILoxUd` is a loaded, non-system, non-erroneous document-collection where `allowUserKeys` is enabled and using the traditional key-type.\r\n\r\n```\r\n~$ arangod --version\r\narchitecture: 64bit\r\nbuild-date: 2016-05-14 08:27:23\r\nconfigure:  './configure' 'CC=gcc' 'CXX=g++' 'CFLAGS=-g -O3 -fomit-frame-pointer' 'CXXFLAGS=-g -O3 -fomit-frame-pointer' '--enable-gold' '--enable-tcmalloc' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/lib' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--enable-all-in-one-etcd' '--enable-internal-go'\r\nenv:  CFLAGS='-g -O3 -fomit-frame-pointer' CXXFLAGS='-g -O3 -fomit-frame-pointer' CC='gcc' CXX='g++'\r\nfd-client-event-handler: poll\r\nfd-setsize: 1024\r\nicu-version: 54.1\r\nlibev-version: 4.11\r\nmaintainer-mode: false\r\nopenssl-version: OpenSSL 1.0.2d 9 Jul 2015\r\nserver-version: 2.8.9\r\nsizeof int: 4\r\nsizeof void*: 8\r\ntcmalloc: true\r\nv8-version: 4.3.61\r\n```\r\n```\r\n~$ lsb_release -a\r\nNo LSB modules are available.\r\nDistributor ID:\tUbuntu\r\nDescription:\tUbuntu 15.10\r\nRelease:\t15.10\r\nCodename:\twily\r\n```"}}
{"actor":{"display_login":"mchacki"}}