Demonstrate issue with union `IS NULL` behaviour

[samuelcolvin]

Basically is null works correctly with unions on scalar values, but not on columns where unions seem to never be null.