influxdata / influxdata/influxdb

"SHOW TAG VALUES" returns deleted values

Open
#14,904 7 comments 1 reaction 1 assignee View on GitHub

@serenibyss is already working on this.

Since Sep 7, 2021.

1.x
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

It seems that the "SHOW TAG VALUES" command returns values which have been already deleted.

__Steps to reproduce:__

1. Run latest Docker image: `docker run --rm -p 8086:8086 -it influxdb:1.7.7`
2. Insert and delete test data:
```
export INFLUX_DB='test'
export INFLUX_MMT='testdata'
influx -execute "CREATE database $INFLUX_DB"
influx -database $INFLUX_DB -execute "INSERT $INFLUX_MMT,foo=bar baz=1"
influx -database $INFLUX_DB -execute "INSERT $INFLUX_MMT,foo=bar2 baz=2"
influx -database $INFLUX_DB -execute "DELETE FROM $INFLUX_MMT WHERE foo=bar2"
```
3. List tag values: `influx -database $INFLUX_DB -execute "SHOW TAG VALUES FROM $INFLUX_MMT WITH KEY=foo"`

__Expected output:__

```
name: testdata
--------------
key value
foo bar
```

__Actual output:__

```
name: testdata
--------------
key value
foo bar
foo bar2
```

__Environment info:__

* InfluxDB version: 1.7.7

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.