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 tab values with WHERE clause doesn't accept double quotes #10493

Closed
TotallyInformation opened this issue Nov 18, 2018 · 2 comments
Closed

Comments

@TotallyInformation
Copy link

System info:

Raspberry Pi, Rasbian Stretch. Arm v7.

InfluxDB v1.7.1

Steps to reproduce:

Note that this bug is referenced in a closed previous issue:

#5245

  1. Create database with values and tags
  2. Attempt to show tag values but exclude a specific value
  3. Try with the tag value wrapped in single and double quotes

Expected behavior:

Result should be the same whether using single or double quotes.

Actual behavior:

Using double quotes fails to exclude the entry.

Additional info:

pi@pi3:~ $ influx
Connected to http://localhost:8086 version 1.6.4
InfluxDB shell version: 1.7.1
Enter an InfluxQL query
> use environment_db
Using database environment_db
> SHOW TAG VALUES FROM "lights" WITH KEY = "location" WHERE location != 'NA'
name: lights
key      value
---      -----
location Front Hall
location Landing
location Living Room
location Loft Main
location Rear Hall
location Tree
> SHOW TAG VALUES FROM "lights" WITH KEY = "location" WHERE location != "NA"
name: lights
key      value
---      -----
location Front Hall
location Landing
location Living Room
location Loft Main
location NA
location Rear Hall
location Tree
>
@dgnorton dgnorton added the 1.x label Jan 7, 2019
@stale
Copy link

stale bot commented Jul 24, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the wontfix label Jul 24, 2019
@stale
Copy link

stale bot commented Jul 31, 2019

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.

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