

@testing.requires.parens_in_union_contained_select_wo_limit_offset
def test_order_by_selectable_in_unions(self):
    table = self.tables.some_table
    s1 = select([table]).where((table.c.id == 2)).order_by(table.c.id)
    s2 = select([table]).where((table.c.id == 3)).order_by(table.c.id)
    u1 = union(s1, self).limit(2)
    self._assert_result(u1.order_by(u1.c.id), [(2, 2, 3), (3, 3, 4)])

dataset/ETHPy150Open zzzeek/sqlalchemy/lib/sqlalchemy/testing/suite/test_select.py CompoundSelectTest.test_order_by_selectable_in_unions/VarMisuse@93/114 `s2`->`self`