SQLite Forum

Select of text that matches scientific notation format automatically converted to number
Login
I think it's not a bug.

Before the cast function, the result has been recorded as 20000. So you are convering 20000 to text.

I think you'd better rebuild the table, and change the column attribute to text.