Skip to content
This repository has been archived by the owner on Apr 22, 2024. It is now read-only.

Query with time > xxx behaves in the same way as time >= xxx #921

Open
Buckler89 opened this issue Jul 29, 2022 · 0 comments
Open

Query with time > xxx behaves in the same way as time >= xxx #921

Buckler89 opened this issue Jul 29, 2022 · 0 comments

Comments

@Buckler89
Copy link

Buckler89 commented Jul 29, 2022

  • InfluxDB version: InfluxDB shell version: 1.8.2
  • InfluxDB-python version: 5.3.1
  • Python version: Python 3.8.10
  • Operating system version: Ubuntu 20.04

Write in your influxdb at least 2 datapoint:
time value
'2022-07-28 08:59:59.818000' any
'2022-07-28 09:00:00.000000' any

and perform the following quary using thos exat timestamp:

bind_params = {
                'timeFrom_':  timeFrom_.strftime("%Y-%m-%d %H:%M:%S.%f"),
                'timeTo': timeTo.strftime("%Y-%m-%d %H:%M:%S.%f")
            }
df = pd.DataFrame(client.query(f"SELECT * from {retention_policy}.{meas_name} WHERE time > $timeFrom_ and time <= $timeTo limit 86400;", bind_params=bind_params).get_points())

The query return a Dataframe of one row with timestamp 2022-07-28 08:59:59.818000

The expected behavior is to get an empty dataframe since the query uses > timeForm and not >= timeFrom

@Buckler89 Buckler89 changed the title query with time > xxx behaves in the same way as time >= xxx Query with time > xxx behaves in the same way as time >= xxx Jul 29, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant