You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
when selecting top(value,0) or bottom(value,0) it returns Internal Error: runtime error: index out of range. which is not very descriptive.
it should be something like Error: should at least return 1 value or Error: count should be 1 or higher or something.
$ cat influx-issue-988.sql
create db issue-988
\db issue-988
bind
insert into demo values (60000, 0, 10)
insert into demo values (120000, 0, 10)
insert into demo values (300000, 0, 10)
select * from demo
select time, top(value,0) from demo group by time(60s) fill(null) where time > 60s and time < 300s
select time, top(value,1) from demo group by time(60s) fill(null) where time > 60s and time < 300s
select time, bottom(value,0) from demo group by time(60s) fill(null) where time > 60s and time < 300s
select time, bottom(value,1) from demo group by time(60s) fill(null) where time > 60s and time < 300s
delete db issue-988
$ cat influx-issue-988.sql | influx-cli
create db issue-988
\db issue-988
bind
insert into demo values (60000, 0, 10)
insert into demo values (120000, 0, 10)
insert into demo values (300000, 0, 10)
select * from demo
## demo
time sequence_number value
300000.000000 0.000000 10.000000
120000.000000 0.000000 10.000000
60000.000000 0.000000 10.000000
select time, top(value,0) from demo group by time(60s) fill(null) where time > 60s and time < 300s
Server returned (400): Internal Error: runtime error: index out of range
select time, top(value,1) from demo group by time(60s) fill(null) where time > 60s and time < 300s
## demo
time top
300000.000000 10
240000.000000 <nil>
180000.000000 <nil>
120000.000000 10
60000.000000 10
select time, bottom(value,0) from demo group by time(60s) fill(null) where time > 60s and time < 300s
Server returned (400): Internal Error: runtime error: index out of range
select time, bottom(value,1) from demo group by time(60s) fill(null) where time > 60s and time < 300s
## demo
time bottom
300000.000000 10
240000.000000 <nil>
180000.000000 <nil>
120000.000000 10
60000.000000 10
delete db issue-988
The text was updated successfully, but these errors were encountered:
when selecting
top(value,0)
orbottom(value,0)
it returnsInternal Error: runtime error: index out of range
. which is not very descriptive.it should be something like
Error: should at least return 1 value
orError: count should be 1 or higher
or something.The text was updated successfully, but these errors were encountered: