use var_samp
as window function cause unexpected error
#52933
Labels
affects-8.1
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
may-affects-7.5
severity/major
sig/planner
SIG: Planner
type/bug
This issue is a bug.
Bug Report
When used with the OVER clause,
var_samp
functions as a window function. When there are non-aggregate columns present, it should not throw an error.MySQL does not throw an error, and TiDB also does not throw errors for functions like
var_pop
andvariance
.1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
The text was updated successfully, but these errors were encountered: