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.

Sign up for GitHub

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

Jump to bottom

Duplicate points when selecting the same measurement from multiple databases #6701

Closed
jsternberg opened this issue May 22, 2016 · 0 comments
Closed

Duplicate points when selecting the same measurement from multiple databases #6701

jsternberg opened this issue May 22, 2016 · 0 comments
Assignees
@jsternberg
Labels
area/queries
Milestone
1.0.0

Comments

@jsternberg
Copy link
Contributor

Bug report

System info: InfluxDB 0.13

Steps to reproduce:

> CREATE DATABASE mydb
> CREATE DATABASE mydb2
> INSERT INTO mydb.default cpu value=2
> INSERT INTO mydb2.default cpu value=3
> SELECT value FROM mydb..cpu, mydb2..cpu
name: cpu
---------
time                    value
1463885292753204667     2
1463885292753204667     2
1463885299713105966     3
1463885299713105966     3

Expected behavior: For each value to only appear once.

Actual behavior: Every value is duplicated in the SELECT.
@jsternberg jsternberg mentioned this issue May 23, 2016
Merged
jsternberg added a commit that referenced this issue May 23, 2016
@jsternberg
Filter out sources that do not match the shard database/retention policy
5e7e0bd 
If you use a statement like this:

    SELECT value FROM one..cpu, two..cpu

It will access both the `one` and `two` databases as if you had selected
the `cpu` measurement twice for both of them. Updated the `tsdb.Shard`
create iterator function to filter out any sources that do not apply to
that shard so this duplication doesn't happen.

Fixes #6701.
@timhallinflux timhallinflux added this to the 1.0.0 milestone Dec 20, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jsternberg jsternberg

Labels
area/queries
Projects
None yet
Milestone
1.0.0
Development

No branches or pull requests
3 participants
@e-dard @jsternberg @timhallinflux