Skip to content
This repository has been archived by the owner on Jan 28, 2021. It is now read-only.

Test grafana with go-mysql-server and add integration tests with the queries used by the application itself. #467

Closed
ajnavarro opened this issue Oct 18, 2018 · 2 comments
Assignees
Labels
enhancement New feature or request

Comments

@ajnavarro
Copy link
Contributor

No description provided.

@ajnavarro ajnavarro added the enhancement New feature or request label Oct 18, 2018
@ajnavarro ajnavarro changed the title Test grafana with go-mysql-server and add integration tests with the queries used. Test grafana with go-mysql-server and add integration tests with the queries used by the application itself. Oct 18, 2018
@jfontan jfontan self-assigned this Oct 18, 2018
@jfontan
Copy link
Contributor

jfontan commented Oct 18, 2018

Time format used by grafana to do filtering is not supported:

This query in grafana:

SELECT commit_author_when as time, commit_hash from commits WHERE $__timeFilter(commit_author_when) limit 100;

is converted to:

SELECT commit_author_when as time, commit_hash from commits WHERE commit_author_when BETWEEN '2018-10-18T05:22:25Z' AND '2018-10-18T11:22:25Z' limit 100;

Gives error:

ERROR 1105 (HY000): unknown error: value "2018-10-18T05:22:25Z" can't be converted to time.Time: parsing time "2018-10-18T05:22:25Z" as "2006-01-02 15:04:05": cannot parse "T05:22:25Z" as " "

It also seems to be the format used for time series as I am not able to use time data for graphs.

@jfontan
Copy link
Contributor

jfontan commented Oct 18, 2018

It also executes show table commits but does not seem to be a valid mysql query.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants