RANK() OVER (ORDER BY x) reversed in recent update

[chaslain]

Context: The "x" column is a scoring column. The higher the score, the rank is closer to 0.

After building a new version of my application (but not updating the version of the sqlite package), the version was and still is v1.14.22, I noticed that I am getting opposite query ordering as before my application update.

I reverted to the old code and noticed the issue still persisted, but it did not occur in production.

I pulled down the production binary and ran it locally, noticing that the the production version, when ran locally, gave the correct result. The two versions have the exact same query.

I am guessing this is to do with a portion of the C libraries. I notice in the sqlite3 command line, the output matches how it is now.

Was this a bug fix? Is this the correct behavior?

Since even with the old version of the code, I cannot replicate the older behavior, but I can with the older production binary, what on my disk changed to make the change to ORDER BY x DESC rather than ORDER BY x?