SQLite Forum

deterministic functions behave differently in version 3.32.1 with python3
Login
Although knowing a function is deterministic will _allow_ the query-planner to avoid multiple calls with the same arguments, as far as I can see, neither of those pages _guarantee_ that a function _won't_ be called multiple times, even if the argument(s) are the same.