Thanks for the bug report. Your analysis is correct - SQLite was holding the value internally as an integer so that it could write it out as an integer into the B-Tree, but then it failed to convert it back to a floating-point number prior to returning it. The problem should be fixed by [check-in 4711fb69547f4f17][1]. [1]: src:/info/4711fb69547f4f17