Skip to content
This repository was archived by the owner on Oct 29, 2024. It is now read-only.
This repository was archived by the owner on Oct 29, 2024. It is now read-only.

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

@Buckler89

Description

@Buckler89
  • 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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions