FALSE branches do not choose a result.

highlighted = computed this step

FALSE branches are skipped

A FALSE WHEN condition does not choose its THEN value.

FALSE branch skipped\text{FALSE branch skipped}

Read skipped rows

Rows with no TRUE branch use ELSE; that happens for 2 rows.

ELSE rows=2\text{ELSE rows}=2

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

FALSE branches are skipped: base rowsnamescorestatusAda90activeBea40activeCalNULLactiveDee70paused CASE branch evaluationsourcevaluesevaluationsresultresultSource0[Ada, 90, active][{branch:0, truth:TRUE, chosen:yes}, {branch:1, truth:TRUE, chosen:no}]highbranch 01[Bea, 40, active][{branch:0, truth:FALSE, chosen:no}, {branch:1, truth:FALSE, chosen:no}]lowELSE2[Cal, NULL, active][{branch:0, truth:UNKNOWN, chosen:no}, {branch:1, truth:UNKNOWN, chosen:no}]lowELSE3[Dee, 70, paused][{branch:0, truth:FALSE, chosen:no}, {branch:1, truth:TRUE, chosen:yes}]midbranch 1 CASE output rowsnamescorestatusbucketAda90activehighBea40activelowCalNULLactivelowDee70pausedmid CASE factsfactvalueinputRowCount4branchCount2outputRowCount4firstTrueRows2elseRows2nullElseRows0unknownSkipped2rowOrdersource_order

Bea misses both branches

A low score makes both ordered score checks FALSE, so the ELSE value is used.

FALSE then ELSE\text{FALSE then ELSE}

Summary

FALSE means keep checking, then fall through if nothing is TRUE.

fall through\text{fall through}