SQLite Forum

ORDER BY not working for a specific DB/table
I told you, nothing to do with SQLite and everything to do WITH HOW FLOATING POINT WORKS. You should read the reference that Keith provided.

You can't store 30.1 and 31.0 exactly, because they cannot be represented exactly as floating point numbers.

So this is not an issue at all.