Function test_left_join_this

python/pathway/tests/test_joins.py:522–561

()

def test_left_join_this():
    t1 = T(
        """
            | a  | b
          1 | 11 | 111
          2 | 12 | 112
          3 | 13 | 113
          4 | 14 | 114
        """
    )

    t2 = T(
        """
            | a  | d
          1 | 11 | 211
          2 | 12 | 212
          3 | 13 | 213
          4 | 14 | 214
        """
    )

    expected = T(
        """
        a   | t2_a  | s
        11  | 11    | 322
        12  | 12    | 324
        13  | 13    | 326
        14  | 14    | 328
        """
    ).update_types(
        t2_a=Optional[int],
        s=Optional[int],
    )

    res = t1.join_left(t2, t1.a == t2.a).select(
        pw.left.a,
        t2_a=t2.a,
        s=pw.require(pw.left.b + t2.d, t2.id),
    )
    assert_table_equality_wo_index(res, expected)


# all entries match, should work as inner join