()
| 101 | |
| 102 | |
| 103 | def test_left_join_015(): |
| 104 | t1 = T( |
| 105 | """ |
| 106 | | a |
| 107 | 1 | 11 |
| 108 | 2 | 12 |
| 109 | 3 | 13 |
| 110 | 4 | 14 |
| 111 | """ |
| 112 | ) |
| 113 | |
| 114 | t2 = T( |
| 115 | """ |
| 116 | | c |
| 117 | 1 | 11 |
| 118 | 2 | 12 |
| 119 | 3 | 13 |
| 120 | 4 | 13 |
| 121 | """ |
| 122 | ) |
| 123 | |
| 124 | expected = T( |
| 125 | """ |
| 126 | | a |
| 127 | 1 | 11 |
| 128 | 2 | 12 |
| 129 | 3 | 13 |
| 130 | 4 | 13 |
| 131 | 5 | |
| 132 | """ |
| 133 | ) |
| 134 | |
| 135 | res = t1.join_left(t2, t1.a == t2.c).select( |
| 136 | a=t2.c |
| 137 | ) # pw.require(t1.a + t2.c, t2.id), |
| 138 | assert_table_equality_wo_index(res, expected) |
| 139 | |
| 140 | |
| 141 | # 14 should not match |