Function isExactComparisonValue

packages/db/src/utils/index-optimization.ts:118–120

* Whether a value can be matched exactly by an index lookup, i.e. the index * result for it is not a superset that the caller must re-filter. * * Only `null`/`undefined` are inexact: the WHERE evaluator's three-valued logic * makes any comparison against them UNKNOWN, yet a BTree index stores an

(value: unknown)

 * so the evaluator and the index agree on them and no re-filtering is needed.
 */
function isExactComparisonValue(value: unknown): boolean {
  return value != null
}

/**
 * Whether the collection orders strings using locale collation.