[
https://issues.apache.org/jira/browse/IOTDB-4212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
QiangShaowei reassigned IOTDB-4212:
-----------------------------------
Assignee: QiangShaowei
> avg select sample is not correct, has more brackets
> ---------------------------------------------------
>
> Key: IOTDB-4212
> URL: https://issues.apache.org/jira/browse/IOTDB-4212
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Client/JDBC
> Reporter: QiangShaowei
> Assignee: QiangShaowei
> Priority: Major
>
> [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)
