influxdata / docs.influxdata.com-ARCHIVE

ARCHIVE - 1.x docs for InfluxData
https://archive.docs.influxdata.com/
MIT License
254 stars 292 forks source link

backward WHERE queries #2888

Closed Gnoudini closed 4 years ago

Gnoudini commented 4 years ago
URL for relevant page: https://docs.influxdata.com/influxdb/v1.8/query_language/explore-schema/#run-a-show-series-query-limited-by-time
What products and version are you using: InfluxDB 1.8
Where did you look before opening the issue: At the bottom of the above page where it says "Please, open an issue."

The examples are supposed to limit "results to series in the shard group that contain a timestamp in the last minute" or to return "all series in shard groups that contain a timestamp in the last 28 days", but, respectively, the clauses WHERE time < now() - 1m and WHERE time < now() - 28d are backwards. They could be changed to WHERE now() - 1m < time and WHERE now() - 28d < time.

kelseiv commented 4 years ago

Thank you @Gnoudini! Fixed.