Fix expected index SQL for DESC on MySQL 5.7.

 






 

 


  Review Request #14924
  —
  Created March 17, 2026 and updated 

 




















 

  

   Information

  





 
 

  david
 









 
 

  Django Evolution
 









 
 

  master
 









 
 

  
 









 
 

  
 






 




 

  

   Reviewers

  





 
 

  django-evolution
 









 
 

  
 






 








 





  


 
 

  
While running tests for other issues, I discovered one failing test on

MySQL 5.7 with Django 4.1. The issue here is just one of test

expectations-- It turns out that Django 4.1 introduced a check for

supports_index_column_ordering in Index.create_sql(), which omits

DESC when the database doesn't support it (such as MySQL 5.7). Older

Django versions always emitted DESC regardless.


The test expectation now accounts for this by only omitting DESC on

Django 4.1+ when the feature is unsupported.

 








  


 
 

  
Ran tests against all combinations of Django+MySQL.

 







 









 





  

 


 
 

  



 

  
   


    Summary
    ID

   

  
  

   


    

     

      Fix expected index SQL for DESC on MySQL 5.7.
      
While running tests for other issues, I discovered one failing test on
MySQL 5.7 with Django 4.1. The issue here is just one of test
expectations-- It turns out that Django 4.1 introduced a check for
`supports_index_column_ordering` in `Index.create_sql()`, which omits
`DESC` when the database doesn't support it (such as MySQL 5.7). Older
Django versions always emitted `DESC` regardless.

The test expectation now accounts for this by only omitting `DESC` on
Django 4.1+ when the feature is unsupported.

Testing Done:
Ran tests against all combinations of Django+MySQL.

     


    		
    mtoxnvouqlvuzoqrzpkusrxxwkrkqtmq

   



  
 




 













 









 






  

 



















 




 

  


   

   

    
 
Checks run (2 succeeded)


    
   


  

  

  





 

 flake8
 passed.
 





 

 JSHint
 passed.