Recognises a chasm trap

Mida see tähendab

A path exists, but an optional relationship on it breaks it for some instances, so they silently drop out of every query that follows the path.

Kuidas seda hinnatakse

Flags the deficient case and passes the acceptable one. Deficient: Branch 1:N Account Manager 1:N Account with Account → Account Manager optional: accounts opened online have no path to a branch and vanish from branch totals (row 24's fix can create this) Acceptable: A direct Account → Branch relationship, or a direct-channel branch, so every account reaches exactly one

Tugineb

Explains the connection, fan and chasm trapsK-569 · Teadmine

Vajalik

Recognises a nullable foreign key on a reporting join pathK-628 · Oskus