mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
77ea99a4b5
This bug affected queries containing degenerated single-value subqueries with window functions. The bug led mostly to wrong results for such queries. A subquery is called degenerated if it is of the form (SELECT <expr>...). For degenerated subqueries of the form (SELECT <expr>) the transformation (SELECT <expr>) => <expr> usually is applied. However if <expr> contains set functions or window functions such rewriting is not valid for an obvious reason. The code before this patch erroneously applied the transformation when <expr> contained window functions and did not contain set functions. Approved by Rex Johnston <rex.johnston@mariadb.com> |
||
|---|---|---|
| .. | ||
| include | ||
| r | ||
| t | ||
| my.cnf | ||
| suite.pm | ||