{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/4360","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/4360/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/4360/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/4360/events","html_url":"https://github.com/influxdb/influxdb/issues/4360","id":110296236,"number":4360,"title":"Aggregation functions: MAX and MIN strange behaviour","user":{"login":"syepes","id":333081,"avatar_url":"https://avatars.githubusercontent.com/u/333081?v=3","gravatar_id":"","url":"https://api.github.com/users/syepes","html_url":"https://github.com/syepes","followers_url":"https://api.github.com/users/syepes/followers","following_url":"https://api.github.com/users/syepes/following{/other_user}","gists_url":"https://api.github.com/users/syepes/gists{/gist_id}","starred_url":"https://api.github.com/users/syepes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/syepes/subscriptions","organizations_url":"https://api.github.com/users/syepes/orgs","repos_url":"https://api.github.com/users/syepes/repos","events_url":"https://api.github.com/users/syepes/events{/privacy}","received_events_url":"https://api.github.com/users/syepes/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-07T19:11:03Z","updated_at":"2015-10-08T04:25:52Z","closed_at":null,"body":"Hello,\r\n\r\nI have just encountered a strange behavior when using the aggregate functions MAX and MIN together in the same query, as we can observe in the below example the result of the MAX function is the same as the MIN.\r\n\r\nAnyone know why is the happening? \r\n\r\nQuery:\r\n```\r\nSELECT MAX(value), MIN(value), COUNT(value) FROM \"cpu_coreUtilization_average-percent\" WHERE time >= now() - 2h AND instance = 'avg' AND \"server\" = 'xxx' GROUP BY time(30m), \"server\"\r\n```\r\n\r\nQuery with both MAX & MIN:\r\n```\r\nname: cpu_coreUtilization_average-percent\r\ntags: server=xxx\r\ntime                    max     min     count\r\n----                    ---     ---     -----\r\n1444235400000000000     3817    3817    38\r\n1444237200000000000     3638    3638    90\r\n1444239000000000000     3569    3569    90\r\n1444240800000000000     3665    3665    90\r\n1444242600000000000     3771    3771    23\r\n```\r\n\r\nQuery with only MIN:\r\n```\r\nname: cpu_coreUtilization_average-percent\r\ntags: server=xxx\r\ntime                    min     count\r\n----                    ---     -----\r\n1444235400000000000     3817    38\r\n1444237200000000000     3638    90\r\n1444239000000000000     3569    90\r\n1444240800000000000     3665    90\r\n1444242600000000000     3771    23\r\n```\r\n\r\nQuery with only MAX:\r\n```\r\nname: cpu_coreUtilization_average-percent\r\ntags: server=xxx\r\ntime                    max     count\r\n----                    ---     -----\r\n1444235400000000000     7884    38\r\n1444237200000000000     8377    90\r\n1444239000000000000     8412    90\r\n1444240800000000000     8564    90\r\n1444242600000000000     8448    23\r\n```"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/146415920","html_url":"https://github.com/influxdb/influxdb/issues/4360#issuecomment-146415920","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/4360","id":146415920,"user":{"login":"syepes","id":333081,"avatar_url":"https://avatars.githubusercontent.com/u/333081?v=3","gravatar_id":"","url":"https://api.github.com/users/syepes","html_url":"https://github.com/syepes","followers_url":"https://api.github.com/users/syepes/followers","following_url":"https://api.github.com/users/syepes/following{/other_user}","gists_url":"https://api.github.com/users/syepes/gists{/gist_id}","starred_url":"https://api.github.com/users/syepes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/syepes/subscriptions","organizations_url":"https://api.github.com/users/syepes/orgs","repos_url":"https://api.github.com/users/syepes/repos","events_url":"https://api.github.com/users/syepes/events{/privacy}","received_events_url":"https://api.github.com/users/syepes/received_events","type":"User","site_admin":false},"created_at":"2015-10-08T04:25:52Z","updated_at":"2015-10-08T04:25:52Z","body":"@beckettsean Sorry, I forget to mention the version. I am running the last master version using the tsm1 SE on FreeBSD 10.2"}}