Details
-
Bug
-
Resolution: Won't Fix
-
Major
-
Cheshire-Cat
-
Untriaged
-
Centos 64-bit
-
1
-
Unknown
Description
Build 7.0.0-1902
Running the following query:
select stddev_pop ( decimal_field1 ) over( order by decimal_field1 , char_field1 range between unbounded preceding and 2 following ) as wf from bucket_01 where primary_key_id is not null |
produces the following error message:
[
|
{
|
"code": 3220,
|
"msg": "STDDEV_POP window function multiple ORDER BY terms are not allowed.",
|
"query": "select stddev_pop ( decimal_field1 ) over( order by decimal_field1 , char_field1 range between unbounded preceding and 2 following ) as wf from bucket_01 where primary_key_id is not null"
|
}
|
]
|
This error is incorrect and confusing since stddev_pop allows to have multiple ORDER BY terms, but RANGE instruction does not support multiple ORDER BY terms.