| 1165 | ) |
| 1166 | @testing.fails_on("sqlite", "FIXME: unknown") |
| 1167 | def test_union_all(self, connection): |
| 1168 | t1, t2, t3 = self.tables("t1", "t2", "t3") |
| 1169 | |
| 1170 | e = union_all( |
| 1171 | select(t1.c.col3), |
| 1172 | union(select(t1.c.col3), select(t1.c.col3)), |
| 1173 | ) |
| 1174 | |
| 1175 | wanted = [("aaa",), ("aaa",), ("bbb",), ("bbb",), ("ccc",), ("ccc",)] |
| 1176 | found1 = self._fetchall_sorted(connection.execute(e)) |
| 1177 | eq_(found1, wanted) |
| 1178 | |
| 1179 | found2 = self._fetchall_sorted( |
| 1180 | connection.execute(e.alias("foo").select()) |
| 1181 | ) |
| 1182 | eq_(found2, wanted) |
| 1183 | |
| 1184 | def test_union_all_lightweight(self, connection): |
| 1185 | """like test_union_all, but breaks the sub-union into |