
@jackzampolin Can you tell if this happening for non-mathy queries? Or only mathy/algebra-y ones?
@jaredscheib I think its only happening with math-y ones. Like if I want bytes instead of bits and try to /8.
I've reproduced this on the server ... getting these responses.
{
"queries": [
{
"id": "",
"query": "SELECT count(\"event_id\")/3 as \"event_count_id\" from discource.autogen.discourse_events where time > now() - 7d group by time(1d), \"event_type\"",
"queryConfig": {
"database": "discource",
"measurement": "discourse_events",
"retentionPolicy": "autogen",
"fields": null,
"tags": {},
"groupBy": {
"time": "1d",
"tags": [
"event_type"
]
},
"areTagsAccepted": false,
"rawText": null
},
"queryAST": {
"condition": {
"expr": "binary",
"op": ">",
"lhs": {
"expr": "reference",
"val": "time"
},
"rhs": {
"expr": "binary",
"op": "-",
"lhs": {
"expr": "call",
"name": "now"
},
"rhs": {
"expr": "literal",
"val": "1w",
"type": "duration"
}
}
},
"fields": [
{
"alias": "event_count_id",
"column": {
"expr": "binary",
"op": "/",
"lhs": {
"expr": "call",
"name": "count",
"args": [
{
"expr": "reference",
"val": "event_id"
}
]
},
"rhs": {
"expr": "literal",
"val": "3",
"type": "integer"
}
}
}
],
"groupBy": {
"time": {
"interval": "1d"
},
"tags": [
"event_type"
]
},
"sources": [
{
"database": "discource",
"retentionPolicy": "autogen",
"name": "discourse_events",
"type": "measurement"
}
]
}
}
]
}
This is still a problem for me in 1.3.0
Forget my comment. The install hadn't restarted the service correctly.