QiangShaowei created IOTDB-4212:
-----------------------------------
Summary: avg select sample is not correct
Key: IOTDB-4212
URL: https://issues.apache.org/jira/browse/IOTDB-4212
Project: Apache IoTDB
Issue Type: Bug
Components: Client/JDBC
Reporter: QiangShaowei
[https://iotdb.apache.org/zh/UserGuide/Master/Query-Data/Select-Expression.html#嵌套表达式|https://iotdb.apache.org/zh/UserGuide/Master/Query-Data/Select-Expression.html#%E5%B5%8C%E5%A5%97%E8%A1%A8%E8%BE%BE%E5%BC%8F]
{{select avg(*),(avg(*) + 1) * 3 / 2 -1from root.sg1}}
result is :
{{+---------------+---------------+-------------------------------------+-------------------------------------+
|avg(root.sg1.a)|avg(root.sg1.b)|{color:#FF0000}((({color}avg(root.sg1.a) + 1)
* 3) / 2) - 1|{color:#FF0000}((({color}avg(root.sg1.b) + 1) * 3) / 2) - 1|
+---------------+---------------+-------------------------------------+-------------------------------------+
| 3.2| 3.4| 5.300000000000001|
5.6000000000000005|
+---------------+---------------+-------------------------------------+-------------------------------------+
Total line number = 1
It costs 0.007s}}
but when I run it, the result is :
select avg(*), (avg(*) + 1) * 3 / 2 -1 from root.ln3
+---------------+---------------+---------------+---------------+---------------------------------+---------------------------------+---------------------------------+---------------------------------+
|avg(root.ln3.a)|avg(root.ln3.b)|avg(root.ln3.c)|avg(root.ln3.d)|(avg(root.ln3.a)
+ 1) * 3 / 2 - 1|(avg(root.ln3.b) + 1) * 3 / 2 - 1|(avg(root.ln3.c) + 1) * 3 /
2 - 1|(avg(root.ln3.d) + 1) * 3 / 2 - 1|
+---------------+---------------+---------------+---------------+---------------------------------+---------------------------------+---------------------------------+---------------------------------+
| 3.5| 3.5| 3.0| 4.0|
5.75| 5.75|
5.0| 6.5|
+---------------+---------------+---------------+---------------+---------------------------------+---------------------------------+---------------------------------+---------------------------------+
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
