()
| 408 | |
| 409 | |
| 410 | def test_implicit_selfjoin(): |
| 411 | tab = T( |
| 412 | """ |
| 413 | a | b |
| 414 | x | 11 |
| 415 | y | 12 |
| 416 | """ |
| 417 | ) |
| 418 | assert_table_equality( |
| 419 | pw.sql( |
| 420 | "SELECT t1.a, t2.b FROM tab t1, tab t2", |
| 421 | tab=tab, |
| 422 | ), |
| 423 | tab.join(tab.copy()).select(pw.left.a, pw.right.b), |
| 424 | ) |
| 425 | |
| 426 | |
| 427 | def test_explicit_join(): |