Missing User Warnings
Low
- Confidence
- 90% confidence
- Finding
- The guidance recommends setting `join_use_nulls = 0` for performance and simpler handling, but it does not clearly warn that this changes outer-join semantics by replacing missing matches with type default values such as `''` or `0`. In an analytics/database skill, this can cause users to misinterpret missing relationships as real values, leading to incorrect aggregations, filtering, data quality decisions, or application logic bugs with security or business impact.
