@Test
  public void testComparisonExpressionWithNulls() {
    for (ComparisonExpression.Type type : ComparisonExpression.Type.values()) {
      if (type == ComparisonExpression.Type.IS_DISTINCT_FROM) {
        // IS DISTINCT FROM has different NULL semantics
        continue;
      }

      assertFilter(format("NULL %s NULL", type.getValue()), false);

      assertFilter(format("42 %s NULL", type.getValue()), false);
      assertFilter(format("NULL %s 42", type.getValue()), false);

      assertFilter(format("11.1 %s NULL", type.getValue()), false);
      assertFilter(format("NULL %s 11.1", type.getValue()), false);
    }
  }