Class PvtPrefilterRenderer

Assembly: redb.MSSql.Pro.dll

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

Object→PvtPrefilterRenderer

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)