Fixed #24174 -- Fixed extra order by descending

1 files changed, 20 insertions, 0 deletions

diff --git a/tests/ordering/tests.py b/tests/ordering/tests.py
index abb30f43f1..60880b71be 100644
--- a/tests/ordering/tests.py
+++ b/tests/ordering/tests.py
@@ -166,6 +166,26 @@ class OrderingTests(TestCase):
             attrgetter("headline")
         )
 
+    def test_extra_ordering_with_table_name(self):
+        self.assertQuerysetEqual(
+            Article.objects.extra(order_by=['ordering_article.headline']), [
+                "Article 1",
+                "Article 2",
+                "Article 3",
+                "Article 4",
+            ],
+            attrgetter("headline")
+        )
+        self.assertQuerysetEqual(
+            Article.objects.extra(order_by=['-ordering_article.headline']), [
+                "Article 4",
+                "Article 3",
+                "Article 2",
+                "Article 1",
+            ],
+            attrgetter("headline")
+        )
+
     def test_order_by_pk(self):
         """
         Ensure that 'pk' works as an ordering option in Meta.