Description
What happened?
When trying to add an annotation query (Dashboard > Settings > Annotations) that uses an InfluxDB data source configured with the "SQL" query language, no queries work and an error message title "Query result" but saying only "[object Object]" appears.
Based on some of the extra details below, it looks like the feature just hasn't been implemented yet.
Extra details
The query section of the UI also says "InfluxQL Query" which indicates it's not adapting correctly to the data source (as that's the wrong query language).
When using the browser's inspection tool a more specific error can be seen in the request response:
flightsql: rpc error: code = InvalidArgument desc = Error while planning query: Error during planning: No SQL statements were provided in the query string
The query being made seems to use rawQuery instead of rawSql which I've seen used in similar cases which I suspect might be related.
What did you expect to happen?
The editor for the "Native SQL" mode of InfluxDB should appear and "SQL" queries should then work.
Did this work before?
Probably not since it looks like "SQL" support for the InfluxDB data source is still in alpha.
How do we reproduce it?
- Create InfluxDB data source configured with the "SQL" query language
- Create dashboard and then go to Settings > Annotations
- Try to add any annotation that uses InfluxDB with SQL data source
Is the bug inside a dashboard panel?
No
Environment (with versions)?
Grafana: v12.0.2 (5bda17e)
OS: Linux Mint
Browser: Firefox
Grafana platform?
Docker
Datasource(s)?
InfluxDB
Metadata
Metadata
Assignees
Type
Projects
Status
Status