async def METHOD_NAME(self):
    await self.con.execute('RESET ALIAS *')
    tx = self.con.transaction()
    await tx.start()
    try:
        await self.con.execute('''
            ALTER TYPE User {
                # Test that UserOneToOneAlias doesn't block the alter.
                DROP PROPERTY name_len;
            }
        ''')
        await self.con.execute('''
            ALTER TYPE User {
                CREATE PROPERTY aaa := len(
                    'yes' IF __source__ IS User ELSE 'no');
                CREATE PROPERTY name_upper := str_upper(.name);
            }
        ''')
        await self.assert_query_result(
            """
                SELECT User {name, aaa, name_upper};
            """,
            [{
                'name': 'user',
                'aaa': 3,
                'name_upper': 'USER',
            }]
        )
    finally:
        await tx.rollback()