KhaledR57 d0fc15c370 MDEV-24943: Implement FILTER clause support for aggregate functions ...

Aggregates lacked the SQL-standard FILTER clause,
forcing CASE-based workarounds that reduced readability across (sum, avg, count, …).

This update introduces the ability to specify a FILTER clause for aggregate functions,
allowing for more granular control over which rows are included in the aggregation.
Also, improves standards compliance and makes queries clearer and more readable.

The FILTER(WHERE ...) condition may contain any expression allowed in regular WHERE clauses,
except window functions, and outer references.

2026-09-14 18:09:52 +03:00

578 KiB

Raw Permalink Blame History

View Raw