3 ms·
It's not. Assume y.a is the non-nullable primary key, while y.b is the column that may be null. But in this example there might not be a row where y.a = 5. Or
by crazygringo 4y ago
It's not.
Assume y.a is the non-nullable primary key, while y.b is the column that may be null.
But in this example there might not be a row where y.a = 5. Or there might be. But you can't tell.
- tremon 4y agoBut in those cases, you can always tell by including the non-nullable key in your result set. It's already being evaluated, so it's virtually free (only adds to the network transport size).