Function test_right_join_03

python/pathway/tests/test_joins.py:311–348

()

# as opposed to test 2, column t2_C2 can be computed out of columns of t2
# as such, it should be filled, even if there was no match
def test_right_join_03():
    t1 = T(
        """
            | a  | b
          1 | 11 | 111
          2 | 12 | 112
          3 | 13 | 113
          4 | 13 | 114
        """
    )

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

    expected = T(
        """
        a   | t2_c2  | s
        11  | 121    | 322
        12  | 144    | 324
        13  | 169    | 326
        13  | 169    | 327
            | 196    |
        """
    )

    res = t1.join_right(t2, t1.a == t2.c).select(
        t1.a,
        t2_c2=t2.c * t2.c,
        s=pw.require(t1.b + t2.d, t1.id),
    )
    assert_table_equality_wo_index(res, expected)


# corner case test: if no column is computable with only outer values,