message: More tests for nulls in joins
diff: @@ -12,9 +12,18 @@ TEST_CASE("Test joins on VARCHAR columns with NULL values", "[join]") {
  Connection con(db);
  con.EnableQueryVerification();
  + result = con.Query("select * from (select NULL::varchar as b) sq1, (select 'asdf' as b) sq2 where sq1.b = sq2.b;");
  + REQUIRE(CHECK_COLUMN(result, 0, {}));
  +
  result = con.Query("select * from (select 42 as a, NULL::varchar as b) sq1, (select 42 as a, 'asdf' as b) sq2 where sq1.b <> sq2.b;");
  REQUIRE(CHECK_COLUMN(result, 0, {}));
  result = con.Query("select * from (select 42 as a, NULL::varchar as b) sq1, (select 42 as a, 'asdf' as b) sq2 where sq1.a=sq2.a and sq1.b <> sq2.b;");
  REQUIRE(CHECK_COLUMN(result, 0, {}));
  +
  + result = con.Query("select * from (select 42 as a, 'asdf' as b) sq2, (select 42 as a, NULL::varchar as b) sq1 where sq1.b <> sq2.b;");
  + REQUIRE(CHECK_COLUMN(result, 0, {}));
  +
  + result = con.Query("select * from (select 42 as a, 'asdf' as b) sq2, (select 42 as a, NULL::varchar as b) sq1 where sq1.a=sq2.a and sq1.b <> sq2.b;");
  + REQUIRE(CHECK_COLUMN(result, 0, {}));
  }
  