I have occasionally experienced something operating differently than I expected. But I see no incorrect behavior of the TOTAL() function in SQLite 3.35.5 . Hence, I think you will need to provide more details allowing others to replicate your results before you can reasonably expect an explanation for them.