A working query fails If a time range is added

Store
1

This InfluxDB query has no data to return so I am getting back (image below) five FILL -ed results, as requested:

SELECT mean(value) 
FROM db.autogen.I_MJS_VKM7CU_CNRGXR 
WHERE time > '2019-09-20T14:52:00Z'
GROUP BY time(1s) 
FILL(20) 
LIMIT 5

fillled results

But, if I add a time range to the same query, I get no results, an empty result-set. The GROUP BY(1s) seems to not being executed.

SELECT mean(value) 
FROM db.autogen.I_MJS_VKM7CU_CNRGXR 
WHERE time > '2019-09-20T14:52:00Z' AND time < '2019-09-20T14:55:10Z'
GROUP BY time(1s) 
FILL(20) 
LIMIT 5

no results

I am a so confused. Did I hit a bug?

Using InfluxDB 1.4 and executing the queries with Chronograf.

2

I investigated more in the issue and I found that it fails because there are no points within the requested interval. If I increase the interval to make some point to fall inside, it works. It returns the 5 FILL ed results.
Shouldn’t it work also if no point fall into the given interval?

3

If you’re using a time range, it won’t reach outside that range to fill the results.

4

Thanks for taking time to respond.

The point is that it doesn’t return anything. My common sense says that it should be returning the same as the first query. I don’t expect to search outside the time range to fill the results, just put a “20” in there.

Is this the normal behaviour?

Thanks again.

5

Yes that’s normal, you can’t use InfluxQL to write points.

6

Not trying to write points. Just wondering why those 2 queries are not returning the same exact resulset when it would be the most obvious.