Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Ordering by time DESC doesn't work properly #4428

Closed
pga23 opened this issue Oct 13, 2015 · 1 comment
Closed

Ordering by time DESC doesn't work properly #4428

pga23 opened this issue Oct 13, 2015 · 1 comment

Comments

@pga23
Copy link

pga23 commented Oct 13, 2015

Below you can find example with return data set ordered in the wrong way:

SELECT * FROM my_metrics ORDER BY time DESC

time count package seq status
2015-10-12T21:04:25Z 85 140c8db92b786400 183 33
2015-10-12T21:00:25Z 85 140c8db92b786400 182 33
2015-10-12T20:56:25Z 85 140c8db92b786400 181 33
2015-10-12T20:52:20Z 85 140c8db92b786400 180 33
2015-10-12T20:48:20Z 85 140c8db92b786400 179 33
2015-10-12T20:44:15Z 85 140c8db92b786400 178 33
2015-10-12T20:40:20Z 85 140c8db92b786400 177 33
2015-10-12T20:36:20Z 85 140c8db92b786400 176 33
2015-10-12T20:32:14Z 85 140c8db92b786400 175 33
2015-10-12T20:28:04Z 85 140c8db92b786400 174 33
2015-10-12T20:23:54Z 85 140c8db92b786400 173 33
2015-10-12T20:19:59Z 85 140c8db92b786400 172 33
2015-10-12T20:15:48Z 85 140c8db92b786400 171 33
2015-10-12T20:11:54Z 85 140c8db92b786400 170 33
2015-10-13T15:36:36Z 85 140cc9befb3e7400 202 33
2015-10-13T15:32:31Z 85 140cc9befb3e7400 201 33
2015-10-13T15:28:21Z 85 140cc9befb3e7400 200 33
2015-10-13T15:20:26Z 85 140cc9befb3e7400 198 33
2015-10-13T15:12:21Z 85 140cc9befb3e7400 196 33
2015-10-13T15:08:21Z 85 140cc9befb3e7400 195 33
2015-10-13T15:04:15Z 85 140cc9331b952200 194 33
2015-10-13T15:04:15Z 85 140cc9befb3e7400 194 33
2015-10-13T15:00:20Z 85 140cc9befb3e7400 193 33
2015-10-13T15:00:20Z 85 140cc9331b952200 193 33
2015-10-13T14:56:20Z 85 140cc9331b952200 192 33
2015-10-13T14:56:20Z 85 140cc9befb3e7400 192 33
2015-10-13T14:48:05Z 85 140cc9331b952200 190 33
2015-10-13T14:43:55Z 85 140cc9331b952200 189 33
2015-10-13T14:43:55Z 85 140cc9befb3e7400 189 33

In above example package are tag, other fields are integer.

With the same data ordering by time ASC work properly.

I use the 0.9.4.2 version of InfluxDB.

@beckettsean
Copy link
Contributor

Closing as duplicate of #4235

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants