()
| 390 | |
| 391 | |
| 392 | def test_surprising_selfjoin(): |
| 393 | tab = T( |
| 394 | """ |
| 395 | a | b |
| 396 | x | 11 |
| 397 | y | 12 |
| 398 | """ |
| 399 | ) |
| 400 | assert_table_equality( |
| 401 | pw.sql( |
| 402 | "SELECT tab1.a AS t1a, tab2.a AS t2a FROM tab1, tab2", |
| 403 | tab1=tab, |
| 404 | tab2=tab, |
| 405 | ), |
| 406 | tab.join(tab.copy()).select(t1a=pw.left.a, t2a=pw.right.a), |
| 407 | ) |
| 408 | |
| 409 | |
| 410 | def test_implicit_selfjoin(): |