Details
-
Improvement
-
Status: Resolved
-
Normal
-
Resolution: Fixed
-
None
-
None
-
PuppetDB
-
5
-
HA 2021-01-27, HA 2021-02-10
-
Enhancement
-
The optimize_drop_unused_joins query parameter can now optimize queries that contain a single count function.
-
Needs Assessment
Description
Currently, drop-joins will abort if it sees any function. This is overly simplistic. Most of our joins are left joins, and in that case for a join to affect the result of the query, one of its columns must be extracted to a result or used in a filter. Otherwise, it's safe to drop that join and continue the query.