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

Queries results don't have a guaranteed order. #7502

Closed
desa opened this issue Oct 21, 2016 · 1 comment
Closed

Queries results don't have a guaranteed order. #7502

desa opened this issue Oct 21, 2016 · 1 comment

Comments

@desa
Copy link
Contributor

desa commented Oct 21, 2016

Bug report

Version: master@bf0ac92 confirmed that the behavior also existed in 0.11.
OS: OSX

The order that data is returned by a query isn't stable.

> select * from average_temperature limit 10
name: average_temperature
-------------------------
time            degrees location
1439856000000000000 82  coyote_creek
1439856000000000000 85  santa_monica
1439856360000000000 73  coyote_creek
1439856360000000000 74  santa_monica
1439856720000000000 86  coyote_creek
1439856720000000000 80  santa_monica
1439857080000000000 89  coyote_creek
1439857080000000000 81  santa_monica
1439857440000000000 77  coyote_creek
1439857440000000000 81  santa_monica

> select * from average_temperature limit 10
name: average_temperature
-------------------------
time            degrees location
1439856000000000000 85  santa_monica
1439856000000000000 82  coyote_creek
1439856360000000000 74  santa_monica
1439856360000000000 73  coyote_creek
1439856720000000000 80  santa_monica
1439856720000000000 86  coyote_creek
1439857080000000000 81  santa_monica
1439857080000000000 89  coyote_creek
1439857440000000000 81  santa_monica
1439857440000000000 77  coyote_creek

Steps to reproduce:

  1. Clone and Install influx-spec
  2. Run influx-spec data mock_data_dir/ and repeat simple_select returns a failure.
  3. Or run influx-spec data mock_data_dir/.
  4. Using the simple_select database, repeatedly issue the query select * from average_temperature limit 10.

Expected behavior: [What you expected to happen]
Query results should have a stable ordering.

> select * from average_temperature limit 10
name: average_temperature
-------------------------
time            degrees location
1439856000000000000 82  coyote_creek
1439856000000000000 85  santa_monica
1439856360000000000 73  coyote_creek
1439856360000000000 74  santa_monica
1439856720000000000 86  coyote_creek
1439856720000000000 80  santa_monica
1439857080000000000 89  coyote_creek
1439857080000000000 81  santa_monica
1439857440000000000 77  coyote_creek
1439857440000000000 81  santa_monica
@mark-rushakoff
Copy link
Contributor

It looks like the inconsistency in result ordering was a combination of the dataset used and the bug in issue #7482 which has been fixed. Queried data is consistent as of #7484 being merged.

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

No branches or pull requests

2 participants