Class PvtPrefilterRenderer
Renders a into the SQL fragment that goes into the WHERE of the
_values scan feeding the pivot aggregate. See docs/PVT_PREFILTER_PLAN.md.
The analysis is provider-agnostic and lives in . This part is
not: SQL Server concatenates with "+" rather than "||". Kept in step with the operator mapping in
: the plain string forms follow the column collation, the IgnoreCase forms
fold case with LOWER (COLLATION.md, BR-6). A prefilter must never be narrower than the filter it
precedes, so the two change together.
public static class PvtPrefilterRenderer
Inheritance
Methods
RenderBranch(string, PvtPrefilterBranch, SqlParameterCollector)
Renders one branch: the structure it belongs to, then every predicate on it.
public static string RenderBranch(string alias, PvtPrefilterBranch branch, SqlParameterCollector collector)
RenderRowFilter(PvtPrefilterPlan, string, SqlParameterCollector)
Branches are ORed: a _values row belongs to exactly one structure, so a disjunction is the
public static string RenderRowFilter(PvtPrefilterPlan plan, string valuesAlias, SqlParameterCollector collector)