@testing.requires.mysql_fully_case_sensitive
@testing.provide_metadata
def test_case_sensitive_reflection_dual_case_references(self):
    m = self.metadata
    Table('t1', m, Column('some_id', Integer, primary_key=True), mysql_engine='InnoDB')
    Table('T1', m, Column('Some_Id', Integer, primary_key=True), mysql_engine='InnoDB')
    Table('t2', m, Column('id', Integer, primary_key=True), Column('t1id', ForeignKey('t1.some_id', name='t1id_fk')), Column('cap_t1id', ForeignKey('T1.Some_Id', name='cap_t1id_fk')), mysql_engine='InnoDB')
    m.create_all(testing.db)
    eq_(dict(((rec['name'], rec) for rec in inspect(testing.db).get_foreign_keys('t2'))), {'cap_t1id_fk': {'name': 'cap_t1id_fk', 'constrained_columns': ['cap_t1id'], 'referred_schema': None, 'referred_table': 'T1', 'referred_columns': ['Some_Id'], 'options': {}}, 't1id_fk': {'name': 't1id_fk', 'constrained_columns': ['t1id'], 'referred_schema': None, 'referred_table': 't1', 'referred_columns': ['some_id'], 'options': {}}})
@testing.requires.mysql_fully_case_sensitive
@testing.provide_metadata
def test_case_sensitive_reflection_dual_case_references(self):
    m = self.metadata
    Table('t1', m, Column('some_id', Integer, primary_key=True), mysql_engine='InnoDB')
    Table('T1', m, Column('Some_Id', Integer, primary_key=True), mysql_engine='InnoDB')
    Table('t2', m, Column('id', Integer, primary_key=True), Column('t1id', ForeignKey('t1.some_id', name='t1id_fk')), Column('cap_t1id', ForeignKey('T1.Some_Id', name='cap_t1id_fk')), mysql_engine='InnoDB')
    m.create_all(testing.db)
    eq_(dict(((rec['name'], rec) for rec in inspect(testing.db).get_foreign_keys('t2'))), {'cap_t1id_fk': {'name': 'cap_t1id_fk', 'constrained_columns': ['cap_t1id'], 'referred_schema': None, 'referred_table': 'T1', 'referred_columns': ['Some_Id'], 'options': {}}, 't1id_fk': {'name': 't1id_fk', 'constrained_columns': ['t1id'], 'referred_schema': None, 'referred_table': 't1', 'referred_columns': ['some_id'], 'options': {}}})