fill() does not fill empty series/ timespan

[nicolai86]

When trying to fill a timespan which does not contain any data at all, fill does not fill anything.

For example, given we have an example series, which has only data since today:

SELECT
  SUM(type)
FROM example
  WHERE time > now()-6d and time < now()-1d
GROUP BY time(1d) fill(-1);

will return [] instead of [-1, -1, -1, -1, -1, -1].

Only if there is at least one data point in the queried timeframe will fill work.

[btrepp]

This happened to me today. Surprising result to say the least.

[jvshahid]

what version are you guys using ?

[nicolai86]

0.8.3 on osx & ubuntu

[btrepp]

I'm using the tutum/influxdb docker image. According to the dockerfile thats 0.8.2

[jvshahid]

@dgnorton do you want to take a look at this ?

[dgnorton]

@jvshahid will do

[harobed]

It's work great in Influxdb 0.8.7, thanks.