Time is different if I do math on the fields in a SELECT

[scotloach]

Directions

GitHub Issues are reserved for actionable bug reports and feature requests.
General questions should be sent to the InfluxDB Community Site.

Before opening an issue, search for similar bug reports or feature requests on GitHub Issues.
_If no similar issue can be found, fill out either the "Bug Report" or the "Feature Request" section below.
Erase the other section and everything on and above this line.

Bug report

System info: InfluxDB 1.2.2 on Fedora 25

Steps to reproduce:
The following query demonstrates this. If I didn't do the math on the fields, I get a single results row as I would expect.

SELECT MAX("peak")/10.0*8 AS "peak",SUM("gauge")/620602.559674*8 AS "gauge" FROM m WHERE "tag1"="val1" AND time >= '2017-04-25T15:01:10Z' GROUP BY tag2, tag3

Expected behavior:

name: m
tags: tag2=valX, tag3=valY
time                 peak   gauge
----                 ----   -----
2017-04-25T15:01:10Z  3078.4      0.07711215375124872

Actual behavior:

name: m
tags: tag2=valX, tag3=valY
time                 peak   gauge
----                 ----   -----
2017-04-25T15:01:10Z        0.07711215375124872
2017-05-01T01:50:00Z 3078.4

Additional info:

https://community.influxdata.com/t/time-in-response-is-different-if-i-do-math-in-the-select-clause/797

[jsternberg]

This looks like a duplicate of #8167.