[MDEV-24943] Add FILTER clause Created: 2021-02-22 Updated: 2021-02-22 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Ian Gilfillan | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | Compatibility | ||
| Description |
|
SQL:2003 introduced the FILTER clause, which extends aggregate functions with a WHERE clause. This is supported by PostgreSQL, SQLite and a MySQL extension. See https://modern-sql.com/feature/filter#conforming-alternatives for details. |