Django Rest Framework Database Query Builder Does Not Stable Sort

Warning

This post is more than a year old. Information may be outdated.

A stupid bug on 240809 something that I expected so naturally that took me hours to find out.

I was expecting:

First = Second
Third = Fourth

Think you're good at Django? Guess the answer!

Which is not.

First = Second
Third ≠ Fourth

This really made me pull my hair off.

This is because Order By is not sorting itself, but rather a query builder. While I understand the reason behind it, I still think it's counterintuitive.