'Couldn't look up columns' vs '[]' responses to similar queries

[denya]

Strange difference in responses to similar queries.
I always expect empty list [] in response, not error, it's obvious.

I have data in series only for day 2014-09-23, default shard, 7d.

Query in the past

# curl -G 'http://localhost:8086/db/mydb/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable  WHERE time < '2014-09-16 13:30:52.000'"
Couldn't look up columns

Query about near future (tomorrow)

# curl -G 'http://localhost:8086/db/mydb/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable  WHERE time > '2014-09-24 10:00:00.000'"
[]

Query about the day after tomorrow

# curl -G 'http://localhost:8086/db/mydb/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable  WHERE time > '2014-09-25 10:00:00.000'"
Couldn't look up columns

[brandoncazander]

+1 I'm having issues with this when graphing multiple series where one or more might not have existed before a certain time.

[mortik]

+1 i'm having the same issue

[kimor79]

Also having similar issues.

influxdb -v
InfluxDB v0.8.3 (git: fbf9a47) (leveldb: 1.15)

curl -X POST 'http://localhost:8086/db?u=root&p=root' -d '{"name": "963"}'

Before sending any data:

curl -G 'http://localhost:8086/db/963/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable WHERE time > now() - 1d";echo
Couldn't look up columns

curl -G 'http://localhost:8086/db/963/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable WHERE time < now() - 1d";echo
Couldn't look up columns

Add a single data point:

curl -X POST 'http://localhost:8086/db/963/series?u=root&p=root' -d '[{"name":"mytable","columns":["value"],"points":[[23]]}]'

Now query:

curl -G 'http://localhost:8086/db/963/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable WHERE time > now() - 1d";echo
[{"name":"mytable","columns":["time","sequence_number","value"],"points":[[1412225752488,8350001,23]]}]

curl -G 'http://localhost:8086/db/963/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable WHERE time < now() - 1d";echo
Couldn't look up columns

curl -G 'http://localhost:8086/db/963/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable WHERE time < now() - 1s";echo
[{"name":"mytable","columns":["time","sequence_number","value"],"points":[[1412225752488,8350001,23]]}]

curl -G 'http://localhost:8086/db/963/series?u=root&p=root' --data-urlencode "q=SELECT time,value FROM mytable WHERE time > now() - 1s";echo
[]

[jvshahid]

@toddboom should we include this issue with #1004

[toddboom]

@jvshahid I think this issue is identical to #1004, so I'm closing this out.