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

SHOW DATABASES returns duplicates #19984

Closed
stuartcarnie opened this issue Nov 11, 2020 · 0 comments · Fixed by #20017
Closed

SHOW DATABASES returns duplicates #19984

stuartcarnie opened this issue Nov 11, 2020 · 0 comments · Fixed by #20017
Assignees
Labels
area/compat-v1x v1.x compatibility related work in v2.x area/2.x OSS 2.0 related issues and PRs

Comments

@stuartcarnie
Copy link
Contributor

stuartcarnie commented Nov 11, 2020

What

When there are multiple DB/RP mappings with the same database name, SHOW DATABASES incorrectly returns duplicates. Note telegraf appears twice in the following results:

{
  "results": [
    {
      "statement_id": 0,
      "series": [
        {
          "name": "databases",
          "columns": [
            "name"
          ],
          "values": [
            [
              "chronograf"
            ],
            [
              "potato"
            ],
            [
              "potatoctl"
            ],
            [
              "telegraf"
            ],
            [
              "telegraf"
            ]
          ]
        }
      ]
    }
  ]
}

This results in duplicates in Chronograf 1.x:

Screen Shot 2020-11-10 at 6.37.56 PM.png

@stuartcarnie stuartcarnie added area/2.x OSS 2.0 related issues and PRs area/compat-v1x v1.x compatibility related work in v2.x labels Nov 11, 2020
@stuartcarnie stuartcarnie self-assigned this Nov 11, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/compat-v1x v1.x compatibility related work in v2.x area/2.x OSS 2.0 related issues and PRs
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant