{"action":"opened","issue":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/2190","repository_url":"https://api.github.com/repos/arangodb/arangodb","labels_url":"https://api.github.com/repos/arangodb/arangodb/issues/2190/labels{/name}","comments_url":"https://api.github.com/repos/arangodb/arangodb/issues/2190/comments","events_url":"https://api.github.com/repos/arangodb/arangodb/issues/2190/events","html_url":"https://github.com/arangodb/arangodb/issues/2190","id":191911676,"number":2190,"title":"Range queries on array index","user":{"login":"sajeevpr","id":7032262,"avatar_url":"https://avatars.githubusercontent.com/u/7032262?v=3","gravatar_id":"","url":"https://api.github.com/users/sajeevpr","html_url":"https://github.com/sajeevpr","followers_url":"https://api.github.com/users/sajeevpr/followers","following_url":"https://api.github.com/users/sajeevpr/following{/other_user}","gists_url":"https://api.github.com/users/sajeevpr/gists{/gist_id}","starred_url":"https://api.github.com/users/sajeevpr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sajeevpr/subscriptions","organizations_url":"https://api.github.com/users/sajeevpr/orgs","repos_url":"https://api.github.com/users/sajeevpr/repos","events_url":"https://api.github.com/users/sajeevpr/events{/privacy}","received_events_url":"https://api.github.com/users/sajeevpr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-11-28T03:23:05Z","updated_at":"2016-11-28T03:23:05Z","closed_at":null,"body":"Dear team,\r\n   We are using Arangodb 3.0.11 and was trying to run range queries in an array index.\r\nBut the query could not use the skiplist index created on history[*].cc when used '<' or '>'.\r\n\r\nIt used the skip list index only when I used the 'IN' operator.\r\n\r\n```\r\nQuery string:\r\n FOR acl IN Acl\r\n   FILTER \"2015-01-02\" IN acl.history[*].cc\r\n   RETURN acl\r\n\r\nExecution plan:\r\n Id   NodeType          Est.   Comment\r\n  1   SingletonNode        1   * ROOT\r\n  6   IndexNode       635660     - FOR acl IN Acl   /* skiplist index scan */\r\n  5   ReturnNode      635660       - RETURN acl\r\n\r\nIndexes used:\r\n By   Type       Collection   Unique   Sparse   Selectivity   Fields                Ranges\r\n  6   skiplist   Acl          false    false            n/a   [ `history[*].cc` ]   (\"2015-01-02\" in acl.`history`[*].`cc`)\r\n\r\nOptimization rules applied:\r\n Id   RuleName\r\n  1   use-indexes\r\n  2   remove-filter-covered-by-index\r\n  3   remove-unnecessary-calculations-2\r\n\r\n```\r\n\r\nBut the below one did not use any index.\r\n\r\n```\r\nQuery string:\r\n FOR acl IN Acl\r\n   FILTER \"2015-01-02\" < acl.history[*].cc\r\n   RETURN acl\r\n\r\nExecution plan:\r\n Id   NodeType                      Est.   Comment\r\n  1   SingletonNode                    1   * ROOT\r\n  2   EnumerateCollectionNode   12713205     - FOR acl IN Acl   /* full collection scan */\r\n  3   CalculationNode           12713205       - LET #3 = (\"2015-01-02\" < acl.`history`[*].`cc`)   /* simple expression */   /* collections used: acl : Acl */\r\n  4   FilterNode                12713205       - FILTER #3\r\n  5   ReturnNode                12713205       - RETURN acl\r\n\r\nIndexes used:\r\n none\r\n\r\nOptimization rules applied:\r\n none\r\n```\r\n\r\n\r\nIs this expected?\r\n\r\n\r\nRegards,\r\nSajeev"}}
{"actor":{"display_login":"sajeevpr"}}