Comparison Predicates

Equality Matches

Equality keeps exact matches.

highlighted = computed this step

Equality matches

Equality asks whether the row value is exactly the pinned comparison value 7.

qty=7\text{qty}=7

Read TRUE rows

The equality comparison has 2 TRUE rows.

TRUE rows=2\text{TRUE rows}=2

Comparison examples are tiny finite-table transforms with SQL-style TRUE/FALSE/UNKNOWN results; SQL dialect completeness, type coercion, optimizer behavior, indexing, and product claims are out of scope.

Equality matches: base rowsidnameqtycity1alpha3Austin2beta7Boston3gamma7NULL4delta10Denver5epsilonNULLAustin Comparison result per rowsourceleftValueoprightValuetruthoutputRole03eq7FALSEdropped17eq7TRUEkept27eq7TRUEkept310eq7FALSEdropped4NULLeq7UNKNOWNdropped WHERE-style TRUE-only output rowsidnameqtycity2beta7Boston3gamma7NULL Comparison factsfactvalueinputRowCount5trueCount2falseCount2unknownCount1outputRowCount2droppedRowCount3orderedComparisonnowhereKeepsTRUE_only_source_order

Exact value match

Rows with qty 7 are kept; other known values are FALSE.

exact match\text{exact match}

Summary

Equality keeps only exact matches, with NULL handled separately as UNKNOWN.

eq keeps matches\text{eq keeps matches}