Bar graph display issue when using mysql as datasource

Grafana version: 6.7.0
Data source: memsql (mysql fork)

Putting together a bar graph panel that shows a sum of volume by date grouped by products, in table form, the values come out correctly but the graphs are messy blobs see below (note, picture is sanitized):

when displaying as a bar graph it becomes big blobs of colour:

it gets even worse if i try to stack the values:

The underlying data comes up the exact same in table form when using either influx or memsql(mysql). In graph form the memsql(mysql) data is messed up.

Sample data that generated the above graphs: