| 1437 | ) |
| 1438 | |
| 1439 | def test_compound(self): |
| 1440 | t1 = table("t1", column("c1"), column("c2"), column("c3")) |
| 1441 | t2 = table("t2", column("c1"), column("c2"), column("c3")) |
| 1442 | self.assert_compile( |
| 1443 | union(t1.select(), t2.select()), |
| 1444 | "SELECT t1.c1, t1.c2, t1.c3 FROM t1 UNION " |
| 1445 | "SELECT t2.c1, t2.c2, t2.c3 FROM t2", |
| 1446 | ) |
| 1447 | self.assert_compile( |
| 1448 | except_(t1.select(), t2.select()), |
| 1449 | "SELECT t1.c1, t1.c2, t1.c3 FROM t1 MINUS " |
| 1450 | "SELECT t2.c1, t2.c2, t2.c3 FROM t2", |
| 1451 | ) |
| 1452 | |
| 1453 | def test_no_paren_fns(self): |
| 1454 | for fn, expected in [ |