def test_no_ad_hoc_orderby(self):
        Address, addresses, users, User = (self.classes.Address,
                                           self.tables.addresses,
                                           self.tables.users,
                                           self.classes.User)

        mapper(Address, addresses)
        mapper(User, users, properties=dict(
            addresses=relationship(
                Address),
        ))

        sess = create_session()
        q = sess.query(User).\
            join("addresses").\
            options(joinedload("addresses")).\
            order_by("email_address")

        self.assert_compile(
            q,
            "SELECT users.id AS users_id, users.name AS users_name, "
            "addresses_1.id AS addresses_1_id, addresses_1.user_id AS "
            "addresses_1_user_id, addresses_1.email_address AS "
            "addresses_1_email_address FROM users JOIN addresses "
            "ON users.id = addresses.user_id LEFT OUTER JOIN addresses "
            "AS addresses_1 ON users.id = addresses_1.user_id "
            "ORDER BY addresses.email_address"
        )

        q = sess.query(User).options(joinedload("addresses")).\
            order_by("email_address")

        with expect_warnings("Can't resolve label reference 'email_address'"):
            self.assert_compile(
                q,
                "SELECT users.id AS users_id, users.name AS users_name, "
                "addresses_1.id AS addresses_1_id, addresses_1.user_id AS "
                "addresses_1_user_id, addresses_1.email_address AS "
                "addresses_1_email_address FROM users LEFT OUTER JOIN "
                "addresses AS addresses_1 ON users.id = addresses_1.user_id "
                "ORDER BY email_address"
            )
We assume that all lines with diff greater than 5 * (median diff across all events) are broken
dataset/ETHPy150Open zzzeek/sqlalchemy/test/orm/test_eager_relations.py/EagerTest.test_no_ad_hoc_orderby--crossover with--dataset/ETHPy150Open tp7/Sushi/sushi.py/fix_near_borders