{"action":"created","issue":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/6728","repository_url":"https://api.github.com/repos/arangodb/arangodb","labels_url":"https://api.github.com/repos/arangodb/arangodb/issues/6728/labels{/name}","comments_url":"https://api.github.com/repos/arangodb/arangodb/issues/6728/comments","events_url":"https://api.github.com/repos/arangodb/arangodb/issues/6728/events","html_url":"https://github.com/arangodb/arangodb/issues/6728","id":366979215,"node_id":"MDU6SXNzdWUzNjY5NzkyMTU=","number":6728,"title":"Aggeragate function MAX() returns empty values","user":{"login":"vlabmichl","id":877285,"node_id":"MDQ6VXNlcjg3NzI4NQ==","avatar_url":"https://avatars3.githubusercontent.com/u/877285?v=4","gravatar_id":"","url":"https://api.github.com/users/vlabmichl","html_url":"https://github.com/vlabmichl","followers_url":"https://api.github.com/users/vlabmichl/followers","following_url":"https://api.github.com/users/vlabmichl/following{/other_user}","gists_url":"https://api.github.com/users/vlabmichl/gists{/gist_id}","starred_url":"https://api.github.com/users/vlabmichl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vlabmichl/subscriptions","organizations_url":"https://api.github.com/users/vlabmichl/orgs","repos_url":"https://api.github.com/users/vlabmichl/repos","events_url":"https://api.github.com/users/vlabmichl/events{/privacy}","received_events_url":"https://api.github.com/users/vlabmichl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-10-04T21:32:26Z","updated_at":"2018-10-05T07:40:37Z","closed_at":null,"author_association":"NONE","body":"## My Environment\r\n\r\n* __ArangoDB Version__: 3.3.14        <!-- e.g. 3.3.14 or self-compiled devel branch -->\r\n* __Storage Engine__: MMFiles             <!-- MMFiles / RocksDB -->\r\n* __Deployment Mode__:  Single Server     <!-- Single Server | Master/Slave | Active Failover | Cluster | DC2DC -->\r\n* __Deployment Strategy__: Manual Start in Docker  <!-- Manual Start | Manual Start in Docker | ArangoDB Starter | ArangoDB Starter in Docker | Kubernetes | DCOS -->\r\n* __Configuration__:               <!-- cluster setup details, notable server settings, etc. -->\r\n* __Infrastructure__:   own            <!-- AWS | Azure | ... | own -->\r\n* __Operating System__:  Debian       <!-- Ubuntu 18.04 | Windows 10 | MacOS 10.13.4 | DCOS 1.10 | ... -->\r\n* __Used Package__:   Docker official           <!-- Debian or Ubuntu .deb | SUSE or RedHat .rpm | Docker - official Docker library | other -->\r\n\r\n## Component, Query & Data\r\n\r\n__Affected feature__: AQL\r\n<!-- e.g. Installation | Foxx | AQL query using web interface | arangosh | with driver | ... -->\r\n\r\n\r\n__AQL query (if applicable)__:\r\n```aql\r\nFOR ke IN knoten_extern\r\n    COLLECT AGGREGATE\r\n    hwMin = MIN(ke.hw),\r\n    hwMax = MAX(ke.hw),\r\n    rwMin = MIN(ke.rw),\r\n    rwMax = MAX(ke.rw)\r\nRETURN { hwMin, hwMax, rwMin, rwMax }\r\n```\r\n\r\nResult:\r\n```\r\n[\r\n  {\r\n    \"hwMin\": 47.43814309,\r\n    \"hwMax\": \"\",\r\n    \"rwMin\": 10.2337726,\r\n    \"rwMax\": \"\"\r\n  }\r\n]\r\n```\r\n__AQL explain (if applicable)__:\r\n<!-- output of  db._explain(\"<my aql query>\") -->\r\n```\r\nQuery string:\r\n FOR ke IN knoten_extern\r\n     COLLECT AGGREGATE\r\n     hwMin = MIN(ke.hw),\r\n     hwMax = MAX(ke.hw),\r\n     rwMin = MIN(ke.rw),\r\n     rwMax = MAX(ke.rw)\r\n RETURN { hwMin, hwMax, rwMin, rwMax }\r\n\r\nExecution plan:\r\n Id   NodeType                   Est.   Comment\r\n  1   SingletonNode                 1   * ROOT\r\n  2   EnumerateCollectionNode   27253     - FOR ke IN knoten_extern   /* full collection scan */\r\n  3   CalculationNode           27253       - LET #5 = ke.`hw`   /* attribute expression */   /* collections used: ke : knoten_extern */\r\n  5   CalculationNode           27253       - LET #9 = ke.`rw`   /* attribute expression */   /* collections used: ke : knoten_extern */\r\n  7   CollectNode               21802       - COLLECT AGGREGATE hwMin = MIN(#5), hwMax = MAX(#5), rwMin = MIN(#9), rwMax = MAX(#9)   /* sorted */\r\n  8   CalculationNode           21802       - LET #13 = { \"hwMin\" : hwMin, \"hwMax\" : hwMax, \"rwMin\" : rwMin, \"rwMax\" : rwMax }   /* simple expression */\r\n  9   ReturnNode                21802       - RETURN #13\r\n\r\nIndexes used:\r\n none\r\n\r\nOptimization rules applied:\r\n Id   RuleName\r\n  1   move-calculations-up\r\n  2   remove-redundant-calculations\r\n  3   remove-unnecessary-calculations\r\n  4   move-calculations-up-2\r\n```\r\n\r\n__Dataset__:\r\n<!-- description, or if possible, please share an example dataset to reproduce the issue either as Gist with an arangodump, or an arangosh script with db.collection.save({my: \"values\"}) statements -->\r\nKnotenExtern holds GeoCoords stored as floats in \"hw\" and \"rw\" fields.\r\n\r\n__Replication Factor & Number of Shards (Cluster only)__:\r\n<!-- please list these settings for each collection in question -->\r\n\r\n\r\n## Steps to reproduce\r\n\r\nExecute the the query against datasets.\r\n\r\n__Problem__:\r\nMAX() results are empty.\r\n\r\n__Expected result__:\r\nMAX() should be filled at least with the MIN() values (if they were the same by accident).\r\n"},"comment":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/comments/427274693","html_url":"https://github.com/arangodb/arangodb/issues/6728#issuecomment-427274693","issue_url":"https://api.github.com/repos/arangodb/arangodb/issues/6728","id":427274693,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNzI3NDY5Mw==","user":{"login":"vlabmichl","id":877285,"node_id":"MDQ6VXNlcjg3NzI4NQ==","avatar_url":"https://avatars3.githubusercontent.com/u/877285?v=4","gravatar_id":"","url":"https://api.github.com/users/vlabmichl","html_url":"https://github.com/vlabmichl","followers_url":"https://api.github.com/users/vlabmichl/followers","following_url":"https://api.github.com/users/vlabmichl/following{/other_user}","gists_url":"https://api.github.com/users/vlabmichl/gists{/gist_id}","starred_url":"https://api.github.com/users/vlabmichl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vlabmichl/subscriptions","organizations_url":"https://api.github.com/users/vlabmichl/orgs","repos_url":"https://api.github.com/users/vlabmichl/repos","events_url":"https://api.github.com/users/vlabmichl/events{/privacy}","received_events_url":"https://api.github.com/users/vlabmichl/received_events","type":"User","site_admin":false},"created_at":"2018-10-05T07:40:37Z","updated_at":"2018-10-05T07:40:37Z","author_association":"NONE","body":"@jsteemann I updated issue description with the result.\r\n\r\nThe weird thing for me is that `MIN()` returns a valid result and `MAX()` is simply empty."}}
{"actor":{"display_login":"vlabmichl"}}