{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/5796","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/5796/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/5796/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/5796/events","html_url":"https://github.com/influxdata/influxdb/issues/5796","id":135721317,"number":5796,"title":"Last is returning only single value as result.","user":{"login":"goyalr41","id":4401658,"avatar_url":"https://avatars.githubusercontent.com/u/4401658?v=3","gravatar_id":"","url":"https://api.github.com/users/goyalr41","html_url":"https://github.com/goyalr41","followers_url":"https://api.github.com/users/goyalr41/followers","following_url":"https://api.github.com/users/goyalr41/following{/other_user}","gists_url":"https://api.github.com/users/goyalr41/gists{/gist_id}","starred_url":"https://api.github.com/users/goyalr41/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/goyalr41/subscriptions","organizations_url":"https://api.github.com/users/goyalr41/orgs","repos_url":"https://api.github.com/users/goyalr41/repos","events_url":"https://api.github.com/users/goyalr41/events{/privacy}","received_events_url":"https://api.github.com/users/goyalr41/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-23T12:15:39Z","updated_at":"2016-02-23T17:35:03Z","closed_at":null,"body":"As per InfluxDB documentation a point is defined only by its **measurement, tag set, and timestamp**.\r\n\r\nI wrote multiple points as:\r\n```bash\r\ncurl -i -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'Revenue_daily,firstTag=yes price=6666 \r\nRevenue_daily,secondTag=no price=7777'\r\n```\r\n\r\nThe data in influx gets written with same timestamp as expected:\r\n```bash\r\n> SELECT * from Revenue_daily\r\nname: Revenue_daily\r\n-------------------\r\ntime\t\t\tfirstTag\tprice\tsecondTag\r\n1456229169944624586\tyes\t\t6666\t\r\n1456229169944624586\t\t\t7777\tno\r\n```\r\n\r\nNow when performing \"last\" it is only returning one result, **shouldn't it be returning both the results as they have same timestamp**? And shouldn't this be valid for all the functions? \r\n\r\n```bash\r\n> SELECT last(price) from Revenue_daily\r\nname: Revenue_daily\r\n-------------------\r\ntime\tlast\r\n0\t    7777\r\n```"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/187807244","html_url":"https://github.com/influxdata/influxdb/issues/5796#issuecomment-187807244","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/5796","id":187807244,"user":{"login":"goyalr41","id":4401658,"avatar_url":"https://avatars.githubusercontent.com/u/4401658?v=3","gravatar_id":"","url":"https://api.github.com/users/goyalr41","html_url":"https://github.com/goyalr41","followers_url":"https://api.github.com/users/goyalr41/followers","following_url":"https://api.github.com/users/goyalr41/following{/other_user}","gists_url":"https://api.github.com/users/goyalr41/gists{/gist_id}","starred_url":"https://api.github.com/users/goyalr41/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/goyalr41/subscriptions","organizations_url":"https://api.github.com/users/goyalr41/orgs","repos_url":"https://api.github.com/users/goyalr41/repos","events_url":"https://api.github.com/users/goyalr41/events{/privacy}","received_events_url":"https://api.github.com/users/goyalr41/received_events","type":"User","site_admin":false},"created_at":"2016-02-23T17:35:03Z","updated_at":"2016-02-23T17:35:03Z","body":"The version is 0.10.1.\r\nOk the documentation doesn't explicitly mentioned that, if the timestamps are same I thought all the values will be returned irrespective of using `GROUP BY`"}}