id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
29559	TransactionTestCase.reset_sequences doesn't reset sequences of auto created ManyToMany models	Oliver Sauder	Oliver Sauder	"Consider following example:

{{{
class Person(models.Model):
    first_name = models.CharField(max_length=20)
    last_name = models.CharField(max_length=20)

    friends = models.ManyToManyField('self')

class AutoIncrementResetTest(TransactionTestCase):
    reset_sequences = True

    def test_autoincrement_reset1(self):
        p = Person.objects.create(first_name='Jack', last_name='Smith')
        self.assertEqual(p.pk, 1)

        p.friends.add(Person.objects.create(first_name='Jacky', last_name='Smith'))
        self.assertEqual(p.friends.through.objects.first().pk, 1)

    def test_autoincrement_reset2(self):
        p = Person.objects.create(first_name='Jack', last_name='Smith')
        self.assertEqual(p.pk, 1)

        p.friends.add(Person.objects.create(first_name='Jacky', last_name='Smith'))
        self.assertEqual(p.friends.through.objects.first().pk, 1)
}}}

Test **test_autoincrement_reset2** will fail with a much higher primary key, indicating that sequence has not been properly reset. Tested this on a Postgres database but I assume this error exist on other databases as well."	Bug	closed	Testing framework	dev	Normal	fixed			Ready for checkin	1	0	0	0	0	0