From e17fa9e877e84e93b699c2bd13ea48dbbb86e451 Mon Sep 17 00:00:00 2001 From: Anssi Kääriäinen Date: Sun, 24 Mar 2013 22:59:44 +0200 Subject: Fixed #20091 -- Oracle null promotion for empty strings --- tests/queries/tests.py | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'tests') diff --git a/tests/queries/tests.py b/tests/queries/tests.py index 806648aa54..cdc26248c9 100644 --- a/tests/queries/tests.py +++ b/tests/queries/tests.py @@ -1785,7 +1785,6 @@ class Queries6Tests(TestCase): # Nested queries are possible (although should be used with care, since # they have performance problems on backends like MySQL. - self.assertQuerysetEqual( Annotation.objects.filter(notes__in=Note.objects.filter(note="n1")), [''] @@ -2824,3 +2823,11 @@ class Ticket20101Tests(TestCase): self.assertTrue(n in qs1) self.assertFalse(n in qs2) self.assertTrue(n in (qs1 | qs2)) + +class EmptyStringPromotionTests(TestCase): + def test_empty_string_promotion(self): + qs = RelatedObject.objects.filter(single__name='') + if connection.features.interprets_empty_strings_as_nulls: + self.assertIn('LEFT OUTER JOIN', str(qs.query)) + else: + self.assertNotIn('LEFT OUTER JOIN', str(qs.query)) -- cgit v1.3