@testing.fails_on('sqlite', "sqlite autoincremnt doesn't work with composite pks")
@testing.provide_metadata
def test_misordered_lastrow(self):
    metadata = self.metadata
    related = Table('related', metadata, Column('id', Integer, primary_key=True), mysql_engine='MyISAM')
    t6 = Table('t6', metadata, Column('manual_id', Integer, ForeignKey('related.id'), primary_key=True), Column('auto_id', Integer, primary_key=True, test_needs_autoincrement=True), mysql_engine='MyISAM')
    metadata.create_all()
    r = related.insert().values(id=12).execute()
    id_ = r.inserted_primary_key[0]
    eq_(id_, 12)
    r = t6.insert().values(manual_id=id_).execute()
    eq_(r.inserted_primary_key, [12, 1])
@testing.fails_on('sqlite', "sqlite autoincremnt doesn't work with composite pks")
@testing.provide_metadata
def test_misordered_lastrow(self):
    metadata = self.metadata
    related = Table('related', metadata, Column('id', Integer, primary_key=True), mysql_engine='MyISAM')
    t6 = Table('t6', metadata, Column('manual_id', Integer, ForeignKey('related.id'), primary_key=True), Column('auto_id', Integer, primary_key=True, test_needs_autoincrement=True), mysql_engine='MyISAM')
    metadata.create_all()
    r = related.insert().values(id=12).execute()
    id_ = r.inserted_primary_key[0]
    eq_(id_, 12)
    r = t6.insert().values(manual_id=id_).execute()
    eq_(r.inserted_primary_key, [12, 1])