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 16054,Unexpected DB Caching Behaviour with MySQL,brendoncrawford,nobody,"This example demonstrates faulty caching behaviour using Django ORM with MySQL... {{{ ## iPython Shell 1 > from django.contrib.auth.models import User ## iPython Shell 2 > from django.contrib.auth.models import User ## iPython Shell 1 > a = User() > a.username = 'foo' > a.email = 'foo@localhost.com' > a.save() > print a.id >> 1 ## iPython Shell 2 > print User.objects.get(pk=1).id >> 1 ## MySQL Shell 1 > SELECT id FROM auth_user WHERE id = 1 >> 1 ## iPython Shell 1 > b = User() > b.username = 'bar' > b.email = 'bar@localhost.com' > b.save() > print b.id #2 ## iPython Shell 2 > print User.objects.get(pk=2).id >> Raises User.DoesNotExist ## MySQL Shell 1 > SELECT id FROM auth_user WHERE id = 2 >> 2 }}} ",Bug,closed,"Database layer (models, ORM)",1.3,Normal,invalid,,django@…,Unreviewed,0,0,0,0,0,0