Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[1.2.0]multiple function with mathematical operator return different line #8072

Closed
kauchy opened this issue Feb 28, 2017 · 2 comments
Closed

Comments

@kauchy
Copy link

kauchy commented Feb 28, 2017

Bug report

System info: [1.2.0, CentOS 7]

Steps to reproduce:

  1. Insert the following data
test value=1 1488252141000000000
test value=2 1488252151000000000
test value=3 1488252161000000000
  1. Call max(),min() function with multiply
SELECT max("value")*1000,min("value")*1000 from test where time>1488252131s

Expected behavior:

time                max  min 
----                ---  ---
1488252131000000000 3000 1000

Actual behavior:

time                max  min 
----                ---  ---
1488252141000000000      1000
1488252161000000000 3000    

Additional info:

if delete the multiply operator,the result is what I expected

SELECT max("value"),min("value") from test where time>1488252131s

time                max min 
----                --- ---
1488252131000000000 3   1 

and in old version(v0.11.0),the result is always return 1 line with start query time.

@jsternberg
Copy link
Contributor

It looks like it somehow got tricked into thinking that you had two selectors and didn't normalize the time for each one. I'll take a look at it.

@jsternberg
Copy link
Contributor

Closing this in favor of #8167.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants