6 ms·
This has always made queries unpredictable in many scenarios and it should be a feature to turn nulls off entirely and swap them out with Option<T> instead.
by gxt 2y ago
This has always made queries unpredictable in many scenarios and it should be a feature to turn nulls off entirely and swap them out with Option<T> instead.
- solumunus 2y agoHow would you handle unmatched outer joins?
- masklinn 2y agoa left outer join b yields tuples of (A, Option<B>), a full outer join b yields tuples of (Option<A>, Option<B>)
- benzayb 2y agoBy having a default value (non-null) for each declared type of those columns. Or, the user must define a default value in the query itself. Yes, tedious; but, precise and forces the programmer to really prepare for the "unknown" scenario.