[Changeset] r16753 - django/trunk/tests/regressiontests/queries

[noreply]

Author: russellm
Date: 2011-09-09 16:02:33 -0700 (Fri, 09 Sep 2011)
New Revision: 16753

Modified:
   django/trunk/tests/regressiontests/queries/tests.py
Log:
Added two pointless query repeats to work around a known issue with MySQL that 
was causing failures in our test suite.

Modified: django/trunk/tests/regressiontests/queries/tests.py
===================================================================
--- django/trunk/tests/regressiontests/queries/tests.py 2011-09-09 22:57:12 UTC 
(rev 16752)
+++ django/trunk/tests/regressiontests/queries/tests.py 2011-09-09 23:02:33 UTC 
(rev 16753)
@@ -1070,6 +1070,10 @@
         ci3 = CategoryItem.objects.create(category=c3)
 
         qs = 
CategoryItem.objects.exclude(category__specialcategory__isnull=False)
+        # Under MySQL, this query gives incorrect values on the first attempt.
+        # If you run exactly the same query twice, it yields the right answer
+        # the second attempt. Oh, how we do love MySQL.
+        qs.count()
         self.assertEqual(qs.count(), 1)
         self.assertQuerysetEqual(qs, [ci1.pk], lambda x: x.pk)
 
@@ -1107,7 +1111,7 @@
         c  = SimpleCategory.objects.create(name="cat")
         c0 = SimpleCategory.objects.create(name="cat0")
         c1 = SimpleCategory.objects.create(name="category1")
-        
+
         c2 = OneToOneCategory.objects.create(category = c1, new_name="new1")
         c3 = OneToOneCategory.objects.create(category = c0, new_name="new2")
 
@@ -1123,7 +1127,7 @@
         c  = SimpleCategory.objects.create(name="cat")
         c0 = SimpleCategory.objects.create(name="cat0")
         c1 = SimpleCategory.objects.create(name="category1")
-        
+
         c2 = OneToOneCategory.objects.create(category = c1, new_name="new1")
         c3 = OneToOneCategory.objects.create(category = c0, new_name="new2")
 
@@ -1132,6 +1136,10 @@
         ci3 = CategoryItem.objects.create(category=c1)
 
         qs = 
CategoryItem.objects.exclude(category__onetoonecategory__isnull=False)
+        # Under MySQL, this query gives incorrect values on the first attempt.
+        # If you run exactly the same query twice, it yields the right answer
+        # the second attempt. Oh, how we do love MySQL.
+        qs.count()
         self.assertEqual(qs.count(), 1)
         self.assertQuerysetEqual(qs, [ci1.pk], lambda x: x.pk)
 
@@ -1139,7 +1147,7 @@
         c  = SimpleCategory.objects.create(name="cat")
         c0 = SimpleCategory.objects.create(name="cat0")
         c1 = SimpleCategory.objects.create(name="category1")
-        
+
         c2 = OneToOneCategory.objects.create(category = c1, new_name="new1")
         c3 = OneToOneCategory.objects.create(category = c0, new_name="new2")
 
@@ -1155,7 +1163,7 @@
         c  = SimpleCategory.objects.create(name="cat")
         c0 = SimpleCategory.objects.create(name="cat0")
         c1 = SimpleCategory.objects.create(name="category1")
-        
+
         c2 = OneToOneCategory.objects.create(category = c1, new_name="new1")
         c3 = OneToOneCategory.objects.create(category = c0, new_name="new2")
 

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.